solve the following loops?
dimension table
fact table fact table
dimension table
link will be there between tables?
Answers were Sorted based on User's Feedback
Answer / kapil
To solve this loop, we should crate two context each for
one fact table.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / gs2kumar@gmail.com
Assume fact tables as F1, F2 and dimensions are D1, D2.
D1--<F1>--D2--<F2>--D1 like this we can connect, here loop and traps also will occurs. To resolve we can use context.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / riaz
link like......
dimension table TO 2 fact table1s
this is called "CONFORMED DIMENSION"
dimension table which is connected to multiple fact tables
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / satya
By creating alias table for one dimension, we can resolve
the loop
| Is This Answer Correct ? | 0 Yes | 4 No |
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?
Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.
2 Answers Cap Gemini, Infinity, TCS,
Is it possible to develop reports without Universe access?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
HI ALL, CAN ANY PLEASE TELL ME HOW TO CREATE HYPERLINKS IN WEBI.THANKS IN ADVANCE
Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace
Can Bo generates the Report from the cubical data Explain?
Explain how we drill up week to month?
Explain how to execute the plsql procedure from the report by clicking with mouse?
how to do Ad-hoc reporting ?
Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example