@ValueDimCount

@VALUEDIMCOUNT returns the number of dimensions for which a member was specified.

DTP Type:

@VALUEDIMCOUNT can be assigned to a DTP of type numeric.

Syntax:

(@VALUEDIMCOUNT(DTP,Dense/Sparse)

Parameters:

Parameter	Description
DTP	Design-time prompt or function that returns a member range or cross dimension.
Dense/Sparse	Optional. If left empty, returns the count of all dimensions that have a member specified. If "Dense" or "Sparse" is entered, only the specified type of dimensions that have a member specified are counted.

Example 1:

[DTP1]=@VALUEDIMCOUNT([MR1])

Where:

• [DTP1] is a DTP of type numeric and is not a checked prompt.

• [MR1] is a DTP of type member range with the following inputs:

  • Account:

  • Period: Jan, Feb, Mar

  • HSP_View:

  • Year:

  • Scenario:

  • Version: Working

  • Entity: Sparse

  • Product: P-000

In this example, [DTP1] returns "3", since there are three dimensions that have members specified.

Example 2:

[DTP2]=@VALUEDIMCOUNT([MR1],"Dense")

Where:

• [DTP2] is a DTP of type numeric and is not a checked prompt.

• [MR1] is a DTP of type member range with the following inputs:

  • Account: Dense

  • Period: Dense

  • HSP_View: Sparse

  • Year: Sparse

  • Scenario: Sparse

  • Version: Sparse

  • Entity: Sparse

  • Product: Sparse

In this example, [DTP2] returns "1", since "Account" and "Period" are dense, and "Period" has members specified.