main purpose of aggregate awareness(not include make
possible of use of aggregate tables)
Answer Posted / 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 |
Post New Answer View All Answers
how get the grand total in master-detail report?
what is universe null
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
How were the reports scheduled and how to resolve unexecuted documents?
how to create reports on screech?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
what is the difference b/w the refresh and buffered data?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
How to restrict password to a user while sending a document in .pdf format
Explain in detail about type 2(scd),
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
how many reports have u created ? explain a few.
What sort of existing documents should business analysts refer to when starting on a new project?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye