Hi Pumpactionshotgun ,
I did same thing in webi but revenue field is diplaying all records.
It is not aggreagting (sum) based on Business Unit and Departement.
How to do 'aggregation seting for Revenue in the universe'
I am waiting your replay.
Thanks and Regards,
Manjunath N Jogin
1. Could you please tell me steps to be required to create aggregation in universe level?
2. If I create aggregation for revenue field in univese, does it affect other reports which are already connected to the universe?
for example , one report is just dispalying Business unit, deaprtment, revenue without group and sum.
1. steps to apply aggregation for measure:
a. import the universe in designer.
b. double click on the measure object.
c. in properties tab, select the aggregation function as sum.
d. apply and click ok.
e. save and export the universe.
2. yes. it will affect the reports created on top of the universe and which uses the revenue object. instead of showing all records, this will group the revenue for the dimension combinations.