CREATESLICELISTS
Creates an array of lists from an array of hierarchies. This is the first step in manually creating an XML variable to define a slice.
See Slices.
CREATSLICELISTS requires an XML definition for each hierarchy. Use SETPROPERTY, for example, to populate a report variable for each hierarchy.
See SETPROPERTY.
You use the result of this function as an argument of the CREATSLICELISTSEGMENT function.
Syntax
=CREATESLICELISTS("Array of hierarchies", "Array of
MDX")
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:| D | E | |
|---|---|---|
| 13 |
[product]
|
{[product].defaultmember}
|
| 14 |
[period]
|
{[period].defaultmember}
|
| 15 |
[region]
|
{[region].defaultmember}
|
| 16 |
[measure]
|
{[measure].defaultmember}
|