Question { 6306 }

what r the advantages of creating the universe?

Answer

The main fact behind creating universes is "Business users
need not have strong SQL back ground. But sometimes they
need to develop reports". In such case the importance of
universe comes. The universe designer needs to have a strong
SQL back ground and he/she will create universe which in
turn has objects like dimensions, measures, etc,...

The business user then uses these objects just by dragging
and dropping in the query editor pane. Dragging, dropping
and running is more easy for him rather than writing SQLs by
his own.

Question { 6955 }

can i link two Universes having with different connection

Answer

I do not know about the linking of universes with two
different connections. But the linking can be done at
reporter level by linking of data providers. We can link the
dimensions and measures of two different universes with 2
different connections by linking the data providers built
upon them.

Question { 14440 }

what is diff between webi,deski,infoview

Answer

Infoview is just a portal through which we can view or
refresh or modify reports.

Web-I is also known as thin client and Desk-I is a thick
client.

Question { 6926 }

can anybody explain me in detail what is the difference
between desktop intelligence and web intelligence in detail?

Answer

Desktop Intelligence is full client. It is 2 tier
architecture, where Web-I is 3 tier with Enterprise server
in between.

Desktop-I and Web-I differs in some syntaxes. E.g: []in
Web-I replaces <> in Deski.

Also scheduling can be done directly in Web-I (Xi R2), where
as we need additional softwares to schedule Deski reports.

You can view the Deski reports in Web-I, but not Web-I
reports in Deski.

Still many more differences.

Question { 6926 }

can anybody explain me in detail what is the difference
between desktop intelligence and web intelligence in detail?

Answer

But we can schedule the Deski reports via Web-I.

Question { TCS, 6376 }

i want to hide a chart in reporting level?
i want to hide a prompt in designer level?

Answer

Chart can be hidden in Desktop-Intelligence as below.

Select the chart -> Format -> Chart -> Appearance -> Check
the Hide block check box and your chart is gone. You can
also conditionally hide your chart by just typing the
condition in the text box provided below this check box.

Question { Patni, 14281 }

what is master-detail report

Answer

Yes. It displays the data section wise. If you have the
following in a report, for e.g. Country, Store, Sales, you
can change it into a master detail report country wise by
dragging and dropping Country as a section when the cursor
shows the text 'Drop here to create a section' you can see
the data country wise.

Question { CTS, 15841 }

what is the difference btween olap and oltp?

Answer

OLAP - Online Analytical Processing, which deals with
analysis of data. It has to deal with historical data too (
for analysis purpose) Not updated frequently. If required
bulk update is allowed.

OLTP - Online Transactional Processing, which deals with
transactions. For e.g. withdrawals at ATM machines. It
involves many transactions. The databases have to be updated
more frequently after the successful completion of a
transaction.

Question { TCS, 13931 }

What is Complex Reports?

Answer

Complex reports are the reports which pull up data from
different sources. Complexity also depends on the data
model and the critical way the report data is going to be
generated.

Question { 4948 }

What is the server based ranking? and its usage?

Answer

The type of ranking is computed even before the records are
fetched to the BO report and hence the performance
increases.

Question { 6650 }

Hai,
Can anyone tell me 'how to use one dataprovider
result as an input to another dataprovider?.
In BO6.5 there is an option like "select query result".
we can use this option in the filter.
but the same thing not available in BO XI webi.
if any one face this problem , can you please share with me
how to do this?
Thanks,
Narmatha.

Answer

Select query result option is not available in Web-I

Question { 6284 }

How to solve the following errors coming in report development?
1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects
are not compatible

Answer

Syntax error: As the name indicates, check the syntax of
the formula used.

Multivalue error: Use some aggregate functions such as Max
(), Min(), Sum(), etc... (but that mainly depends on the
requirement)

#Error: This can be solved by checking the formula. For
e.g. If one has a UserResponse function like this.
UserRepsonse("DP1","Enter a date") and if the date format
id mm/dd/yyyy, then the following formula will lead to
#Error.

ToDate(UserRepsonse("DP1","Enter a date"),"dd/mm/yyyy")

This can be solved by using "mm/dd/yyyy" instead
of "dd/mm/yyyy"

Computation error: This error occurs if we don't have a
required object in the block. Sometimes we don't want a
particular object to be visible. In that case, to avoid
computation error, just include that object in the block
and hide it.

Objects not compatible: In this case, try creating detail
objects and associate them with the necessary dimensions
and instead of placing the objects, place the newly created
detail objects.

Question { Wipro, 12302 }

1.How to convert deski document to webi in infoview?
2.what is connection type for free hand sql?

Answer

1. But not all the desk-I documents are converted to Web-I
through Report conversion tool. If there is any feature
which doesn't available in Web-I is present in the Desk-I
report, then it will not be fully converted, but parially
or not converted depending on the feature.

Question { 6148 }

Briefly describe the steps you would take to use an Excel
file as data to join a Business Objects data provider in a
report?
Thanks in advance....

Answer

1. Create a data provider having personal data file as
source, select the excel file and check 'First row contains
column names'. This'll do.

2. Suppose we want LOVs to be populated from excel,
definitely we 've to build universe out of the excel.

Assumption: Answers are given to Desktop Intelligence
reports.