Skip to Content
0
Mar 20, 2015 at 03:53 AM

Showing parent in EPM based on base level member selected

895 Views

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