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!
TI process to cycle and zero out a view?
-
- 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?
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;
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;
Regards SanderI have a dimension A with a MDX expression to dynamically show leaf nodes based on another (time) dimension's attribute
- 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?
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
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
Jodi Ryan Family Lawyer