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
- 23895 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 |
What is the drill up , drill down, drill by , drill trough ?
what is crosstab reporting,slice and dise and drill mode??
What is domain? How many are there in a basic setup? What are they?
I have a report with some hyperlinks,any issue will i get when i migrate this report?
main purpose of aggregate awareness(not include make possible of use of aggregate tables)
what is fantrap and chasmtrap ?
. User wants to modify a report and wants to add additional data. How will you approach.
. In production reports, some dimensions are missing. how do you load these dimensions in production
6.what is conformed dimension? R u used?
Can any one say me wat does"maintanence of universe" means wit?
2 Answers Business Intelligence Analytics, NAL, TCS,
Can anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance
User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.
Teradata 
