Showing parent in EPM based on base level member selected

[former_member544285]

Hi Experts,

I have a requirement in which I need to filter ACCOUNT dimension using EPMDimensionOverride. On top of that, the dimension has to show it's parent(s) in hierarchy up to the very top. Illustration of ACCOUNT master data:

• 10000
  • 11000
    • 11100
    • 11200
  • 12000
    • 12100
    • 12200

In case I need to show ACCOUNT 11100, the report must show:

• 10000
  • 11000
    • 11100

In case I need to show ACCOUNT 11200, 12100, 12200, the report must show:

• 10000
  • 11000
  • 11200
  • 12000
    • 12100
    • 12200

I'm wondering if there is a standard config in EPM that can be used to enable this behavior.

P.S. I'm using BPC NW 10.1 with EPM add-in version 20 SP1

Thanks,

Hendry

[Former Member · Accepted solution]

Hi Hendry,

Are you using property to determine the override?

if that is the case then just make sure you have the same property for those parent nodes as well, then it will display the whole structure.

Andy

[former_member544285 · Accepted solution]

Hi Andy,

Unfortunately, based on my requirement we can't do that. The property is maintained by comma-separated list of ENTITY. The relationship is many-to-many so it complicates things and I can't have the parent to have the same property. (see below)

Thanks,

Hendry

[Former Member · Accepted solution]

Hi Hendry,

Why you can't apply property to the parents?

Why don't you try it first before you say it can't?

Give the same property to the parent nodes and it will work.

Andy

[former_member544285 · Accepted solution]

Hi Andy,

You're right, as long as I can maintain the right value on parent hierarchy, I can show the member correctly. (See below for illustration)

It would require additional effort to maintain on top node, but I think it's the best solution for this requirement.

Thanks a lot!

Hendry

[Former Member · Accepted solution]

Hi Hendry,

Great, glad to help.

It is the only way with dimension override.

It will be a mission to maintain unfortunately.

Andy