Mar 07, 2019 at 06:08 AM

EPM_BPC_Dynamic_Report

121 Views Last edit Mar 07, 2019 at 11:07 AM 2 rev

Hi Experts,

I am creating a dynamic query report using PC EPM 10 where I can use to investigate or to research.

I am using EPMAxis override to control the dimension and member selection.

I was able to come up with option to put a particular dimension in row or column.

What I am trying to do now is the option if I don't want to show the dimension but still in control of what member is selected on that hidden dimension.

I tried 2 options.

1. Dimension override - I can control the member selection but the dimension is not hiding because it will retain current axis override location (e.g. row or column)

2. Page Axis Override - I was able to hide it way above the report in the hidden row but I can only overwrite 1 dimension per report. So I can't hide 2 dimensions.

Attachments

8gusk.png (158.1 kB)