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

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

Question Posted / vinodkrishnamsetty

2 Answers
13948 Views
I also Faced
E-Mail Answers

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

@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?

4 Answers iGate,

1. what are the differences between prompt at universe level and prompt at report level ? 2. what are the connection types in BOXI ? 3. how do we give the security in universe level ? and report level ? and objects level ? 4. what will happen if we check the 'MULTIPLE SQL STATEMENTS FOR EACH MEASURE' option in Universe SQL parameters ?

2 Answers Mphasis,

HOW MANY TABLES ARE EXISTED IN WEBI REPORT?

3 Answers Polaris,

11.what are the features in BO?

2 Answers IBM, TCS,

HOW DO YOU SCHEDULE THE REPORTS?

5 Answers

I have a report with some hyperlinks,any issue will i get when i migrate this report?

1 Answers Zensar,

IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?

1 Answers AG Technologies,

i want to take a report 10 records per page. How to take it? is there any paging option in BO?

5 Answers Cap Gemini, IBM,

how many micro cubes can a report can have

3 Answers

Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

0 Answers

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

0 Answers

i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest

3 Answers

For more Business Objects Interview Questions Click Here