tell me about aggregate awareness in detail?
Answers were Sorted based on User's Feedback
Answer / vams_gk
Aggregate awareness is a term that describes the ability of
a universe to
make use of aggregate tables in a database. These are
tables that contain
pre-calculated data. You can use a function called
@Aggregate_Aware in the
Select statement for an object that directs a query to be
run against aggregate
tables rather than a table containing non aggregated data.
Using aggregate tables speeds up the execution of queries,
improving the
performance of SQL transactions.
The reliability and usefulness of aggregate awareness in a
universe depends
on the accuracy of the aggregate tables. They must be
refreshed at the same
time as all fact tables.
A universe that has one or more objects with alternative
definitions based on
aggregate tables is said to be “aggregate aware”. These
definitions
correspond to levels of aggregation. For example, an object
called Profit can
be aggregated by month, by quarter, or by year. These
objects are called
aggregate objects.
Queries built from a universe using aggregate objects
return information
aggregated to the appropriate level at optimal speed.
Is This Answer Correct ? | 39 Yes | 4 No |
Answer / ramesh puli
It is an ability to dynamically rewrite sql to the level
granularity is needed to answer business question.
Allows faster query speed.
Is This Answer Correct ? | 16 Yes | 11 No |
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
I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )
HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...
what is isolated joins in check integrity
Explain about a tricky situation for which you found a very simple solution?
Explain about alerts in bos, under what situation we need to use alerts?
WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT
9 Answers Business Intelligence Analytics, SRA,
Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?
HOW DO YOU SCHEDULE THE REPORTS?
Explain about Short cut join?
how to improve the performance of the report