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
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Explain how we drill up week to month?
what is the difference b/w the refresh and buffered data?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Can we Save (save as) WEBI Doc as DESKI?
Explain when to use local filter and when to use global filter?
What sort of existing documents should business analysts refer to when starting on a new project?
What is aggregate table and aggregate fact table ... Any examples of both?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
U r project in which stage in implementation?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain in detail about type 2(scd),
What are the join problems comes appart from loop,chasm & fan Traps
What is difference between custom hierarchy and report based hierarchy?