I have to use universes with different database connections in the same application knowing that only one BO Connection can be provided in BO Sync.

Is It Possible?

Please reply asap.

kishoere

• Jul 31st, 2012

Linking the data base in the universe levels

anonymous

• Apr 28th, 2012

according to your question you want data synchronization from two different database..(it means they r not relational data so cant get synchronized anyway)...now if u have one database(relational) b...

Answer Question  Select Best Answer

Hi All, My query take long time for running query/report. How to manage time for running fast report/query?

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Aug 28th, 2012

Query Performance: I would say you should check first SQL and run against directly to the database and note that it is taking the same time to fetching the data. 2) Try to avoid extra prompt in your r...

Krishna

• Dec 1st, 2011

Check your Sql Query for all Data providers in your report

In Groupby is there any measure you have.

If you have measure objects in groupby then it will take too much time run the report.

Answer Question  Select Best Answer

Difference between Foreach and Forall?

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Aug 28th, 2012

There are major Three Context Operator use in the calculation.
ForAll : Operator Remove the Dimension form the Calculation context.
ForEach : Operator Add the Dimension From the Calculation Context.
In : Operator give you calculation from the scratch.

dasu.kaveri

 Profile Answers by dasu.kaveri Questions by dasu.kaveri

• Oct 27th, 2010

Both ForEach and ForAll Operatators are context operators.ForEach allows us to define groups within the data context for our calculations.Whereas ForAll allows us to instruct Business Objects which dimensions in the report context will not affect our calculations.

Answer Question  Select Best Answer

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Aug 28th, 2012

To my Understanding Crystal Report is older then Webi and it has more user friendly Connection available compare than webi. Custom formatting, Wide range of Variable, Predefined Filter, Printer and etc.... It usually use for Transitional data.

kiran

• Feb 29th, 2012

In WEBI we don't have add command option ,in crystal report we have add command option.

Answer Question  Select Best Answer

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Aug 28th, 2012

When Query fired very first time it hits directly against the Database and then its fetch all data and store into one MICROCUBE. MicroCube basically a temp place holder where all the Possible dimensio...

suresh

• Feb 29th, 2012

Micro cube is the one which stores the results of the query. each data provider stores it results as/ in the micro cube when we create the query in the query panel. you can access the micro cube in ...

Answer Question  Select Best Answer

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Aug 28th, 2012

Dashboard is basically a Plate form where all the component represent the Progress. ScoreCard is a component which shows KPIs of the Company and give them better look in order to have good decision. l...

Answer Question  Select Best Answer

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Aug 30th, 2012

when you have a restriction and you dont want to bound the variable or Object then you need to make Predefine filter in Universe. For example. you have city Object and there is couple of people using ...

VP

• Apr 2nd, 2012

There are 4 filters

Pre defined filters
custom filters
prompts filters
quick filters

Pre defined filters are created at the Universe level.In the Universe window,select the object,right click ,select condition then enter the condition name and filter conditions

Answer Question  Select Best Answer

If we have two data sources and we have to take two tables form each source and generate one report.

How to do?.

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Aug 30th, 2012

For acheiving this result. You should have at least one common dimension in both Data Provider and data type should be the same. Then you need to click on Merge Dimension icon from menu bar and Dilou...

VP

• Apr 2nd, 2012

Two data source which has two table has to be merged with a common dimension,then build the report

Answer Question  Select Best Answer

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Aug 30th, 2012

It is common Universe problem when you start to built schema to the scratch. Loops & Traps. Loop: it is the close join path circle where you cant out with resolving the loop. In this case you would h...

jee

• Sep 30th, 2011

Chasm trap The Chasm trap occurs when two many to one joins converge on a single table. For example a customer can place many orders/and or place many loans. Fan trap The Fan trap occurs when a one to...

Answer Question  Select Best Answer

shashank

• Dec 13th, 2012

We have to go for 80-20 rule. It means understanding the user requirement first, database, connection secured, table map, join, cardinality, loop, trap, if need then for performance issues we have to create (aggregate, aware,index,derived table,short cut join) test universe

Vyankatesh Valakate

• Oct 20th, 2012

Universe is used for Importing tables, Creating classes, Creating objects, Creating joins, Loops, Fan trap, Chasm trap, Creation of hierarchies, Dimensions, Filters, Breaks, Sections.

Answer Question  Select Best Answer

shashank chakraborty

• Dec 13th, 2012

