What is the purpose of @aggregate aware function?please
draw, how you use the @aggregate aware function
- 6 Answers
- 21819 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 |
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
Hi friends, How many types of dimentions are they ?What are they? Thanks in advance
Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?
rows are hide in deski,what is process,i know hide the colomn it is fulldown menu,formate>table formate>pivote>hide button,but not rows plz any body give the answer?
can i link two Universes having with different connection
What would you consider as your biggest achievement and why?
How to create universe in business objects enterprise 11.5
5.what is slowly changing dimension ?
in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?
How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?
What is the difference between master-detail and Breaks?
What sort of existing documents should business analysts refer to when starting on a new project?
Teradata 
