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.

disadvantages of boxi

2 Answers   Accenture,

---

how many micro cubes can a report can have

3 Answers  

---

Explain what is aggregate table and aggregate fact table ... Any examples of both?

0 Answers  

---

1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?

1 Answers   iGate,

---

any difficulitis have you phase while creating bo reports and how did u solve it

0 Answers  

---

---

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

0 Answers  

---

HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?

2 Answers  

---

What is the use of Surrogate Key in BO?

2 Answers   CTS, IBM,

---

what is merged imension in 6.5 and webi

1 Answers  

---

What is the definition of derived table ?

2 Answers   JPMorgan Chase,

---

I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same

2 Answers  

---

There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance

1 Answers  

---