TM1 Forum

Hi,

Goal: Zero out old data in a cube

I have a dimension A with a MDX expression to dynamically show leaf nodes based on another (time) dimension's attribute.
Is there any way to parameterize a view so that I can call ViewZeroOut() for each of the time dimension's slice/view of the cube?

Is there a better way to do this? what is hard is that dimension A's leaf node varies for each timeline dimension... so not sure how to handle this kind of zero out.... I'm somewhat new to TM1.

Thanks!

For sure it is possible to zero out based on some parameters and us a while loop for example. Maybe have a look at the bedrock processes (http://www.bedrocktm1.org/, BEDROCK TI VERSION 2.0) to have a start, since you are somewhat new to Tm1, there you have a standard process to zero out where you can set some parameters.
To help you any further you need to be more specific, some screenshots to explain, code you have already written, etc.

Also interested in what you exactly mean with;

I have a dimension A with a MDX expression to dynamically show leaf nodes based on another (time) dimension's attribute

Regards Sander

There's a few worked examples of ViewZeroOut in the forum, e.g. http://www.tm1forum.com/viewtopic.php?p=41331#p41331 or http://www.tm1forum.com/viewtopic.php?p=28275#p28278

HTH,
Martin