Asymmetric Views with MDX

[tm123]

Hi Guys,

I have a cube with following DImensions:

Version
Time_Period
Location
Customer
Product
Account
Measures

I want to build a View in PAW, and in the Columns I have the Version and Time Period Nested:

If the Current Month ( stored in a cube) is September 2020, In my view, I want to show only Actual Months for Actual Version, and Only Forecast Months for Forecast Version.

I know how to do this Manually in PAW, but every month ( when the Actual month rolls over), the view has to be updated manually

In an Active Form its easy, but I want to figure out how to automate this in a PAW View ( with an MDX )

Any Idea?

Thanks

[paulsimon]

Hi

You can create an MDX View in TI.

Start by looking at the MDX for the Asymmetric Axis in PAX. Copy the MDX and then work out how to generate it in TI. It is just a text processing job.

Regards

Paul Simon