Is it necessary to give joins to the aggrigate tables in
the universe?
Answer Posted / gowthami
It is necessary to join the aggregate tables with the dimension. And join should not be there between the aggregate tables(we can not connect the two facts)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What is the difference between absolute and relative div positioning?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain when we use aggregate awareness function in designer?
Explain about a time when you discovered a more efficient way to do a work task?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain the difference between union and group?
is it possible to export the webi reports to crystal reports?with out using businessview?
What we need to discuss with designer before starting the universe designing.
What sort of existing documents should business analysts refer to when starting on a new project?
What is the functional & architectural differences between business objects and web intelligence reports?
can anybody tell me about complicated object you have created
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
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What is difference between custom hierarchy and report based hierarchy?