Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Aggregates on BPC generated Cubes


Hi,

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?

Thanks,

Manohar

Tags:
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:

http://scn.sap.com/docs/DOC-65252

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question