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)