CREATESLICELISTSEGMENT

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

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

Syntax

=CREATESLICELISTSEGMENT(hierarchies,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 that was created from an array of MDX definitions - one definition for each hierarchy.

=CREATSLICESLISTSEGMENT(D13:D16,E19)