Dynamic MDX in a PAW view

Post Reply
MarenC
Regular Participant
Posts: 346
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Dynamic MDX in a PAW view

Post by MarenC »

Hi,

Is it possible to make the mdx in a paw view dynamic depending on user selections? For example, changing what appears in the rows and title area?
I am finding that I have to create 3 reports, when ideally I want to create 1 report, and make it dynamic.

Let us say for example, the user wants to look at a cost centre report but there are 3 dimensions related to cost centre - Department, Service Area and Project.
Depending on their selection, I might want the Department in the rows and the others in the titles or the Service Area in the rows and the others in the titles.

Maren
Post Reply