tell me about aggregate awareness in detail?
Answer Posted / 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 |
Post New Answer View All Answers
Can Bo generates the Report from the cubical data Explain?
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
Can you please send me the migration related issues .
Explain in detail about type 2(scd),
Explain what three things do you consider to be the most important factors for a manager?
Explain when to use local filter and when to use global filter?
What is package in BO
Did you face any problems while creating reports? Name? Solutions?
What is the difference between condition & filter?
How to open a universe with out using the Designer ??
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
What is the difference between datawarehousing and businessintelligence?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
What is the difference between absolute and relative div positioning?
Explain is data mart?