@AvailDimCount

@AVAILDIMCOUNT returns the number of available dimensions.

DTP Type:

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

Syntax:

@AVAILDIMCOUNT(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. If "Dense" or "Sparse" is entered, only the specified type of available dimensions are counted.

Example 1:

[DTP1]=@AVAILDIMCOUNT([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:

  • Product: P_000

In this example, [DTP1] returns "8", since there are a total of eight dimensions.

Example 2:

[DTP2]=@AVAILDIMCOUNT([MR2],"Dense")

Where:

• [DTP2] is a DTP of type numeric.

• [MR2] is a 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 "2", since only "Account" and "Period" are dense.