exclude

exclude([dim1[,dim2]...]::aggregate-expression])

This expression calculates a value by subtracting dimensions from the component's level of detail

For example:

exclude(col['procuct']::sum(col['sales'])))

fixed

fixed([dim1[,dim2]...]::aggregate-expression])

This expression calculates a value using the specified dimension without referring to any other dimensions in the component

For example:

fixed(col['procuct']::sum(col['sales']))

include

include([dim1[,dim2]...]::aggregate-expression])

This expression uses the specified dimension and any dimension in the component to calculate the value

For example:

include(col['procuct']::sum(col['sales'])))