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
- 24115 Views
- Cap Gemini, Deloitte, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain difference between zabo and webi?
Explain when to use local filter and when to use global filter?
What is the difference between absolute and relative div positioning?
Can we configure two instances of CMS pointing to two different CMS system databases?
in sap bi we have wad, then why we go for sap bo
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What are the steps to do to use alerts in bo?
what is the difference b/w the refresh and buffered data?
Can more than 1 metric be applied on an analytic in business objects?
Explain is there any other repository domains rather than universe, security, document?
What is the difference in creating filters in designer and business objects?
can anybody tell me about complicated object you have created
Explain the difference between union and group?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
What is object stores?
