Interested to Buy Any Domain ? << Click Here >> for more details...
what is aggregate navigation?
- 3 Answers
- 26963 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
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Explain about a tricky situation for which you found a very simple solution?
Difference between b.o 5.1 and 6.1b?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
How were the reports scheduled and how to resolve unexecuted documents?
What Is Snow Flake Schema?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
What is the difference between the public object&schema object?
what is document design in boxi,have u participate in that
How to open a universe with out using the Designer ??
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
how get the grand total in master-detail report?
what will be the contents for a functional requirements specifications
