i have 2 fact and 2 dimension tables in my universe . my
question is how get the data with two fact tables in a report?
Answer Posted / sivakumar
Two Fact tables can be Joied through an confirmed dimension.
So any of the dimension should have the feature of
confirmed dimension.
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Explain how we drill up week to month?
Explain is there any default username & pwd for bo designer & supervisor?
Explain when we use aggregate awareness function in designer?
Explain about alerts in bos, under what situation we need to use alerts?
How to create Index to the table in the universe designer and how it improves the Query performence
Explain what three things do you consider to be the most important factors for a manager?
What is the difference between condition & filter?
what will be the contents for a functional requirements specifications
What is the difference between absolute and relative div positioning?
How to execute the plsql procedure from the report by clicking with mouse?
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)?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Differences between business objects and web intelligence reports?
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
What is object stores?