SAP Knowledge Base Article - Public

3768907 - When a dimension contains text and key, Just Ask is only considering text and not the key - SAP Analytics Cloud

Symptom

  • Just Ask - when a dimension contains text and key, Just Ask is only considering text and not the key
  • Just Ask selects wrong filter dimension and ignores member id when description is populated, SAP Analytics Cloud
  • Issue with data generated by the Just Ask feature in SAP Analytics Cloud
  • No error messages are displayed.

Environment

  • Product: SAP Analytics Cloud (SAC) Enterprise
  • SAC Just Ask

Reproducing the Issue

  1. Log on to SAP Analytics Cloud and open Just Ask.
  2. From the indexed model list, select a model.
  3. Ask the query by dimension member ID, for example: “show sales value of Company Code AB5 ” and wait for the visualization to be generated.
  4. Observe empty chart generated. The member ID is not considered in the generated query.

Cause

  • Just Ask currently uses the Description field as the primary label for dimensions and members. When Description is populated, querying by Member ID is not supported; only if Description is empty does the system fall back to Member ID.
  • Prompts that rely on the member id can therefore fail to match and lead to incorrect or unexpected filters.

Resolution

Feature enhancement requirement has been shared to Just Ask product management team and is currently under internal evaluation to assess its feasibility for a potential future enhancement. 

Would be great if you could raise or vote your idea in Influence Site with any feature enhancement requirement.

2424376 - How to create an enhancement request for SAP Analytics Cloud?
https://influence.sap.com/sap/ino/#/campaign/884

See Also

Keywords

sac, just ask, company code, company dimension, wrong filter, incorrect dimension, member id, description label, query parsing, filter mismatch, visualization wrong values, id vs description, dimension selection , KBA , LOD-ANA-ASK , SAC Just Ask , Problem

Product

SAP Analytics Cloud all versions