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