Multiple ViewZeroOuts

Post bug reports and the status of reported bugs
Post Reply
declanr
MVP
Posts: 1815
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
Contact:

Multiple ViewZeroOuts

Post by declanr »

All,

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: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Multiple ViewZeroOuts

Post by jim wood »

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.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Multiple ViewZeroOuts

Post by Steve Rowe »

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
www.infocat.co.uk
Post Reply