what is aggregate navigation?
Answer Posted / shikha
Whenever we use Aggregate Aware we need to set up
incompatilibities to work it properly (so BusinessObjects
knows what SQL to generate)
For example, There are 2 aggregate tables fact table by
week and by day.If you set up a measure as aggregate aware
from both tables - total quantity for example, the select
might be something like: -
@Aggregate_Aware(sum(week_agg.qty),sum(day_agg.qty))
The week table listed first as this would be the
preference. But as BusinessObjects needs a reason to not go
to the week_agg table, this is done using
incompatibilities. For example the Week Number dimension
object would be compatible with the week_agg table as it
will link to it and the data is held at an appropriate
level to report against it. However the Date dimension
object would be set as incompatible with the week_agg
table, such that when it is selected alongside the Quantity
object, BusinessObjects knows to jump to the next option in
its select definition.
Is This Answer Correct ? | 27 Yes | 3 No |
Post New Answer View All Answers
what is xcelsius architecture?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What Is Snow Flake Schema?
Explain how many universes can be created in a project?
What is the difference between business requirement document and use case document.
How to schedule the report in b.o?
how to prepare the documentation in business objects and where to get the requirement?
When to use local filter and when to use global filter?
can anybody tell me about complicated object you have created
what will be the contents for a functional requirements specifications
What is the difference between condition & filter?
Explain the difference between detect alias and detect context?