TM1 cube cannot accept 0 (zero)

Post Reply
satriaji_1191
Posts: 3
Joined: Tue May 23, 2017 5:05 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 15-0-4927-1000

TM1 cube cannot accept 0 (zero)

Post by satriaji_1191 »

In TM1, I have 1 form and 2 cubes, let's say form A, cube A, and cube B.

Form A (web based) used to keep an input data from user and store it into Cube A.
And there is a process to move a data from Cube A into Cube B.

What happen next is:
1. Storing and replacing data from Form A into Cube A with any value including 0 (zero) value -> Success
2. Moving and replacing data from Cube A into Cube B with non 0 (zero) value -> Success
3. Moving and replacing data from Cube A into Cube B with 0 (zero) value -> Failed

Is it because of TM1 cube cannot accept 0 (zero) value when moving/replacing from one cube into another cube or there is some special function to do this?

Please kindly your advice.

Regards,
Aji
Paul Segal
Community Contributor
Posts: 306
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

Re: TM1 cube cannot accept 0 (zero)

Post by Paul Segal »

It's difficult to be sure without more specifics, but it's possible that in your scenario 3 the view used has zero suppression turned on, in which case the behavior is as expected. Normally the best option is to zero out the receiving cube, or relevant portion thereof, and then do the move/copy, but it rather depends on your design.
Paul
satriaji_1191
Posts: 3
Joined: Tue May 23, 2017 5:05 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 15-0-4927-1000

Re: TM1 cube cannot accept 0 (zero)

Post by satriaji_1191 »

The use of a zero suppression is same either on or off (I just try), a 0 (zero) value still cannot move from Cube A to cube B.

So, TM1 cube cannot just accept a 0 (zero) value without using some function first (zero-out)? Is it a product limitation?
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TM1 cube cannot accept 0 (zero)

Post by Wim Gielis »

Did you mean the function 'ViewExtractSkipZeroesSet' ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
satriaji_1191
Posts: 3
Joined: Tue May 23, 2017 5:05 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 15-0-4927-1000

Re: TM1 cube cannot accept 0 (zero)

Post by satriaji_1191 »

I mean is TM1 cube cannot move a 0 (zero) value from one cube to another cube without using a "zero out" function such as "move zero out" or "cube clear data" first?
Paul Segal
Community Contributor
Posts: 306
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

Re: TM1 cube cannot accept 0 (zero)

Post by Paul Segal »

The short answer is yes, TM1 can "move" a 0 from one cube to another without using a zero out function. We really need more detail of what you're doing and how you're doing it to provide any assistance. It would be useful if you could read the forum guidelines and put your question with them in mind.
Paul
BrianL
MVP
Posts: 264
Joined: Mon Nov 03, 2014 8:23 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2 PA2
Excel Version: 2016

Re: TM1 cube cannot accept 0 (zero)

Post by BrianL »

It's also worth noting that by default, TM1 doesn't store zero values and considers a cell containing zero to be empty. You can change this behavior on a per-cube basis by adding the UNDEFVALS keyword to the cube rule.
Post Reply