SAP Knowledge Base Article - Public

3778997 - No global default parameter for member list display options (description) in SAC excel add-in prompts

Symptom

In the prompt for the excel add-in, the member list “Display Options” cannot be set to default to “Description.”

Environment

  • Product: SAP Analytics Cloud
  • SAP Analytics Cloud, add-in for Microsoft Office

Reproducing the Issue

  1. Open a prompt or the Set Filter dialog in the SAP Analytics Cloud add-in for Microsoft Excel.
  2. Open More Options in the member selector and note the Display Options.
  3. Attempt to configure a system-wide or user-wide default so that Display Options default to “Description.”
  4. Observe that no global/default setting is available and the choice must be made manually per session.

Cause

A product limitation: there is no system-level or global default setting to enforce “Description” as the default in the member list Display Options for prompts.

Resolution

  1. Use the available workaround by setting the Display Options manually in each session:
  2. 1. Open the prompt or Set Filter dialog.
  3. 2. Select More Options.
  4. 3. Under Display Options, choose “Description.”
  5. Inform users that this preference does not persist as a global default across sessions or users.
  6. For a long-term solution, submit feedback and vote for the existing enhancement request. Refer to the link in the See also section.

See Also

refer to: Influence idea 366101: default member list “Display Options” for prompts

Keywords

sac excel add-in, display options, member list, default description, prompt, member selector, set filter dialog, id vs description, global default, product limitation, enhancement request, configuration, persistence, excel add-in prompts, sac add-in for office , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

Product

SAP Analytics Cloud all versions