ADDSLICEAXISATTRIBUTESA

This function modifies an existing slice axis with the addition of arrays of attributes to each hierarchy in the slice. Use the modified axis when you create a slice definition.

Syntax

=ADDSLICEAXISATTRIBUTES(axis,hierarchies,attribute_names_per_hierarchy).

The function returns #{Axis}.

Example

Cell F22 contains an axis created with CREATESLICEAXIS. The cell displays #{Axis}.

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 that contains the arrays of elements in H5 and H6.

The function =ADDSLICEAXISATTRIBUTESA(F22,F7,H7) returns #{Axis}.