Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of @aggregate aware function?please
draw, how you use the @aggregate aware function
- 6 Answers
- 24118 Views
- Cap Gemini, Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prasanna
An aggregate table is summary table that dba build to execute
querys faster.@aggregate _aware is an function in bo which
takes advantage of aggregate table when ever possible else
it redirects to original fact table.
syntax:
@aggregate_aware(sum(smallest_table),sum(medium
table),sum(biggest_table));
here smallest table is aggregate table because data is
aggregated by various dimensions.and big table is fact table.
| Is This Answer Correct ? | 22 Yes | 7 No |
Answer / chowdary9999
@Aggregate aware function is maily used for speed up the
business objects process.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / katwal
Aggregate awareness is a function that makes the aggregate
functions aware of the granularity of the tables defined in
the physical layer.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / ramakant baviskar
@aggregate aware is nothing but pre-calculated data of summary
tables which is used for speed up query performance.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / ramakant baviskar
@aggregate aware is apply on BO Universe.aggregate aware is nothing but pre-calculated data of summary tables and is for
improve query performance.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / basha
Aggregate awareness is to redirect a query to the Desired table based on query formation in the report
you can use @aggregate_awareness in the select statement for an object
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain in detail about type 1?
how many times can use the union operator in a report?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What sort of existing documents should business analysts refer to when starting on a new project?
Hi any done business objects certification.i am expecting some help from them.
What is the difference b/w the simple Universe and Complex Universe?
What is the slice and dice?
how to solve the incompatible objects and how they are formed actually.
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What is the size of data base?
What are the security level used in BO?
What is the difference between the Webintelligence and desktopintelligence?
Teradata 
