TM1 Forum

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!!

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.

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