Returns a list of members for a specified dimension for which data exists for the specified POVs.
<HsvData>.FilterMembersThatHaveData varalScenario, varalYear, varalPeriod, varalEntity, varalParent, varalValue, varalAccount, varalICP, varalCustom1, varalCustom2, varalCustom3, varalCustom4, lDimID, vbConsiderBaseMembersOnly, varalMembersToFilter, pvaralMembersLong array (ByVal). The member IDs of the cells' Scenario dimension members. | |
Long array (ByVal). The member IDs of the cells' Year dimension members. | |
Long array (ByVal). The member IDs of the cells' Period dimension members. | |
Long array (ByVal). The member IDs of the cells' Entity dimension members. | |
Long array (ByVal). The member IDs of the parents of the varalEntity argument's entities. | |
Long array (ByVal). The member IDs of the cells' Value dimension members. | |
Long array (ByVal). The member IDs of the cells' Account dimension members. | |
Long array (ByVal). The member IDs of the cells' Intercompany Partner dimension members. | |
Long array (ByVal). The member IDs of the cells' Custom 1 dimension members. | |
Long array (ByVal). The member IDs of the cells' Custom 2 dimension members. | |
Long array (ByVal). The member IDs of the cells' Custom 3 dimension members. | |
Long array (ByVal). The member IDs of the cells' Custom 4 dimension members. | |
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. | |
Boolean (ByVal). Determines if base members only are tested. | |
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. | |
Variant. Returns the filtered list of member IDs that contain data for any of the specified POVs. |