CREATESLICELISTSEGMENT

Creates a segment from a slice list that was created with the CREATESLICELISTS function or CREATSLICELIST.

See CREATESLICELISTS.

See CREATESLICELIST.

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

See Slices.

Syntax

=CREATESLICELISTSEGMENT("Array of hierarchies","Array of lists").

The function returns#{Segment}.

The number of hierarchies must equal the number of lists.

Example

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

Cell E19 contains the output of a CREATESLICELISTS function which was created from an array of MDX definitions - one definition for each hierarchy.

=CREATSLICESLISTSEGMENT(D13:D16,E19)

Related topics