Troubleshooting
Problem
If you have a cube which has UNDEFVALS enabled in the rule of the cube, the ViewZeroOut function sets the cells in the cube to 0 and not the state of an undefined value.
Resolving The Problem
-This behaviour is working as expected, the ViewZeroOut function specifically sets cell values to 0 (per the documentation)
-If your objective is to set the cell value to the NULL/UNDEFVALS state, you can set the cell to a value of 4.94066e-324 , however there is no function to do this for an entire cube, you must create a TI Process to handle this for you
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
20 September 2021
UID
ibm11846599