TI process to cycle and zero out a view?

Post Reply
tsw
Posts: 47
Joined: Tue Nov 12, 2013 12:14 am
OLAP Product: TM1, PowerPlay, Transformer
Version: PA 2.0.4
Excel Version: Office 365

TI process to cycle and zero out a view?

Post by tsw »

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!
sander
Posts: 52
Joined: Thu Dec 09, 2010 9:23 pm
OLAP Product: tm1
Version: 10.2
Excel Version: 2013

Re: TI process to cycle and zero out a view?

Post by sander »

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
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: TI process to cycle and zero out a view?

Post by Martin Ryan »

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
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Post Reply