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


Please Help Members By Posting Answers For Below Questions

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?

3127


What is difference between webi and infoview?

613


What Is The Difference Between Oltp And Olap?

674


How to restrict password to a user while sending a document in .pdf format

1859


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

2995






Explain is there any other repository domains rather than universe, security, document?

581


What are the join problems comes appart from loop,chasm & fan Traps

1548


Explain 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)?

539


Did you face any problems while creating reports? Name? Solutions?

3256


in sap bi we have wad, then why we go for sap bo

2774


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

690


what are the day to day activities of BO administrator ?

1972


Explain what is the difference between slice and dice and cross tab report?

605


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

587


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

1969