CREATESLICELISTS
This function creates an array of lists from an array of hierarchies. This, or using CREATESLICELIST, is the first step in manually creating an XML variable to define a slice.
CREATSLICELISTS requires an XML definition for each hierarchy. Use SETPROPERTY, for example, to populate a report variable for each hierarchy.
You use the result of this function as an argument of the CREATSLICELISTSEGMENT function.
Syntax
=CREATESLICELISTS(hierarchies, "MDX_per_hierarchy")
The function returns #{List} for each hierarchy in the array.
Example
=CREATSLICELISTS(D13:D16,E13:E16)
In this example, the array of hierarchies is in cells D13:D16 and the array of MDX is in E13:E16. Each cell contains the unique name of a hierarchy.
This table gives an example:| Row | D | E |
|---|---|---|
| 13 | [product] |
{[product].defaultmember} |
| 14 | [period] |
{[period].defaultmember} |
| 15 | [region] |
{[region].defaultmember} |
| 16 | [measure] |
{[measure].defaultmember} |