ViewZeroOut with Hierarchies in PA2.0 - How about string values on consolidated level?

Post Reply
tm1_bloke
Posts: 25
Joined: Sun Oct 13, 2013 6:03 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

ViewZeroOut with Hierarchies in PA2.0 - How about string values on consolidated level?

Post by tm1_bloke » Mon Sep 23, 2019 8:33 am

Hi,

there's a topic and workaround presented for data zero out when using "alternative hierarchies" in PA 2.0. viewtopic.php?f=3&t=14330&p=70847&hilit ... y+zero+out

This works fine when dealing with numeric cells and making sure that all n-level elements are present in dimension:dimension hierarchy.

But how about zeroing out string values for consolidated elements in alternative hierarchies? I have few attributes based alternative hierarchies with element security and I would like upload the access rights for alternative hierarchies from file. The upload is pretty straightforward but I cannot see how to zero out values for consolidated elements in alternative hierarchies.

Any ideas?

Post Reply