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...


IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?



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

Can you please send me the migration related issues .

0 Answers  


hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks

0 Answers  


The business object 6.5 version is possible for created dashboard reports.if possible how is generated universe to dashboard reports

1 Answers  


Can we have multiple domains?

3 Answers  


I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.

1 Answers   Accenture,


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

0 Answers  


what is the difference b/w the refresh and buffered data?

0 Answers  


I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process

2 Answers   Wipro,


In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.

5 Answers  


What would you consider as your biggest achievement and why?

0 Answers  


How to Analyise 'Join' problem and which method is the best to resolve that ?

3 Answers  


How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?

2 Answers  


Categories