Interested to Buy Any Domain ? << Click Here >> for more details...
what is aggregate navigation?
- 3 Answers
- 26666 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
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...
How to schedule the report in b.o?
Explain about a time when you discovered a more efficient way to do a work task?
Explain in detail about type 2(scd),
What sort of existing documents should business analysts refer to when starting on a new project?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
How to create Index to the table in the universe designer and how it improves the Query performence
Explain the difference between union and group?
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?
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?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
What is object stores?
What are all difference between business objects 6.5 and xi r2?
What is the difference between absolute and relative div positioning?
