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

Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example

1 Answers   IBM,


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

1 Answers  


How can you check the universe?

3 Answers  


can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?

2 Answers  


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

0 Answers  


What happens in BO when a user logs in to Infoview and a rich client like webi?

2 Answers   TCS,


i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest

3 Answers  


what is difference between WEBi Report and Crystal Report?

3 Answers   Cognos, Nucleus Software, Red Cross,


can anybody tell me about issues faced while creating reports

3 Answers   Accenture,


how can we build one report from two data bases

4 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 do u Receive requiremnts from the client?

3 Answers  


Categories