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

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1

4 Answers   IBM,


What is package in BO

0 Answers   Infosys, Saksoft,


What are the errors u have faced in creating reports in business objects and explain some?

3 Answers   TCS,


Explain what is aggregate table and aggregate fact table ... Any examples of both?

0 Answers  


What is a join? Explain different types of joins?

5 Answers  






1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?

1 Answers   BNP Paribas,


what is static filter and dynamic filter

1 Answers  


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

0 Answers  


What are the types of errors you faced while creating a report from two different data providers

3 Answers   IBM,


is it possible to export the webi reports to crystal reports?with out using businessview?

0 Answers   CTC, TCS,


any of the person working on encyclopedia? give the explanation briefly?

1 Answers   TCS,


Can we create universe with no cache??

1 Answers  


Categories