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
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain in detail about type 2(scd),
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What are the join problems comes appart from loop,chasm & fan Traps
How to open a universe with out using the Designer ??
in sap bi we have wad, then why we go for sap bo
Can we configure two instances of CMS pointing to two different CMS system databases?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
What is the difference between business requirement document and use case document.
What is the difference in creating filters in designer and business objects?
can anybody tell me about complicated object you have created
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Explain about a task that really tested your analytical abilities?
Differences between business objects and web intelligence reports?