The XL3SetProperty formula updates the Anaplan XL member properties in the workbook.
Member properties
When setting the member properties, you must pass additional arguments to define the hierarchy and level you would like the member properties to be applied to.
XL3SetProperty( "Grid", GridName, "MemberProperties", HierarchyUniqueName, LevelUniqueName, [MemProp1],…, [MemPropN] )
Note that:
- Any blank member property arguments will be ignored.
- Parent-child hierarchies ignore the LevelUniqueName argument.