CREATESLICEDEFINITION
This function creates the definition of a slice. You can pass the definition to a variable, which you can then use to create a slice.
Syntax
=CREATESLICEDEFINITION("data_connection","cube",slicers,row_axis,column_axis,properties)
The function returns </SliceObjectModel>.
The Properties parameter can be used to return these intrinsic cell properties:
- ACTION_TYPE
- BACK_COLOR
- CELL_ORDINAL
- FONT_FLAGS
- FONT_NAME
- FONT_SIZE
- FORE_COLOR
- FORMAT
- FORMAT_STRING
- FORMATTED_VALUE
- LANGUAGE
- UPDATEABLE
- VALUE
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("BestPracticesOLAP","Analysis",ReportVariables.rv_slicers.Text,F22,F23)