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 |
What is the merge dimension?
How to import BIAR file in bo?
how to create metric universe ?
How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.
how do you give security to universe ?
2 Answers InfoStep, Tech Mahindra,
Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
what is difference between WEBi Report and Crystal Report?
3 Answers Cognos, Nucleus Software, Red Cross,
What is the difference between user and versatile user?
any difficulitis have you phase while creating bo reports and how did u solve it
What is the short cut join?
Explain about derived tables?