ADDSLICEAXISATTRIBUTESA
Modifies an existing slice axis with the addition of an array of attributes to each hierarchy in the slice. Use the modified axis when you create a slice definition.
Both ADDSLICEAXISATTRIBUTESA and ADDSLICEAXISATTRIBUTES
Syntax
=ADDSLICEAXISATTRIBUTES("Axis","Array of hierarchies","Array
of array of attribute names per hierarchy").
The function returns
#{Axis}.
Example
Cell F22 contains an axis created with CREATESLICEAXIS.
See CREATESLICEAXIS.
Cells F5 and F6 each contain a hierarchy. For example
[channel] and
[product].
F7 contains
=F5:F6. The cell displays an array of the hierarchies
in F5 and F6.
H5 and H6 each contain arrays of attributes to assign to the hierarchies in F5 and F6.
H7 contains
=H5:H6. The cell displays an array which contains the
arrays of elements in H5 and H6.
The function
=ADDSLICEAXISATTRIBUTESA(F22,F7,H7) returns
#{Axis}.