on 04-13-2011 7:54 AM
Hi,
I have three objects Business Unit, Department and Revenue
I would like to group by Business Unit and Departement; sum of Revenue.
How to do this in report level?
Please let me know?
Thanks and Regards,
Manjunath N Jogin
Hi Former Member
I think what Arijit Das said i correct. Just qualify that object as a Measure and apply the aggregation for that revenue in the Universe. That will work fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Add three objects in the query and run the report. Then in report level, apply break on Business Unit and Department. I assume that the aggregation is set to sum for Revenue in the universe.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok...
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.
Regards
NK
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.