Symptom
- The comparison queries in SAC Just Ask are processed incorrectly.
- The comparison works as a sum when 'vs' or 'compare to' is used.
- This issue is observed across multiple models, including the Sales_Sample model.
Environment
- SAP Analytics Cloud (SAC) 2025 Enterprise
- SAC Just Ask
Reproducing the Issue
- Logon to the tenant.
- Open Just Ask.
- Select the indexed model.
- Ask comparison question.
- Example of question: Sales by State in 2023 compared 2024; Sales in 2023 compared 2024; Sales in 2023 vs 2024; compare Sales in 2023 vs 2024.
Cause
- The variance in Just Ask currently covers the following use cases comparison options:
- Previous Period
- Previous Year
- Previous Half Year
- Previous Quarter
- Previous Month
- Previous Week
- The queries provided are not successful due to these limitations.
-
More info are available here: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/19079ed65f854745aba51526dd6a8b17.html?locale=en-US
Resolution
- It's on the roadmap to also support different time comparisons, as in the queries, and the development team is working on it. However, there is currently no timeline for its availability.
- Raise and vote on feature enhancement ideas will also help add weight to the feature.
More info :2424376 - How to create an enhancement request for SAP Analytics Cloud?
See Also
For reference, please refer to:
- Knowledge Article [KB0314582](/redirector.do?genericParameters={\"number\":\"0002424376\",\"source\":\"knowledge\"}) - How do you create an enhancement request and provide feedback for SAP Analytics Cloud?
- https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/19079ed65f854745aba51526dd6a8b17.html?locale=en-US
- Just Ask Roadmap
Keywords
SAC, Just Ask, comparison queries, incorrect response, sum, vs, compare to, total, wrong answer, NLQ, GenAI, variance, use cases comparison options, time comparisons , KBA , LOD-ANA-ASK , SAC Just Ask , Problem
Product
SAP Analytics Cloud all versions