Steps to create alias and apply
Answers were Sorted based on User's Feedback
Answer / mysticbo
Hi All,
I am new to Universe designing.
I have detected loop. And after reading forums,I understand
I need to create alias of the required table.
I have a few questions:
1) Suppose I create an alias of the table
as "table_name_alias" and create the necessary joins,what
is the next step?
2)DO I need to link the alias table with the original
table? ---No I think
3)DO I simply go to my semantic layer and change the object
definition of the original table and point it
to "table_name_alias".
Will 3) be sufficient if I dont have too many facts tables?
Or do I need to drag the "table_name_alias" and create a
class of that?-- I think NO
Please guide.Thanks:)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
what is performance tunning in BO in report level& designer level?
if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..
What are the errors u have faced in creating reports in business objects and explain some?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.
WHAT IS INPUT CONTROL IN BO?
How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects are not compatible
There are two options to set "max number of rows fetched" from designer, 1. Tools> Options 2. From universe parameters What is the different between these two and why their valus are different?
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?
Can anybody tell me what are the tuning problems?
HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?
how to link 3 fact tables