Answer / aanonymous

I got the below answer from the document.It may helpful for
everyone.

BusinessObjects Universe Designer XI 3.1 is the next
release of XI 3.0 and contains new enhancements.

• Usability enhancements
• Market compliance enhancements
• Translation Manager enhancements

Usability enhancements

Usability has been improved for Web Intelligence and Web
Intelligence Rich Client. The list of enhancements follows:

• @prompt function enhancement
• @variable function enhancement
• Tables with input columns
• Begin_SQL parameter
• Translation Manager enhancements

@prompt function enhancement

The Universe Designer @prompt function can now be used with
pairs of input values such as: '4':' France ', ‘2’:’US’.
You can type a LOV as a list of pairs of input values and
for the default values for the @Prompt function.

@variable function enhancement

The Universe Designer @variable function now supports the
universe ID as an input variable ('UNVID').

Tables with input columns

Designer can now insert Data Federator generated tables
that contain input columns into the universe. The Web
Intelligence or Query as a Web Service user will be
required to choose values or enter values in order for the
input columns to be calculated.

The data for the input columns can be the following:
• Values hard-coded when you create the universe
• Values provided by the end user (after a prompt), or
selected from a list
• Values provided via a join with another table

Begin_SQL parameter

SQL statements can be prefixed with the Begin_SQL
parameter. The new SQL parameter Begin_SQL can be
configured to insert SQL orders that will be executed
before BusinessObjects-generated SQL statements.

This ensures that the orders are executed before all
generated SQL statements. This function works with any
database that supports passing parameters before the SELECT
statement.

The following are some examples of use:
• Teradata: monitor and manage DB usage based on query
origin details provided within the executed SQL
• Oracle: turn on read only transaction
• Netezza: trigger optimization options

Translation Manager

In BusinessObjects Enterprise XI 3.1, the Translation
Manager user interface is simplified to make it more
intuitive to use while maintaining all the functionality.
User interface enhancements include:

• The three most-used views open automatically to simplify
the window. Other views can be opened when needed.
• Information in the Document Properties view is integrated
in the Language Management view to reduce the number of
views needed.
• The Language Management view is reorganized to make
language selection faster.
• The percentage of translated content is displayed for
each language in the Language Management view.
• The Filter view is reorganized to simplify filtering on
status.
• The Text Editor view is initialized with the source and
previously translated text.
• Untranslated text in the Translation Editor view displays
in blue rather than red. Original content is now displayed
in the original content column.
• The Format Editor is completely re-designed to make it
easy to select default formats, and create a customized
format by using pre-defined formats.
• The wizards for importing and exporting XLIFF files are
streamlined.
• The menus and toolbar are clearer and simpler.

WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?

4 Answers   Ericsson, Nokia,

---

What is the pivot option ? what is the need of it?

1 Answers   Infotech,

---

what is canned universe and canned reports in bo?

1 Answers  

---

what is the difference btween olap and oltp?

6 Answers   CTS, Fujitsu,

---

How to link two different universes ?

3 Answers  

---

What is the definition of derived table ?

2 Answers   JPMorgan Chase,

---

1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.

16 Answers  

---

I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.

3 Answers  

---

What is detailed Object

1 Answers   IBM,

---

hi my question is in a report table how can we write table header without using of individual cell.can we merge column cells togrther??

0 Answers  

---

which is the best way to resolve loop context r alias why?

3 Answers  

---

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

0 Answers  

---