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 |
How to restrict the user to refresh or Run the report only 1 time in BO?
1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?
WHAT DOES SQL TAB CONTAIN?
What are the types of errors you faced while creating a report from two different data providers
How to execute the plsql procedure from the report by clicking with mouse?
Explain how we drill up week to month?
What is metrics?
what are cascading prompts explain with steps
WHAT IS SAP BO AND BO?
Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?
limitaions of cross tab ?
how do u migrate BO 6.x to XI ? My Mail id is gunal_prabhu@yahoo.co.in