@OpenDimCount

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

DTP Type:

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

Syntax:

@OPENDIMCOUNT(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 available dimensions that do not have a member specified. If "Dense" or "Sparse" is entered, only the specified type of dimensions that do not have members are counted.

Example 1:

[DTP1]=@OPENDIMCOUNT([MR1])

Where:

• [DTP1] is a DTP of type numeric.

• [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-100

In this example, [DTP1] returns "5", since there are a total of eight dimensions and only three have member input.

Example 2:

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

Where:

• [DTP2] is a DTP of type numeric.

• [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 member input.