RemoveNoData removes data cells with a cell status of NODATA ONLY from the source data buffer. Unlike the RemoveZeros function, this function does not remove data cells with a cell amount of 0.
NODATA cells and 0 cells can be found using the following methods:
-
Review the Data Unit Statistics when you right-click on a cell in Cube View.
-
Review the Application Analysis Dashboard and check the Entity Data Statistics Report.
This is based on the Data Unit and Entity Data Statistics. There may be many Member Formulas and Business Rules that are driving data creation. Therefore, all formulas would need to be evaluated to determine whether these Remove functions are used. The higher the percentage ratio of NODATA cells to Total Number of Stored Records, the more important it is to use these Remove functions.
Example = 3,203 Stored Records with 2,019 of those Stored Records as NODATA cells. Nearly 65% of the Data Unit has NODATA cells to process which causes extra calculation time.
The Review functions can be found in Key Functions under Snippets.
