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 |
What is meaning of fullpath client in business objects?
What are alertors in Business Objects?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Can we Save (save as) WEBI Doc as DESKI?
i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance
what is the difference between input file repository server and output file repository server ?
what is canned universe and canned reports in bo?
What are the types of errors you faced while creating a report from two different data providers
What is global filters and local filters
REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.