Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Aliases and Contexts Which once will give the better
performence when resolve the loops?

Answer Posted / vasanth

alias is used when two dim tables and one fact table are there in the loop ,alias is used for one dim table which has less outer joins.

Context are used when there are 2 fact tables and one dim table in the loop,we create context for one join between one fact and dim in the loop.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1186


How were the reports scheduled and how to resolve unexecuted documents?

1836


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

3914


what is document design in boxi,have u participate in that

1304


Explain the difference between compatible and incompatible objects?

224






Explain the difference between detect alias and detect context?

231


Explain what three things do you consider to be the most important factors for a manager?

213


Can you please send me the migration related issues .

1254


What is object stores?

247


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

1069


Explain is data mart?

235


Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

222


Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

218


What are the steps to do to use alerts in bo?

236


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

246