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.
I think the answer by Arijit on 'apply aggregation for measure' is slightly incorrect for a object to behave as a measure.
For your object [Revenue] to behave as a measure i.e do the summing; you need to put the prefix SUM([Revenue]) in the SQL section of the 'Definition' tab in object property.
What Arijit explained is how the measure object will behave/aggregated when any of the dimension object is removed from the block.