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!!
How to zero out the data from elements of TM1 alternate hierarchy
-
- 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
-
- 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
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.
-
- 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
Burnstripe has got it, I utilized mdx view filtered on alternate hierarchies with ViewZeroOut. Feature has been available since 2.0.9 December 2019.