How we will see which trap(Chasm trap or Fantrap) was used
in the Universe ?
Answer Posted / aanonymous
In universe structure panel,
Organize the dimension tables and fact tables after making the
possible joins. Look at the
joins and cordialities from Dimension tables to Fact table.
If majority of the joins (one-to-many)towards fact from
dimension table consider as Chasm trap.
If majority of the joins away from the Fact table and
towards dimension table(s) consider as Fan trap
If it is Fan trap, Alias is the recommended method to
resolve the loop, otherwise use the context.
We can use either of that or both of them.
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
Differences between business objects and web intelligence reports?
How to execute the plsql procedure from the report by clicking with mouse?
What is the difference between condition & filter?
what will be the contents for a functional requirements specifications
What is object stores?
what is universe null
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Explain is there any default username & pwd for bo designer & supervisor?
What is the difference in creating filters in designer and business objects?
What is report template in b.o?
What task is 98% of the required work of a business analyst?
Explain what is the difference between business requirement document and use case document.
In banking domain how many Fact tables,Dimension table are present?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Can more than 1 metric be applied on an analytic in business objects?