@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.