SAP Knowledge Base Article - Preview

3779412 - No "select all members" option for variables in excel add‑in prompt dialog in SAP Analytics Cloud, add-in for Microsoft Office

Symptom

  • In the prompt dialog of the excel add-in, mandatory multi-value variables from a live datasphere analytic model do not offer an “all members” or “select all” option.
  • Users must manually select individual members for the variable prompt.
  • In data analyzer on the same analytic model, a “select all” checkbox is available in the variable prompt.
  • In the excel add-in, dimension filters provide an “all members” option, but the variable prompt does not.


Read more...

Environment

SAP Analytics Cloud, add-in for Microsoft Office

Product

SAP Analytics Cloud 1.0

Keywords

sac excel add-in, prompt dialog, variable prompt, multi-value variable, select all, all members, checkbox, datasphere live connection, analytic model, member selector, by design, product limitation, ranges, dimension filter, data analyzer , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.