SLICECREATCALCULATEDMEMBERS

This function modifies an existing slice axis by the addition of calculated members. Use the modified axis when you create a slice definition.

Syntax

=SLICECREATECALCULATEDMEMBERS("slice_object_definition,"UniqueName","Caption",Order,"FormatString",visibility,"ScopeIsolation,"MDXExpression")

Example

In this example, the slice is defined in the report variable rv_slice. The calculated member calculates the average of the five points of sale in the POS dimension.

=SLICECREATECALCULATEDMEMBERS(ReportVariables.rv_slice.Text, "[POS].[All Pos].Avg_Str",
        "Avg_Str", 1, "0.00", TRUE, "TRUE", "[POS].[All Pos]/5")