what is aggregate navigation?
- 3 Answers
- 25355 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 universe null
8. How much supervision have you typically received in your previous job?
what is document design in boxi,have u participate in that
what is xcelsius architecture?
How to schedule the report in b.o?
what is the difference b/w the refresh and buffered data?
Explain what are the steps to do to use alerts in bo?
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
When we use aggregate awareness function in designer?
What is a fantrap in business objects?
is it possible to export the webi reports to crystal reports?with out using businessview?
What is the difference between the public object&schema object?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
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
