How we will see which trap(Chasm trap or Fantrap) was used
in the Universe ?
Answers were Sorted based on User's Feedback
Answer / sree
visually we can find out the traps, there is no option is
available in BO designer level.
Fan Trap: it is nothing but One-to-Many joins path is
occured from (fact to Dimension), using aliases we can
resolve the fan trap.
Chasm Trap: it is nothing but Many-to-One join path,
i.e.,single lookup table converging into more than one fact
table is called "chasm trap'. Using context we can resolve
the chasm trap.
Is This Answer Correct ? | 11 Yes | 2 No |
Answer / 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 |
What is the need of live office connector
how do we apply sql query on selected variables?
Explain how we drill up week to month?
am a fresher hw to get real time experience?
what is main functional differences between BO and COGNOs?
what do u mean by variable functions ?
wat is report linking in BO..I know that 2 reports can be linked in BO with the help of writing a HTML code .But how. wat s the code.can u give me the example of code taking e fashion as the simple univers data provider.
how can we overcome by loops?and also is it possible ,one user can different universe
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
every reports have docid,when i export a report docid will change or not?
1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2?