sap bpc report

[Former Member]

Hi All,

My EPM version is EPM 10 SP32. I wanted to create a BPC report below:

EPM can sort a dimension property only in the option Member Sorting & grouping, and then EPM Local Member cannot create subtotals like the above example. I cannot put static members in the field Product because the report always has different members.

What should I do to create the above report?. Help me, please.

[former_member186338]

"I knew it. I wanted to see the report layout like the above screenshot after refreshing data so that users no need to do manual formatting/inserting subtotals. Do you have a advise for creating subtotal?"

You can perform Excel Sorting and Excel subtotals after report refresh using VBA code.

Then before refresh you have to remove Excel sorting and Excel subtotals also using VBA.

EPM will not help.

[former_member186338]

Sorry, once again - local member formulas will not help you!

First you need to perform sorting and grouping by 2 properties. But sorting and grouping is limited to single property only. And this is the correct answer to your question: Not possible!

[former_member186338]

P.S. In Excel table you can sort using Excel Sort first by one column, then by another column etc...

This feature is not available for EPM!

[Former Member]

Hi Vadim,

I knew it. I wanted to see the report layout like the above screenshot after refreshing data so that users no need to do manual formatting/inserting subtotals. Do you have a advise for creating subtotal?.

Thank you.

[Former Member]

Hi Vadim,

Could I use the formula in EPM Local Member?. I am not sure the formula that should use.

Thank You.

[former_member186338]

Unfortunately you can sort and group by single property of some dimension. No way.