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
- 23703 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 |
Hi any done business objects certification.i am expecting some help from them.
How to change the order of prompts in universe?
wat is difference b/w break and section?
7.what is data mart?
I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )
my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it
Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....
What is mean by stored procedure ? and how we can generate stored procedure universe?
What is difference between custom hierarchy and report based hierarchy?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?
I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page. One report will display all the salary details and other report will display only max salary. How will you achieve this.
Teradata 
