what is aggregate navigation?
- 3 Answers
- 25966 Views
- Countrywide, CTS, HCL, I also Faced
- E-Mail Answers
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 a fantrap in business objects?
What is the difference between user and versatile user?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What are the steps to be taken to schedule the report?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is the profile and package?
Explain is there any default username & pwd for bo designer & supervisor?
When to use local filter and when to use global filter?
What is Indexing? how did u implement indexing?
Explain in detail about type 2(scd),
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Difference between b.o 5.1 and 6.1b?
