main purpose of aggregate awareness(not include make
possible of use of aggregate tables)
Answers were Sorted based on User's Feedback
Answer / sai
Aggregate tables are used in the schema in oreder to
inprove the query performance.it is implemented by using
@aggregate_aware()function.these tables carries
precalculated aggregates(measures).it will improve query
performane,so we will get data fastly.refer this link to
know more:
http://www.dwoptimize.com/2007/09/aggregate-awareness.html
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / sonia
Aggregate Awareness is used to avoid having an object
multiple times, in different classes, for the fact table
and the aggregated table.
| Is This Answer Correct ? | 1 Yes | 8 No |
in xir2 how to send reports to end user
Explain difference between zabo and webi?
I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What is the difference between absolute and relative div positioning?
IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me
How many universes will run maximum in single project
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What is scope of analysis ?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What are the Users and User groups?