Interested to Buy Any Domain ? << Click Here >> for more details...
tell me about aggregate awareness in detail?
- 2 Answers
- 22281 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 are the data types present in bo? What happens if we implement view in the designer and report?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Explain difference between zabo and webi?
Explain what is the difference between business requirement document and use case document.
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain is there any default username & pwd for bo designer & supervisor?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain when we use aggregate awareness function in designer?
How to create Index to the table in the universe designer and how it improves the Query performence
When to use local filter and when to use global filter?
is it possible to export the webi reports to crystal reports?with out using businessview?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is thumbnail?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
