SAP Knowledge Base Article - Public

2620591 - Key and Text is not displayed for members at the same time in Design Panel

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.

KEY.jpg

2.Set members display as "Text", then text is displayed.

Text.jpg

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.

TK.jpgKT.jpg

 

Environment

SAP Analysis for Microsoft Office 2.8

Reproducing the Issue

  1. Start Analysis for Office
  2. Open a workbook or insert a query
  3. Open design panel
  4. 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

Product

SAP Analysis for Microsoft Office 2.8