How to zero out the data from elements of TM1 alternate hierarchy

Post Reply
Madhesh1988
Posts: 2
Joined: Mon Jan 10, 2022 7:36 am
OLAP Product: Planning analytics
Version: 2.0.9.10
Excel Version: MS office plus 16

How to zero out the data from elements of TM1 alternate hierarchy

Post by Madhesh1988 »

HI,

we are having an alternate hierarchy named 'CustomLevels' in a dimension called 'Location'

This alternate hierarchy can be viewed only in PAW/PAX and not visible from our subset editors in architect or perspectives.

When we do the normal zero out, this doesn't zero out the data that is present in the elements of alternate hierarchy (These elements are different and do not exist in original hierarchy we have).

is there a way that we can zero out the data in these elements?

Thanks!!
burnstripe
Regular Participant
Posts: 197
Joined: Wed May 06, 2020 2:58 pm
OLAP Product: Planning Analytics
Version: 2.0.9
Excel Version: 2016

Re: How to zero out the data from elements of TM1 alternate hierarchy

Post by burnstripe »

In one of the releases for 2.0.9.X, IBM added the capability to use the viewzeroout on MDX views. I've not put it into practise yet, but in theory you could use viewcreatebymdx to build the view with the required elements and then clear it using the viewzeroout.
ascheevel
Community Contributor
Posts: 287
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: How to zero out the data from elements of TM1 alternate hierarchy

Post by ascheevel »

Burnstripe has got it, I utilized mdx view filtered on alternate hierarchies with ViewZeroOut. Feature has been available since 2.0.9 December 2019.
Post Reply