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.