Aggregates on BPC generated Cubes
We are on BPC10,Support pack 10.
I wanted to create aggregates on BPC generated cube.Anybody have implemented aggregates on BPC generated cubes?
We are not doing full optimization,as we have transformations on for retraction.
My question here are, Aggregates have any negative impact for BPC functionalities?
After creating aggregates in production system,if we import other tranports,these aggregates would be removed?
Manohar Pappireddy replied
In most of the cases aggregates on BPC cubes do not work.
If your EPM report generates RSDRI query,reads data from aggregates and aggregates are useful in this scenario.
For this,you need to have all the base members in the report.And no custom measures and no dimension formulas.
If any parent hierarchy,custom measure,member formula;MDX query would generated and aggregates are not useful in this scenario.
for more details: