Asymmetric Views with MDX

Post Reply
tm123
Posts: 123
Joined: Thu Oct 23, 2014 10:15 pm
OLAP Product: tm1, cognos bi
Version: 10.2
Excel Version: 2010

Asymmetric Views with MDX

Post by tm123 » Thu Oct 08, 2020 9:24 pm

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

User avatar
paulsimon
MVP
Posts: 764
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Re: Asymmetric Views with MDX

Post by paulsimon » Thu Oct 08, 2020 9:39 pm

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

Post Reply