EPM Report Editor

[Former Member]

Hi

I want to achieve user requirement on the BPC EPM, by default system shows all members of the inner dimension in row with the outer dimension of the row. E.G

I want to show like below

i.e.Brand 1 will only show brand 1 variants and not brand 2 variants

Please suggest solution

[former_member186338 · Accepted solution]

Please, attach the pictures - you can insert pictures directly  into message...

[former_member186338 · Accepted solution]

P.S. And please explain, what is the relation between inner and outer dimensions! And where this relation is stored?

[Former Member · Accepted solution]

Please find the updated

I want to achieve user requirement on the BPC EPM, by default system shows all members of the inner dimension in row with the outer dimension of the row. E.G

I want to show like below

i.e.Brand 1 will only show brand 1 variants and not brand 2 variants

Please suggest solution

[former_member186338 · Accepted solution]

For inner dimension (BRAND_VARIANT) you have to create property BRAND and fill it with BRAND1, BAND2...

Then for outer dimension BRAND link it to the BRAND property of inner dimension.

Then select members of inner dimension...

[former_member186338 · Accepted solution]

Sample:

Vadim

P.S. But it's required to have One Outer to Many Inner relationship. Inner member can't be related with more then one outer member.

[Former Member · Accepted solution]

Thanks Vadim for the prompt response .... your answer solved the issue.

Thanks Again