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|
Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?
WHAT IS SYNCHRONIZATION IN BOXI?
What three things do you consider to be the most important factors for a manager?
how will you move the universe/report from development to production?
Is it necessary to give joins to the aggrigate tables in the universe?
What is the difference between slice and dice and cross tab report?
hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks
How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?
how can we build one report from two data bases
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?
Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?