We can link different data providers in a single report by merged dimension.

hari

• Nov 7th, 2012

Use the merged dimensions to link the data providers. It will give you a dialog for the selection of the dimensions in both data providers. select the dimensions which are alike and merge.

Answer Question  Select Best Answer

Can we have both drill and hyperlink working on same column? Explain

shyam

• Feb 8th, 2013

No We cannot apply both simultaneously. If we want apply Drill and then Hyperlink only Hyperlink will be considered.

Lakshmi

• Jan 22nd, 2013

Yes, we can apply drill and hyperlink in column. First apply drill and then select the column to which you want to apply hyperlink. Right click on the column and select option hyperlink.

Answer Question  Select Best Answer

What is #multivalue and #syntax error in Business Objects

avinash kumar

• Feb 10th, 2013

I need full example of #multivalue error............how the errors r coming..............n how to solve that errors

ag_SRIDHAR_SUBRAMANI

 Profile Answers by ag_SRIDHAR_SUBRAMANI Questions by ag_SRIDHAR_SUBRAMANI

• Sep 24th, 2008

Multivalue error will occur when more than one row comes for one cell. to avoid this issue you have to use Min(), or Max() as per your requirement.Syntax error will occur when available improper formula used in the report.  so you have to correct it first.

Answer Question  Select Best Answer

MAnil

 Profile Answers by MAnil Questions by MAnil

• Mar 17th, 2013

In BO XI 3.1 universe designer... File> Parameters> link tab... add a universe..

poornima

• Apr 18th, 2007

Business Objects Designer is a software tool that allows you to create universes for Web Intelligence and Desktop Intelligence users.Designer provides a connection wizard which allows you to connect t...

Answer Question  Select Best Answer

vishwanath_bhambure

 Profile Answers by vishwanath_bhambure Questions by vishwanath_bhambure

• Oct 18th, 2013

Using Data synchronization.

We have to merge the dimension from both the data providers in the report to generate the report using the two different data providers.

Option 2 :
Make DBLINK between Database A & B and access both the database tables by pointing application to one of the database.

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Oct 7th, 2013

Well, If you are using BO4 then you would need to make to Relational Conn.(RC) point out to required Databases and than you will able to make it Datafoundation (DF) based on two source databases.
Hope it helps.

Answer Question  Select Best Answer

chandra

• Mar 28th, 2014

Hierarchy: It is order series of dimensions in a class. We can do multidimensional analysis if Hierarchy exists in Universe.

Scope of Analysis: we can set limit to the level for Multidimensional Analysis.

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Aug 30th, 2012

There are 3 types of Hierarchies in Universe Design. 1- Time Hierarchy: it represents like Year, Quarter, Month, Week, Day. 2- Geographical Hierarchy: It represents like, country, State, City, Town ...

Answer Question  Select Best Answer

Hello,
is SAP BO being offered as independent BI solution or is it completely integrated into SAP as a replacement for BW. i was told by a BO developer its not being offered as an independent solution for companies not using SAP software.

thanks for your help.

Regards,
Sid

Rajkamal Choudhary

• Jul 18th, 2014

Hi, SAP Business Objects is a independent product although it was independent company earlier. we can buy it without SAP R/3, ECC or SAP BW.

Answer Question  Select Best Answer

bharath

• Oct 21st, 2014

BCA means "broad casting agent" actually this is used for version migrations and backup from of biar files ....but it is in bo3.0 to bo6.0 it upgraded to "import wizard" in boxi 3.1 now latest versi...

morad talouh

• Jul 12th, 2012

Actually bca is used to schedule and deliver reports not for securities. securities are handled by supervisor tool in older versions of bobj. supervisor is the old cmc. please rectify the answer.

Answer Question  Select Best Answer

Akhil Rawat

• Nov 12th, 2014

Yes, we can over write the query after creating a report from the universe. There is an option in Desktop Intelligence and Web Intelligence of Business Objects where we can make the changes in the SQL...

chandra

• Mar 28th, 2014

Yes we can override SQL Query if option "Allow other users edit the Query" is enable in the Edit Query Properties.

Answer Question  Select Best Answer

How to Create a Dashboard?

siva

• Nov 30th, 2014

If you are using Dash Boards tool you can pull the data from different sources and create different type of interactive dash boards and mobile dash boards

Venkat

• Nov 7th, 2014

You can create interactive dashboards using Dashboard Designer

Answer Question  Select Best Answer