What is the aggrigate navigation ? can anybody explain me
with some practical example?
Answer Posted / vikram
Aggregate Navigation is the process to specify incompatible
objects while using Aggregate awareness function in
designer.
The rules for compatibility are as follows:
• When an object is at the same or higher level of
aggregation as the table, it is compatible with the table.
• When an object is at a lower level of aggregation than
the table (or if it is not at all related to the table), it
is incompatible with the table.
You specify the incompatible objects by using the Aggregate
Navigation
dialog box (Tools > Aggregate Navigation) to specify the
incompatible objects.
You specify incompatible objects using the Aggregate
Navigation as follows:
1. Select Tools > Aggregate Navigation.
The Aggregate Navigation box appears. It consists of two
panes:
• Universe Tables, which lists all the tables of the
universe.
• Associated Objects, which lists all the objects of the
universe.
2. Click an aggregate table in the left pane.
3. In the right pane, select the check box for each
incompatible object.
4. Repeat the above steps for each aggregate table in your
universe.
Note: You select the INCOMPATIBLE objects in the check
boxes and not COMPATIBLE objects.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are the steps to do to use alerts in bo?
Explain difference between zabo and webi?
explain in detail about type 3?
What is the dense rank?
Explain which versions are used in the bo dashboard work?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Explain how many universes can be created in a project?
What is report template in b.o?
Explain about alerts in bos, under what situation we need to use alerts?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What task is 98% of the required work of a business analyst?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain how we drill up week to month?
In banking domain how many Fact tables,Dimension table are present?
What is the profile and package?