Symptom
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Even try to use the display option to change Members display as "Text and key" or "Key and text",
Key and Text is not displayed for members at the same time in Design Panel.
For example:
1.Set members display as "Key", then key is displayed.
2.Set members display as "Text", then text is displayed.
3.Set members display either as "Text and key" or "Key and text", only text is displayed.
However, your expectation is to display text and key together at the same time.
Environment
SAP Analysis for Microsoft Office 2.8
Reproducing the Issue
- Start Analysis for Office
- Open a workbook or insert a query
- Open design panel
- Change Properties -> Members -> Display to "Text and key" or "Key and text"
Cause
This is standard design of Analysis for Office. And there is no way to show Key and Text for members at the same time in Design panel.
This setting (and the Property View in general) is not intended to change the presentation on the Design Panel but on the crosstab instead.
Resolution
You can choose to display key or text instead.
Keywords
TaskPane, Task Pane, Member display, presentaion, show, hidden, not display, Background Filter section, Row section, Data Source setion, behaviour, feature request, not supported, not able to, design, Design Panel, Analysis for Excel, Analysis for office, AO, AFO , KBA , BI-RA-AO-XLA , Excel Addin , Product Enhancement