What is diff b/w Alias and Contexts in which situation we
are using contexts instead of Alias?
Answers were Sorted based on User's Feedback
Answer / sonia
Contexts and Aliases are means to resolve loops/traps in
universe designs. Contexts are used to specify which of the
paths should be used when more than one path is possible
from one table to another in a loop. Contexts are used in
the scenarios where two or more many-to-one joins converge
on a single table. Whereas Aliases are used to resolve the
loops by duplicating the table and defining separate paths
when one-to-many join links to a table which is again
linked to another one-to-many join.
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / saichand
The main diffrence between them is if the loop is formed
between 1 fact table and 2(0r) more dimensions tables,then
create an alias for existing dimension tables.if loop
constitute more than one fact table then in this case go
for contexting.
| Is This Answer Correct ? | 6 Yes | 1 No |
What is aggregate table and aggregate fact table ... Any examples of both?
Explain is there any other repository domains rather than universe, security, document?
what r the disadvanges in boxir2
explain about Prompt with example?
How to hide objects or columns?
WHAT IS INPUT CONTROL IN BO?
My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?
How to execute the plsql procedure from the report by clicking with mouse?
what are the tables used in health care domain project and columns used in report?
CAN A REPOSITORY CONTAINS REPORTS?
What are the types of errors you faced while creating a report from two different data providers
Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.