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
TM1 cube cannot accept 0 (zero)
-
- Posts: 3
- Joined: Tue May 23, 2017 5:05 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 15-0-4927-1000
-
- 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)
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
-
- 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)
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?
So, TM1 cube cannot just accept a 0 (zero) value without using some function first (zero-out)? Is it a product limitation?
-
- MVP
- Posts: 3120
- 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)
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
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
-
- 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)
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?
-
- 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)
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
-
- 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)
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.