When designing an input Form, a common issue you may come across is that the cells intended to be input-enabled are not. Right-click the cell and select Cell Details to investigate this issue.
There are three types of cells in the Cell Details window: Misc, State, and Slice. The State and Slice sections will help us identify the issue.
The values for Is Lowest, Is Writeable, Is Input, and Is Locked must be True, True, True, and False, respectively, for a cell to be inputable.
The value for Is Annotate must be True for a cell to be annotatable.
When all of the Dimension Members that define the cell are at the lowest level of their hierarchy.
If the value is False, check the Slice rows:
- If any of the values are 0, that dimension has not been set to a member on the lowest level. For example, it may have been set to [All] or an attribute member in a leveled hierarchy.
- If any of the slice values are -1, the None member of that dimension has been selected. When we create a medium or large size dimension, a None member will be automatically added to the dimension.
- If all slice values are positive integers, it means one of the dimension members is not on the lowest level of a parent-child hierarchy. This happens most often in Account Dimension.
If you want a cell to be inputable, ensure that the dimension is targeting a member on the lowest level of the hierarchy, with a MemberId greater than 0.
Whether the user has the Write permission to the Model /Dimension or not.
If the value is false and the user is supposed to have writing permission:
1. Go to the Administrator node > Permission.
2. Click the Configure drop-down to select the target user, role, or group.
3. In the Write column, select the boxes of the Models you want to make writeable for the target user, role, or group.
This permission is also affected by the Write Restrictions in the Dashboard App configuration. These permissions restrict users to have only write permissions for the Members specified. Select Remove if there are writing restrictions on a Dimension or user.
If Is Writeable is false and Is Locked is true, the Read-Only setting may be configured for the Form in the Dashboard Editor. See the Is Locked section below for more details.
Whether the Input property of all the Dimension Members that define the cell have been set to True.
If the value is false:
1. In the Modeler, go to the target Member List and specific Dimension Member.
2. Click the box of any Member you need to be inputable.
If all Dimension Members have Input set to true but the cell is still not input-enabled, go to the Manage Cell Attribute section within the Form. In the Attributes tab, ensure Allow is selected for Cell input override.
Whether the plan is locked or not.
If this value is true, there are two settings you may need to check. The Lock property of the target Dashboard App in the Administrator node:
And the Read-Only option in the Dashboard Form settings.
1. In the Modeler, navigate to the Dashboard that contains the target Form.
2. Select the Form and click the icon.
3. If the Read-Only box is checked, click it. Do not do anything if it's unchecked.
4. Click OK.
A cell is annotatable when at least one of the Dimension Members that define the cell is annotate-enabled. This means the Annotate property of the Dimension Member is true.
1. Go to the Modeler > Your target Member List.
2. Under the Annotate column, check the boxes of any Dimension Member you want to be annotatable.
You can also check the Cell Details to see why a cell is not annotate-enabled. Similar to the input settings, only when the values for Is Lowest, Is Writeable, Is Annotate, and Is Locked are True, True, True, and False, respectively, will a cell be annotatable.
To allow users save annotations to databases:
1. Go to the target Form.
2. Select the General tab and click Settings > Advanced Settings.
3. Check the Query includes annotation and text cells option. Otherwise, when users post their data, all annotation contents will be removed.
Annotations are automatically enabled for the Writeback partition, but you can allow them using the Annotate column in the Data node:
For Data Rules, make sure to uncheck Remove zeros. When we write to the Comment column, the according Value is NULL, so enabling Remove zeros would exclude the record from the result set.