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
- Open a prompt or the Set Filter dialog in the SAP Analytics Cloud add-in for Microsoft Excel.
- Open More Options in the member selector and note the Display Options.
- Attempt to configure a system-wide or user-wide default so that Display Options default to “Description.”
- 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
- Use the available workaround by setting the Display Options manually in each session:
- 1. Open the prompt or Set Filter dialog.
- 2. Select More Options.
- 3. Under Display Options, choose “Description.”
- Inform users that this preference does not persist as a global default across sessions or users.
- 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
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
SAP Knowledge Base Article - Public