in universe perameter u dont give the option multiple
contexts ,what is the impact in report level
Answer Posted / nathan
By having multiple contexts you can utilize the 'multipass'
sql feature. Multipass: Breaking one large SQL into
multiple SQLs.If you are using the star schema with two or
more fact tables,and you enable this feature, BO will
automatically generate two or more SQLs (i.e. one SQL for
each fact table object used in the report). Then the
results will be synchronised in the report. For more on
multipass concept please refer to Ralph Kimball's Lifecycle
toolkit (not modelling)book.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Can we create universe with no cache??
What is thumbnail?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
What is Indexing? how did u implement indexing?
Explain how many universes can be created in a project?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What is a fantrap in business objects?
explain in detail about type 3?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Can you please send me the migration related issues .
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Explain what are the measure objects?