GetMembersThatHaveData

Returns an array of dimension member IDs (as specified by lDimID) that contain data for the specified POV.

Syntax

<HsvData>.GetMembersThatHaveData lScenario, lYear, lPeriod, lEntity, lParent, lValue, lAccount, lICP, lCustom1, lCustom2, lCustom3, lCustom4, lDimID, vbConsiderBaseMembersOnly, varalMembersAutomaticallyIncludedInOutput, pvaralMembers

Argument

Description

lScenario

Long (ByVal). The member ID of the cell's Scenario dimension member.

lYear

Long (ByVal). The member ID of the cell's Year dimension member.

lPeriod

Long (ByVal). The member ID of the cell's Period dimension member. Must be a valid member or MEMBERALL, or MEMBERNOTUSED.

lEntity

Long (ByVal). The member ID of the cell's Entity dimension member.

lParent

Long (ByVal). The member ID of the parent of the lEntity argument's entity.

lValue

Long (ByVal). The member ID of the cell's Value dimension member.

lAccount

Long (ByVal). The member ID of the cell's Account dimension member. Must be a valid member or MEMBERALL, or MEMBERNOTUSED.

lICP

Long (ByVal). The member ID of the cell's Intercompany Partner dimension member. Must be a valid member or MEMBERALL, or MEMBERNOTUSED.

lCustom1

Long (ByVal). The member ID of the cell's Custom 1 dimension member. Must be a valid member or MEMBERALL, or MEMBERNOTUSED.

lCustom2

Long (ByVal). The member ID of the cell's Custom 2 dimension member. Must be a valid member or MEMBERALL, or MEMBERNOTUSED.

lCustom3

Long (ByVal). The member ID of the cell's Custom 3 dimension member. Must be a valid member or MEMBERALL, or MEMBERNOTUSED.

lCustom4

Long (ByVal). The member ID of the cell's Custom 4 dimension member. Must be a valid member or MEMBERALL, or MEMBERNOTUSED.

lDimID

Long (ByVal). The dimension for which you want a list of members. You can use the following dimensions: Account, ICP, Custom 1, Custom 2, Custom 3, or Custom 4. For valid values see Dimension ID Constants.

vbConsiderBaseMembersOnly

Boolean (ByVal). Determines if base members only are tested.

varalMembersAutomaticallyIncludedInOutput

Variant (ByVal). A list of members to be included in output.

pvaralMembers

Variant. Returns the filtered list of member IDs that contain data for any of the specified POVs.