Symptom
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 inputtable.
The value for Is Annotate must be True for a cell to be annotatable.
Is Lowest
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 inputtable, ensure that the dimension is targeting a member on the lowest level of the Hierarchy, with a MemberId greater than 0.
Is Writeable
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. Select your target Application in the Administrator node.
2. Select Permission.
3. Click the Configure drop-down to select the target user, role, or group.
4. Select Dimension or Model to configure their respective read/write access.
For example, configure Model security by using the checkboxes under the Write column.
Tip: You can enable write access to all Models by clicking the checkbox next to Write.
5. Click OK.
Write permission is also affected by the Write Restrictions in Dashboard App configuration. These permissions restrict users to have only write permissions for specified Members.
1. Select your Application after expanding the Dashboard App node.
2. 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.
Is Input
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 inputtable.
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.
Go to the Cell Attribute, the Attributes tab, and ensure Allow is selected for Cell input override.
Is Locked
Whether the plan is locked or not.
If this value is true, there are two settings you 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 .
3. If the Read-Only box is checked, click it. Do not do anything if it's unchecked.
4. Click OK.
Is Annotate
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.
3. Go to the target Form.
4. Select the General tab and click Settings > Advanced Settings.
5. Check the Query includes annotation and text cells option. Otherwise, when users post their data, all annotation contents will be removed.
Note: Both Query includes annotation and text cells and Annotate for the Dimension Member must be enabled for annotations. If any of a cell's intersecting Members has these two settings enabled, the cell will be annotation-enabled.
Writeback and Data Rules
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 related Value is NULL, so enabling Remove zeros would exclude the record from the result set.