Question Re: EPM Report Editor in Financial Management Q&A

EPM Report Editor

Former Member — Thu, 05 Nov 2015 11:16:39 GMT

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

Re: EPM Report Editor

former_member186338 — Thu, 05 Nov 2015 11:26:33 GMT

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

Re: EPM Report Editor

former_member186338 — Thu, 05 Nov 2015 11:41:04 GMT

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

Re: EPM Report Editor

Former Member — Thu, 05 Nov 2015 11:42:44 GMT

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

Re: EPM Report Editor

former_member186338 — Thu, 05 Nov 2015 11:52:52 GMT

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...

Re: EPM Report Editor

former_member186338 — Thu, 05 Nov 2015 12:15:08 GMT

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.

Re: EPM Report Editor

Former Member — Thu, 05 Nov 2015 13:57:35 GMT

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

Thanks Again