Hi Stefan,

Thanks for your reply... Do you have any sample solution for my problem? I went through feature browser but I could see only Avg, Max, Min & Sum aggregators and not percentage of total... :(

I am looking for result something like shown in attached image....

Thanks.

Rohan

Any news on the above issue (PercentageOfTotalAggregator only working with DoubleSumAggregator and not DecimalSum, Int32Sum etc)? Stefan maybe you can help?

Thanks stefan, I am waiting for the fix.

I am also evaluating the solution offered by Plamen, and although it techically works, there is a huge performance hit on large cubes.

I suspect the constant casting to double is resource intensive.

Do you have any timeframe for the service release?

Hello Spyros,

The next service release is scheduled for the end of June, but I cannot guarantee that the fix will be included there.

...and with the latest service release it works!

I am now evaluating performance, and I have also noticed that the behaviour of the PercentOfTotalAggregator seems a bit strange, but the basic idea is now applicable.

Thanks!

Hello Spyros,

Thank you for your feedback. I am glad that you resolved your issue and I believe that other community members may benefit from this as well.

Thanks again.