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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we configure two instances of CMS pointing to two different CMS system databases?

1493


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1614


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

602


What is Indexing? how did u implement indexing?

1820


How would you format some text using css to be verdana and bold?

674






Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2607


Can you please send me the migration related issues .

1650


Explain is there any default username & pwd for bo designer & supervisor?

599


How many universes can be created in a project?

599


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

3926


What is a fantrap in business objects?

583


Difference between zabo and webi?

638


Explain difference between zabo and webi?

656


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1892


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

553