Interested to Buy Any Domain ? << Click Here >> for more details...
solve the following loops?
dimension table
fact table fact table
dimension table
link will be there between tables?
- 4 Answers
- 8052 Views
- I also Faced
- E-Mail Answers
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 are the differences between web intelligence reports and crystal reports ?
I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?
What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.
Can anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
How to Analyise 'Join' problem and which method is the best to resolve that ?
How to create predefined filters in B.O.
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu
how do we apply sql query on selected variables?
Explain about a task that really tested your analytical abilities?
What is the local filter and global filter in bo's?
Teradata 
