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
How many universes can be created in a project?
Explain when to use local filter and when to use global filter?
What is thumbnail?
in sap bi we have wad, then why we go for sap bo
what are the tables used in health care domain project and columns used in report?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What is difference between custom hierarchy and report based hierarchy?
What three things do you consider to be the most important factors for a manager?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
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....
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
explain in detail about type 3?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Can we configure two instances of CMS pointing to two different CMS system databases?