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
- 23672 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 |
Difference between scope of analysis in webi and in deski?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
can any body tell me how to create Hyperlinks in BO XI R2?
Did you face any problems while creating reports? Name? Solutions?
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
what is the difference between Ranking and sort-out in bo?
how do we apply sql query on selected variables?
What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except
limitaions of cross tab ?
filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?
What is security domain in Business Objects?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Teradata 
