ViewZeroOut doesn't work

Post Reply
EP_explorer
Regular Participant
Posts: 198
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

ViewZeroOut doesn't work

Post by EP_explorer »

Found one very strange thing in one TM1 model
I can't zero any view in one Cube in it using ViewZeroOut.

I've done different things - at the end I deleted all rules from cube and put in view only detail elements. But ViewZeroOut doesn't work again

CellPutN works, I can put 0 by hands but ViewZeroOut - doesn't

I even create test Cube in the model - ViewZeroOut works there. So it seems ViewZeroOut doesn't work only in the Cube which I need zero.

So any ideas - why ViewZeroOut can't work?
ardi
Community Contributor
Posts: 145
Joined: Tue Apr 02, 2013 1:41 pm
OLAP Product: tm1, cognos bi
Version: from TM1 9.4 to PA 2.0.9.6
Excel Version: 2010
Location: Toronto, ON

Re: ViewZeroOut doesn't work

Post by ardi »

EP_explorer wrote: Thu Dec 07, 2023 3:26 pm Found one very strange thing in one TM1 model
I can't zero any view in one Cube in it using ViewZeroOut.

I've done different things - at the end I deleted all rules from cube and put in view only detail elements. But ViewZeroOut doesn't work again

CellPutN works, I can put 0 by hands but ViewZeroOut - doesn't

I even create test Cube in the model - ViewZeroOut works there. So it seems ViewZeroOut doesn't work only in the Cube which I need zero.

So any ideas - why ViewZeroOut can't work?
Did you check if all subsets assigned to the view have the correct elements?
Ardian Alikaj
EP_explorer
Regular Participant
Posts: 198
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: ViewZeroOut doesn't work

Post by EP_explorer »

I even at the end put detail elements in all dimensions. And result is the same. ViewZeroOut doesn't work.

Is is ppssible that cube in some way is corrupted?
User avatar
Steve Rowe
Site Admin
Posts: 2403
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: ViewZeroOut doesn't work

Post by Steve Rowe »

Super unlikely....
Most likely you have a C level in your view, you can only zero out N level data and it must be explicitly in your view / sets.

Other reasons for confusion to arise.
It's ruled data and therefore can't be zeroed out.

Suggest you post your code and / or screen shot of view definition
Technical Director
www.infocat.co.uk
EP_explorer
Regular Participant
Posts: 198
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: ViewZeroOut doesn't work

Post by EP_explorer »

01.jpg
01.jpg (113.48 KiB) Viewed 7742 times
burnstripe
Regular Participant
Posts: 193
Joined: Wed May 06, 2020 2:58 pm
OLAP Product: Planning Analytics
Version: 2.0.9
Excel Version: 2016

Re: ViewZeroOut doesn't work

Post by burnstripe »

EP_explorer
Regular Participant
Posts: 198
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: ViewZeroOut doesn't work

Post by EP_explorer »

burnstripe wrote: Sat Dec 09, 2023 10:38 am What version is this on
https://www.ibm.com/support/pages/flash ... hout-error
It seems you are right
Version is 9.0.4
Thank you
lotsaram
MVP
Posts: 3644
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: ViewZeroOut doesn't work

Post by lotsaram »

EP_explorer wrote: Sat Dec 09, 2023 11:28 am
burnstripe wrote: Sat Dec 09, 2023 10:38 am What version is this on
https://www.ibm.com/support/pages/flash ... hout-error
It seems you are right
Version is 9.0.4
Thank you
Why are you using a 3 year old version?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: ViewZeroOut doesn't work

Post by Alan Kirk »

lotsaram wrote: Mon Dec 11, 2023 8:42 am
EP_explorer wrote: Sat Dec 09, 2023 11:28 am
burnstripe wrote: Sat Dec 09, 2023 10:38 am What version is this on
https://www.ibm.com/support/pages/flash ... hout-error
It seems you are right
Version is 9.0.4
Thank you
Why are you using a 3 year old version?
3 wouldn't be so bad. Generally I don't regard sitting on IBM's bleeding edge releases to be... ah, shall we say, "prudent".

(He says, noting distinct performance degradation in ODBC (both in and out) between 2.0.6 and 2.0.9.18, and the fact that the transaction log in Perspectives often returns cr@p on the newer release, for example.)

But 9.0.4 is of course from 18 July 2008, making it 5 times that age. And to be fair there is a lot of good stuff (notably in the API) that has been added since then.

However that said... one does have to also consider the question of affordability, and a 15 year old TM1 is still better than no TM1 at all.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
EP_explorer
Regular Participant
Posts: 198
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: ViewZeroOut doesn't work

Post by EP_explorer »

Sorry
Planning Analytics 2.0.9.4 of course
))
EP_explorer
Regular Participant
Posts: 198
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: ViewZeroOut doesn't work

Post by EP_explorer »

lotsaram wrote: Mon Dec 11, 2023 8:42 am
EP_explorer wrote: Sat Dec 09, 2023 11:28 am
burnstripe wrote: Sat Dec 09, 2023 10:38 am What version is this on
https://www.ibm.com/support/pages/flash ... hout-error
It seems you are right
Version is 9.0.4
Thank you
Why are you using a 3 year old version?
One client uses it
Actually (not in the case) but in general - I don't like migrate to new version because first of all you have to check how all components of the models would work in new version and it could take a lot of time (and bring some sort of surprises like I've found with ViewZeroOut - and I remember how I had to change command ProcessError to ProcessQuit in many processes in new version of PAL because suddenly ProcessError started to rollback all changes in cubes which proccess did )
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: ViewZeroOut doesn't work

Post by Alan Kirk »

It's not necessarily a case of "of course" above... I know that there are still a few V10 users around and I'd bet that the occasional V9.x user exists too. (I inherited a 9.5.2 instance only a couple of years back but I grant you 9.0.x would be way less common than that.) But that aside...
...first of all you have to check how all components of the models would work in new version and it could take a lot of time (and bring some sort of surprises
That's pretty much the point that I was making too, but of course we're both guilty of Old Skool Thinking. Now of course upgrades come out every few months and we should unhesitatingly trust that each upgrade is utterly flawless. Or, if you're on an IBM cloud environment, you don't have to trust at all; just be told how long you will be "permitted" to go without an upgrade.

After all... "What. Could. POSSIBLY. Go. Wrong?"

IBM has a STWATEGY!
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply