Interested to Buy Any Domain ? << Click Here >> for more details...
tell me about aggregate awareness in detail?
- 2 Answers
- 22402 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
U r project in which stage in implementation?
What is a bo repository?
Can you please send me the migration related issues .
Can we configure two instances of CMS pointing to two different CMS system databases?
What is top business?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain how to execute the plsql procedure from the report by clicking with mouse?
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
any difficulitis have you phase while creating bo reports and how did u solve it
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What is difference between webi and infoview?
Difference between zabo and webi?
What sort of existing documents should business analysts refer to when starting on a new project?
What is object stores?
