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
- 7696 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 |
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?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How to create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".
any body can give hirarchy of bussness object...i mean who will see reports after reports developing is fineshed...then next....
What is diff between InfoView and Zero BOAdmin (ZABO)?
How to Analyise 'Join' problem and which method is the best to resolve that ?
How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.
What is object stores?
Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?
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 do on drill calculation? Actually My report is like Continent Amount(Global Currency in dollar) ASIA 200 UK 100 On Drill ASIA Country Amount INDIA 5712(120*47.6) SINGAPORE 128(80 * 1.6) On Drill INDIA State Amount DELHI 3712 CHENNAI 2000
What is a Set?
Teradata 
