SAP Knowledge Base Article - Public

2520224 - SAPListOfMembers is not returning members in Analysis for Office

Symptom

The formula SAPListOfMembers is not returning any member in Analysis for Office.

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Resolution

The formula SAPListOfMembers will only return data for dimension/characteristic that supports Selection State (i.e. dimension that support filtering). This is the case when the dimension exists in the Rows, Columns or Free Characteristics in Query Designer.

Keywords

empty, formula, VBA, SAPListOfMembers, list, not available, members, #N/A , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions