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