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 |
When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?
Hi I am starter in BOXIR2.CAn anyone plz tell me the user identification details to be entered at the time of login to designer/deski
what is master-detail report
Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.
can anybody tell me about issues faced while creating reports
When to use local filter and when to use global filter?
What is the difference between derived table and views? which one gives better performance?
HOW MANY TABLES ARE EXISTED IN WEBI REPORT?
Explain what task is 98% of the required work of a business analyst?
what are the all possible reasons of getting partial result on a webi report?
1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?
How you get the requirement from client?