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
What is difference between custom hierarchy and report based hierarchy?
what is xcelsius architecture?
is it possible to export the webi reports to crystal reports?with out using businessview?
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....
What is the difference between user and versatile user?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain the difference between detect alias and detect context?
Explain is data mart?
Explain how to execute the plsql procedure from the report by clicking with mouse?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
what is universe null
(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.
Did you face any problems while creating reports? Name? Solutions?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Is there any other repository domains rather than universe, security, document?