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
What is the difference between datawarehousing and businessintelligence?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
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
What sort of existing documents should business analysts refer to when starting on a new project?
Explain about a time when you discovered a more efficient way to do a work task?
Explain what three things do you consider to be the most important factors for a manager?
8. How much supervision have you typically received in your previous job?
U r project in which stage in implementation?
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
How would you format some text using css to be verdana and bold?
Explain is there any other repository domains rather than universe, security, document?
Explain when to use local filter and when to use global filter?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Explain what is aggregate table and aggregate fact table ... Any examples of both?