Several requirements must be met in order for users to update a blank or zero cell in a view.
Verify that all hierarchies associated with the Category for the measure items’ underlying measures are visible in the grid.
Verify that any hierarchies that are not valid* for the associated Category are not visible in the grid.
Verify that you are not trying to change subtotal or total cells. Blank and zero values cannot be updated in subtotal and total cells.
If time hierarchies are used in the grid, verify that they exist only on one axis or only in the View Filter.
*Note: A dimension must be selected for a measure group in Stratum.Connector for Viewer in order for it to be considered ‘valid’ for measures in that group and for measure items that are based on the measures in Stratum.Viewer. See also Planning Requirements Checklist.
For example, if you attempt to change subtotal or total cells with blank or zero values, the following message displays.
In the following view, one of the hierarchies for the measure item’s Category isn’t visible. The missing hierarchy is Region. Attempting to change zero or blank values in the detail cells would result in the following message.
A similar message displays if all hierarchies for the Category are visible but there are additional hierarchies visible that are not valid for the Category. Region is visible now, but so is Product Type which is not valid for Plan Dollars Working.
