Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

Question Posted / riaz


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

Answer / sachin jain

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

How to hide the table s in webi?can any one tell me plzzzzzzzz

9 Answers   Accenture, TCS,

Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace

1 Answers  

IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?

1 Answers   AG Technologies,

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

7 Answers  

How to fix the order of Prompts? How to assign the default value in prompt?

2 Answers   Mind Tree,

Any body help me...what are challenges did u face in Business object project?

1 Answers  

difference between xir2 and 6.5 version

4 Answers  

What is DSS?? (Defination of DSS)

2 Answers  

What is #DATASYNC error how to remove it?

2 Answers   IBM, TCS,

How to create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".

3 Answers  

How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?

1 Answers   Emphasis,

when and where we use @varialble function

1 Answers  

For more Business Objects Interview Questions Click Here
Categories