1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

When we can use multiple sql statement for each measure?
and multiple sql statement for each context?

Question Posted / vinodkrishnamsetty

Answers were Sorted based on User's Feedback



When we can use multiple sql statement for each measure? and multiple sql statement for each cont..

Answer / manju

when your universe having traps then we wil select the options
and when you have dimension objects in one or both fact
tables and universe having traps then we using option
multiple sql statements for each context

when you have measure objects in one or both fact
tables and universe having traps in this case we using option
multiple sql statements for each measure

Is This Answer Correct ?    5 Yes 2 No

When we can use multiple sql statement for each measure? and multiple sql statement for each cont..

Answer / manoj

When your universe is having multiple context or u have
traps then you will select the options.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Business Objects Interview Questions

What is the difference b/w the simple Universe and Complex Universe?

2 Answers  

what do u mean by merged dimensions in Business Objects

2 Answers   Business Intelligence Analytics, TCS,

User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.

1 Answers  

Explain difference between zabo and webi?

0 Answers  

How to get red line in the graph at some point (value)? Example : In graph at 200000 value

1 Answers   Rolta,




suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?

2 Answers   IBM,

What is the most complex report you have developed. Explain and how did you overcome??? Please give some examples

2 Answers   NTT Data,

1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment

3 Answers   Hexaware,

how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how

3 Answers   Keane India Ltd,

WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?

2 Answers   PCS,

what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

2 Answers   HCL, IBM,

Can anybody tell me the difference b/w canned and adhoc reporting?.

5 Answers  

For more Business Objects Interview Questions Click Here
Categories