GetAllDescriptionsInSubCube
Returns an array containing the cell text descriptions of one or more cells that have the same Scenario, Year, and Value dimension members.
Syntax
<HsvData>.GetAllDescriptionsInSubCube lScenario, lYear, varlPeriod, varlEntity, varlParent, lValue, varlAccount, pvarlPeriod, pvarlEntity, pvarlParent, pvarlValue, pvarlAccount, pvarlICP, pvarlCustom1, pvarlCustom2, pvarlCustom3, pvarlCustom4, pvarbstrCellText
Argument | Description |
|---|
lScenario | Long (ByVal). The member ID of the cells’ Scenario dimension member. |
lYear | Long (ByVal). The member ID of the cells’ Year dimension member. |
varlPeriod | Long array (ByVal). The member IDs of the cells’ Period dimension members. |
varlEntity | Long array (ByVal). The member IDs of the cells’ Entity dimension members. |
varlParent | Long array (ByVal). The member IDs of the parents of the varlEntity’s entities. |
lValue | Long (ByVal). The member ID of the cells’ Value dimension member. |
varlAccount | Long array (ByVal). The member IDs of the cells’ Account dimension members. |
pvarlPeriod | Variant array. Returns the member IDs of the cells’ Period dimension members. The array items are returned as a Long subtype. |
pvarlEntity | Variant array. Returns the member IDs of the cells’ Entity dimension members. The array items are returned as a Long subtype. |
pvarlParent | Variant array. Returns the member IDs of the parent entities of the pvarlEntity argument’s entities. The array items are returned as a Long subtype. |
pvarlValue | Variant array. Returns the member IDs of the cells’ Value dimension members. The array items are returned as a Long subtype. |
pvarlAccount | Variant array. Returns the member IDs of the cells’ Account dimension members. The array items are returned as a Long subtype. |
pvarlICP | Variant array. Returns the member IDs of the cells’ Intercompany Partner dimension members. The array items are returned as a Long subtype. |
pvarlCustom1 | Variant array. Returns the member IDs of the cells’ Custom 1 dimension members. The array items are returned as a Long subtype. |
pvarlCustom2 | Variant array. Returns the member IDs of the cells’ Custom 2 dimension members. The array items are returned as a Long subtype. |
pvarlCustom3 | Variant array. Returns the member IDs of the cells’ Custom 3 dimension members. The array items are returned as a Long subtype. |
pvarlCustom4 | Variant array. Returns the member IDs of the cells’ Custom 4 dimension members. The array items are returned as a Long subtype. |
pvarbstrCellText | Variant array. Returns the cell text descriptions for the cells. The array items are returned as a String subtype. |