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)