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



solve the following loops? dimension table fact table ..

Answer / kapil

To solve this loop, we should crate two context each for
one fact table.

Is This Answer Correct ?    9 Yes 0 No

solve the following loops? dimension table fact table ..

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

solve the following loops? dimension table fact table ..

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

solve the following loops? dimension table fact table ..

Answer / satya

By creating alias table for one dimension, we can resolve
the loop

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Business Objects Interview Questions

When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?

4 Answers   Wipro,


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

1 Answers  


what is master-detail report

3 Answers   Patni, TCS,


Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.

4 Answers   TCS,


can anybody tell me about issues faced while creating reports

3 Answers   Accenture,






When to use local filter and when to use global filter?

0 Answers  


What is the difference between derived table and views? which one gives better performance?

2 Answers   TCS,


HOW MANY TABLES ARE EXISTED IN WEBI REPORT?

3 Answers   Polaris,


Explain what task is 98% of the required work of a business analyst?

0 Answers  


what are the all possible reasons of getting partial result on a webi report?

3 Answers   L&T,


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?

1 Answers   iGate,


How you get the requirement from client?

3 Answers   TCS,


Categories