4.what is aggregate awareness ? how do we use ? where do we
use ?
Answers were Sorted based on User's Feedback
Answer / mrs.narmatha
Aggregate awareness: is the ability of a universe to make
use of aggregate the tables in a database. These tables
have precalculated data
USE:
you can use a function @aggregate_Aware in the select
statement for an object that directs a query to be run
against aggegate tables
This function can be used to speedup the exceution of the
query and to improve the performace of sql transaction
| Is This Answer Correct ? | 33 Yes | 3 No |
Answer / nmr
redirect the query to desired table,
or
improve the performance,
while useing summeriaed table
retrive results with very fast compare then the demension
table
| Is This Answer Correct ? | 0 Yes | 2 No |
how to make a report avilable to other users?
What is drill across ? can anybody explain me in detail?
wha is the difference b/w merge dimension and combining two different data providers?
How can you check the universe?
Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.
How to get top 5 rows of a selected column?
WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?
if we shortcut join between two tables what will be the output?that it will give all columns or same columns?
How to execute the plsql procedure from the report by clicking with mouse?
limitaions of cross tab ?
what is meant by slowly changing dimensions?
how to create metric universe ?