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 |
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
What is package in BO
What are the errors u have faced in creating reports in business objects and explain some?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What is a join? Explain different types of joins?
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 ?
what is static filter and dynamic filter
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What are the types of errors you faced while creating a report from two different data providers
is it possible to export the webi reports to crystal reports?with out using businessview?
any of the person working on encyclopedia? give the explanation briefly?
Can we create universe with no cache??