solve the following loops?
dimension table
fact table fact table
dimension table
link will be there between tables?
Answer Posted / 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 |
Post New Answer View All Answers
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
How we drill up week to month?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is the difference between condition & filter?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is thumbnail?
Explain what are the steps to be taken to schedule the report?
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?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Can anybody tell me what are the tuning problems?
what is universe null