CREATESLICEAXIS

Creates an axis from segments that were created with CREATESLICELISTSEGMENT.

See CREATESLICELISTSEGMENT.

This is the third step in manually creating an XML variable to define a slice.

The axis can be used as the row or column axis in the slice.

Syntax

=CREATESLICEAXIS("Array of hierarchies", "suppression", "segment","segment","...")

The function returns#{Axis}.

The number of hierarchies must equal the number of hierarchies in the segments.

Example

In this example cells D13:D16 form the array of hierarchies. Each cell contains the unique name of a hierarchy.

Cell E22 contains the output of a CREATESLICELISTSEGMENT function, which was created from the same array of hierarchies and an array of lists.

The suppression options are 'none','hidden', 'null' or 'zero' for suppression of empty or zero values.

=CREATESLICEAXIS(D13:D16,"none",E22)

Permissions to view data can be applied to users and elements. If permission for a particular user and element is 'None' then that user cannot view the value for the element. Such values are treated as empty and can be suppressed with the 'hidden' condition.

Related topics