What is the purpose of @aggregate aware function?please
draw, how you use the @aggregate aware function
- 6 Answers
- 22761 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
What are all difference between business objects 6.5 and xi r2?
In banking domain how many Fact tables,Dimension table are present?
Difference between b.o 5.1 and 6.1b?
Can we configure two instances of CMS pointing to two different CMS system databases?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Differences between business objects and web intelligence reports?
What Is Snow Flake Schema?
What is Indexing? how did u implement indexing?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What are the steps to be taken to schedule the report?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
What is object stores?
