Create MDX View To Suppress Rule-Defined Cells

Post Reply
Adam
Posts: 41
Joined: Wed Apr 03, 2019 12:10 am
OLAP Product: IBM PA
Version: 2.0.9.4
Excel Version: Office 365 x32

Create MDX View To Suppress Rule-Defined Cells

Post by Adam » Thu Feb 18, 2021 9:55 pm

I've spent significant time experimenting, but I cannot figure it out.

Is there a way for me to filter out elements in an MDX View that are rule defined?

Recognize an easy work around would be to create an attribute but was wondering if there’s an automated way.

Thank You!
Take care.
Adam

lotsaram
MVP
Posts: 3477
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Create MDX View To Suppress Rule-Defined Cells

Post by lotsaram » Fri Feb 19, 2021 7:12 am

I would be interestd to know exactly what your experiments were.

MDX view is no different from traditional view in this respect. There's no way to filter out rule calculated cells versus consolidatiosn or simple numeric cells.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

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

Re: Create MDX View To Suppress Rule-Defined Cells

Post by paulsimon » Sat Feb 20, 2021 9:14 pm

Hi Adam

If you submit your MDX using the Rest API, then in the ODATA query you can retrieve something that tells you whether the cell is rule calculated. However, I do not know a way of doing it in MDX alone.

Regards

Paul Simon

Post Reply