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.

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

0 Answers  

---

3.what is alias?

5 Answers   Business Intelligence Analytics, TCS,

---

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

0 Answers  

---

Explain 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  

---

'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.

1 Answers  

---

Explain the difference between union and group?

0 Answers  

---

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

0 Answers   Infosys,

---

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  

---

Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both

2 Answers   Hexaware,

---

What are the different types of Filters available in BUSINESS OBJECTS?

3 Answers  

---

what are the roles and responsibilities of BO Administrator ?

1 Answers   OCS Infotech, TCS, Wipro,

---

Can we use unconnected lookup as dynamic lookup?

1 Answers   TCL,

---