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}
|