Question { Accenture, 5858 }

IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

Answer

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

Question { PWC, 6625 }

Can we use two different sources in webirich client to create
A report ? Like universe and excel etc...

Answer

Yes, One can use different sources like Universe, Excel, Bex, Analysis View, Text and WebServices