Answer Posted / sj
One of the main use of Alias is to solve loop..So consider
you have a loop like A-->B-->C-->D-->A
in this case the loop ends on A.
So create a alias tale of Table A like A_alias and breathe
loop like below
A-->B-->C-->D-->A_alias,in this way loop is removed
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain what are the steps to be taken to schedule the report?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain what task is 98% of the required work of a business analyst?
When to use local filter and when to use global filter?
What are the steps to do to use alerts in bo?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
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?
Explain is there any default username & pwd for bo designer & supervisor?
Give some information on report bursting?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain about a tricky situation for which you found a very simple solution?
Explain how to execute the plsql procedure from the report by clicking with mouse?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain in detail about type 2(scd),