Interested to Buy Any Domain ? << Click Here >> for more details...
what is aggregate navigation?
- 3 Answers
- 26806 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
Explain in detail about type 2(scd),
What are the steps to do to use alerts in bo?
what is document design in boxi,have u participate in that
What is report template in b.o?
Explain about a time when you discovered a more efficient way to do a work task?
how to prepare the documentation in business objects and where to get the requirement?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
what is xcelsius architecture?
Explain the data types present in bo and what happens if we implement view in the designer and report?
What is Indexing? how did u implement indexing?
What is the dense rank?
What are all difference between business objects 6.5 and xi r2?
How many universes can be created in a project?
8. How much supervision have you typically received in your previous job?
How to schedule the report in b.o?
