SAP Knowledge Base Article - Public

3409849 - Formula SAPSetFilterComponent can be displayed just as KEY or TEXT and not KEY and TEXT together

Symptom

When using formula SAPSetFilterComponent, it can be displayed just as KEY or TEXT and not KEY and TEXT as the characteristic can be displayed without using the formula. If changing to TEXT and KEY, the value in SAPSetFilterComponent is showing TEXT, but then the order in the characteristic is also TEXT and KEY.

Environment

  • SAP Analysis for Microsoft Office

Cause

Analysis for Office is working as designed.

Resolution

The reported behavior of only showing 'Text' if 'Text and Key' was chosen for the display of members (and vice versa) is the intended behavior. It is not a bug.
Development team is not planning to enhance this functionality as SAP has decided not to make any further developments to Analysis for Office beyond maintenance and troubleshooting for upcoming SPs.

See Also

Keywords

SAPSetFilterComponent, Key, Text, Key and Text, Text and Key, Member, formula, filter , KBA , BI-RA-AO-XLA , Excel Addin , Product Enhancement

Product

SAP Analysis for Microsoft Office all versions