Interested to Buy Any Domain ? << Click Here >> for more details...
solve the following loops?
dimension table
fact table fact table
dimension table
link will be there between tables?
- 4 Answers
- 8063 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 |
HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain what would you consider as your biggest achievement and why?
Is it mandatory to give a cardinality ? If cardinality is not given what will happen?
CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?
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
can we cretae views in universe level?
What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
I have 4 tables having many to many relationships between the tables? How i can get correct results in the report?
what is a filter?
What is the drill up , drill down, drill by , drill trough ?
Teradata 
