solve the following loops?
dimension table
fact table fact table
dimension table
link will be there between tables?
- 4 Answers
- 6436 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 |
Explain what sort of existing documents should business analysts refer to when starting on a new project?
1.what is input level context and output level context in webI? 2.what is a cascading prompt? Where will you give this and how? 3. What is External Strategy?
Can we get the data from two different databasess in reporting level?
3.what is alias?
5 Answers Business Intelligence Analytics, TCS,
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
Explain is there any default username & pwd for bo designer & supervisor?
can anybody tell me about issues faced while creating reports
Which versions are used in the bo dashboard work?
Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.
What is the test methodology for testing BO Universes?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Where will you find the address of repository in Business Objects?
Teradata 
