The XL3SetProperty formula updates the Anaplan XL slicer properties in the workbook.
Property | Description | Value |
RemoveEmpty | Sets the slicer to hide or show members with no data. | TRUE or FALSE |
Visible | Show or hide the slicer | TRUE or FALSE |
MultiSelect | Allow multi-selection on the slicer, dependant on the slicer type. | TRUE or FALSE |
Hierarchy | Sets the slicer hierarchy. Will move hierarchies as required. | Hierarchy name. |
HierarchiesOnHeaders | Sets hierarchies on headers. Will move hierarchies as required. | Hierarchy name or names. |
MemberSelectionType | Sets the selection type of the members, for example children, parent, descendants etc. | See the Member Selection Type section for more details. |
Enabled | Allows toggling of the whether the slicer is enabled. | TRUE or FALSE |
OutputRange | Sets the output range of the slicer. | Text. This must be the text of the range, not a reference to it. |
WaitForSubmitOnWeb | Allows toggling of the whether the slicer requires submitting. | TRUE or FALSE |