Multiple ViewZeroOuts

Post bug reports and the status of reported bugs
Post Reply
Posts: 1706
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom

Multiple ViewZeroOuts

Post by declanr » Thu Dec 18, 2014 9:09 am


Had an odd one today in TM1 10.1

TI Process creates 5 views in the prolog and then has 5 ViewZeroOut functions in a row for 5 different cubes. All ran correctly but only the first 3 actually had their data cleared.

I have got around it by creating a sub process with nothing but the ViewZeroOut in it and calling that 5 times in a row instead passing parameters for cube and view name (which are still created and destroyed in the original TI.)

Wondering if someone can confirm before I log this with IBM.
Declan Rodger

User avatar
jim wood
Site Admin
Posts: 3874
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA

Re: Multiple ViewZeroOuts

Post by jim wood » Thu Dec 18, 2014 1:03 pm

Never gone beyond 3 sorry. It would be interesting to test it, in 10.1 and lower versions.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
Steve Rowe
Site Admin
Posts: 2161
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Multiple ViewZeroOuts

Post by Steve Rowe » Thu Jan 29, 2015 1:16 pm

I've got code that loops through many VZOs vs different views on the same cube, not aware of any issues.
This isn't the same as you though as it is vs one cube and multiple views and only one TI command.

I guess you have check this kind of thing but are you sure the data isn't getting repopulated in a later step of the job or the variables in the VZO statements have the values you think they do?
Technical Director

Post Reply