CREATESLICEDEFINITION

Creates the definition of a slice. You can pass the definition to a variable, which you can then use to create a slice.

See Slices.

Syntax

=CREATESLICEDEFINITION("Alias","Cube","Slicers","Row Axis","Column Axis","Properties")

The function returns </SliceObjectModel>.

Example

In this example, the report variable, rv_slicers was populated by the INITSLICERS function. F22 and F23 hold the results of two CREATSLICEAXIS functions - one to create the column axis and one to create the row axis:

=CREATESLICEDEFINITION("Best Practices OLAP","Analysis",ReportVariables.rv_slicers.Text,F22,F23)

Related topics