tell me about aggregate awareness in detail?
- 2 Answers
- 21328 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
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Explain what are the steps to be taken to schedule the report?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
In banking domain how many Fact tables,Dimension table are present?
Explain about alerts in bos, under what situation we need to use alerts?
what is the difference b/w the refresh and buffered data?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
When we use aggregate awareness function in designer?
Can we configure two instances of CMS pointing to two different CMS system databases?
