IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

Question Posted / riaz

1 Answers
6498 Views
Accenture, I also Faced
E-Mail Answers

IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?..

Can follow two approaches.

1. Aggregate tables are built in the database, which contains the dimension fields(not foreign keys) along with the aggregated measures. In the universe they are present as standalone tables.Aggregate aware function is used to define both the dimensions and measures of such tables

2. No aggregate tables are built in the database level. They contain the normal fact table at different granularities. In the universe, aggregate aware is used only to define the measures and aggregate incompatibility is set accordingly

The first approach is better in terms of performance, since for the higher levels of aggregation, all the information is obtained for a single table. However, a large scale implementation of this approach in a dimensional schema is difficult. In most BI projects, the second approach is preferred

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More Business Objects Interview Questions

disadvantages of boxi

2 Answers Accenture,

U r project in which stage in implementation?

0 Answers Accenture,

what r the advantages of creating the universe?

2 Answers

How many universes are required for a single project,and how many reports are required for a single Universe.

2 Answers

1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2

3 Answers CTS,

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

what is the difference btween olap and oltp?

6 Answers CTS, Fujitsu,

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

2 Answers Banking, IBM,

i want to creat 2way drilling using hyrarchies and hyperlinks...can anyone please help me

0 Answers

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

0 Answers PWC,

when to go for alias and when to go for contexts

4 Answers

How will you know the version of Bo using designer?

4 Answers Tavant Technologies,

For more Business Objects Interview Questions Click Here