In a cube where Zeroes for Entries are needed, the function Undefvals will be used within the Cube Rule. This function works as expected. But when there is the need to clear out all existing values within the cube, usually ViewZeroOut will be used. Since ViewZeroOut is used in a normal Cube to delete all values not Zero the Functionname is correct. In the mentioned Scenario a Function called UndefValsOut would be needed to clear out all Values and set them to Undefval. Actually it also would remove all Zeroes that have been stored before in the Cube
Why is it useful?
|Who would benefit from this IDEA?||All Systems using Undefval would benefit in way higher performance. Because we would not need a process that runs through all Cells and Set them to Undefval|
How should it work?
1. A Ti Function called UndefvalsOut would be needed
2. Give the ViewZeroOut Function a next Parameter so define which Value will be used to delete (Possibility to use 0 or UndefVal)
|Customer Name||Olapline GmbH, Scholz Recycling, Leadec Industrial Services|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions