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 |
What is the drill up , drill down, drill by , drill trough ?
Can we link the Universes from two different sourcess?Explain?
Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important
What is the @script and @variable functions in the universe designer ? can anybody explain me in a simple way?
How do you restrict access to rows of a database?
How to create predefined filters in B.O.
In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is
define universe parameters?
how many micro cubes can a report can have
How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.
is there any limit for rows and columns in cross tab
what is diff between Decode and case ? Give some Example?