FilterMembersThatHaveData2

varalScenario

Long array (ByVal). The member IDs of the cells' Scenario dimension members.

varalYear

Long array (ByVal). The member IDs of the cells' Year dimension members.

varalPeriod

Long array (ByVal). The member IDs of the cells' Period dimension members.

varalEntity

Long array (ByVal). The member IDs of the cells' Entity dimension members.

varalParent

Long array (ByVal). The member IDs of the parents of the varalEntity argument's entities.

varalValue

Long array (ByVal). The member IDs of the cells' Value dimension members.

varalAccount

Long array (ByVal). The member IDs of the cells' Account dimension members.

varalICP

Long array (ByVal). The member IDs of the cells' Intercompany Partner dimension members.

varalCustom1

Long array (ByVal). The member IDs of the cells' Custom 1 dimension members.

varalCustom2

Long array (ByVal). The member IDs of the cells' Custom 2 dimension members.

varalCustom3

Long array (ByVal). The member IDs of the cells' Custom 3 dimension members.

varalCustom4

Long array (ByVal). The member IDs of the cells' Custom 4 dimension members.

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.

varalMembersToFilter

Variant Array (ByVal). The dimension member IDs for which you want to determine if data exists. For example, you can pass in an array of account members for which you want to determine if data exists.

pvaralFilteredMemberIndexes

Variant. Returns the filtered indexes of member IDs that contain data for any of the specified POVs. The indexes are the varalMembersToFilter array item IDs which allow you to relate the data returned to the filtered members requested. You can use the index to get the dimension ID from the varalMembersToFilter array.