main purpose of aggregate awareness(not include make
possible of use of aggregate tables)

Answers were Sorted based on User's Feedback



main purpose of aggregate awareness(not include make possible of use of aggregate tables)..

Answer / sai

Aggregate tables are used in the schema in oreder to
inprove the query performance.it is implemented by using
@aggregate_aware()function.these tables carries
precalculated aggregates(measures).it will improve query
performane,so we will get data fastly.refer this link to
know more:
http://www.dwoptimize.com/2007/09/aggregate-awareness.html

Is This Answer Correct ?    16 Yes 0 No

main purpose of aggregate awareness(not include make possible of use of aggregate tables)..

Answer / sonia

Aggregate Awareness is used to avoid having an object
multiple times, in different classes, for the fact table
and the aggregated table.

Is This Answer Correct ?    1 Yes 8 No

Post New Answer

More Business Objects Interview Questions

use scheduler to refresh report.....explain please.....

2 Answers  


My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?

3 Answers   TCS,


how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?

3 Answers   TCS,


What is the difference between the Webintelligence and desktopintelligence?

2 Answers   IBM,


12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?

3 Answers  


How to create an popup in the WEBI report if the report is showing partial result?

2 Answers   Banking, IBM,


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

0 Answers  


tell me about aggregate awareness in detail?

2 Answers   Cap Gemini,


I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?

2 Answers   Patni,


what is fantrap ?

5 Answers   Tech Mahindra,


I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers

1 Answers   IBM,


Explain what three things do you consider to be the most important factors for a manager?

0 Answers  


Categories