BPC 10.1 EPM Reports structure

[former_member645232]

Hi all,

I have a question about how to build reports in EPM. I have to build a report with two dimensions in the row axis (WBS and Account), in the WBS dimension I have two values (Ex: Marketing and General) and in the account dimension I have to filter by the Marketing and General property. When I build the report this way, BPC shows me all accounts with these teo properties for these two WBS when what I need is to show the WBS "Marketing" for the accounts with property "Marketing" and the WBS "General" for the accounts with property "General", does anyone know how could I manage to achieve that?

Thanks in advance.

Regards.

[former_member186338 · Accepted solution]

But what is the issue?

You need one property in Account like WBS

Fill it with required WBS ID (Marketing or General)

Then in report when you add WBS dimension link it to the WBS property in account dim.

Please read help:

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.38/en-US/88ecac1b9edc4a418cd8ddde6...