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 |
What are the diffrences between Business Objects 5.1 & 6.5 ?
what r the main topics to prepare for the crystal reports? could any on help me? i want to preparing for the interviews? and also send any pdf file?
what are the documentations u r created?
I have a report with some hyperlinks,any issue will i get when i migrate this report?
What is the difference between the Webintelligence and desktopintelligence?
how change the order of prompts in bo xi? eg. i create first prompt with 'year' and second prompt with 'city'. my question is to display the 'city' prompt first .what can i do for it ?
How to delete the duplicate colums in a sql table ?
solve the following loops? dimension table fact table fact table dimension table link will be there between tables?
Can any one say me wat does"maintanence of universe" means wit?
2 Answers Business Intelligence Analytics, NAL, TCS,
What is the dense rank?
. User wants to modify a report and wants to add additional data. How will you approach.
Did you face any problems while creating reports? Name? Solutions?