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)