By having multiple contexts you can utilize the 'multipass' sql

in universe perameter u dont give the option multiple
contexts ,what is the impact in report level

Question Posted / nathan

2 Answers
8372 Views
Accenture, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Can more than 1 metric be applied on an analytic in business objects?

1836

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1243

When we use aggregate awareness function in designer?

723

Explain how to execute the plsql procedure from the report by clicking with mouse?

800

Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

742

Explain the difference between union and group?

821

Explain what are the steps to do to use alerts in bo?

796

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?

1683

How to open a universe with out using the Designer ??

7011

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?

10300

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

805

how to create reports on screech?

2254

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha