Symptom
- When using a DSP tunnel/indexed view and asking a query with the business name instead of the model name in Joule/Just Ask, no results are generated.
- Queries using the model name return results as expected.
- Users expect Joule/Just Ask to suggest the model and ideally display both model name and business name.
- No explicit error message or error code is displayed.
Environment
- SAP Analytics Cloud Enterprise (SAC)
- SAP Analytics Cloud 1.0
- SAC Just Ask
- SAP Datasphere
Reproducing the Issue
- Connect to data via DSP tunnel/indexed view.
- In Joule/Just Ask, ask a query that references the model by its business name (not the technical model name).
- Observe that no results are returned.
- Repeat the query using the technical model name and observe that results are returned.
Cause
- Currently, direct use of the business name in queries is not supported. This is a product limitation.
- Use Model Alias as a workaround.
Resolution
- Define a Model Alias in the model that corresponds to the desired business-friendly name.
- Save the model changes.
- In Just Ask administration, run Sync Model to refresh the model metadata used by Joule/Just Ask.
- Re-run the query in Joule/Just Ask using the defined Model Alias; results should now be returned.
- Below improvement request has been submitted via the Customer Influence site (refer to links below), if you are interested, vote will help to add weight to this feature enhancement.
Customer Influence - SAC Just Ask Managed Models: Just Ask or Joule able to identify the Business Name of DSP Models
See Also
Keywords
dsp tunnel, dsp indexed view, joule, just ask, business name, model name, no results, model alias, sync model, natural language query, sac ai, model metadata, alias mapping, nlq, analytics cloud , KBA , LOD-ANA-ASK , SAC Just Ask , Problem
Product
SAP Analytics Cloud all versions
SAP Knowledge Base Article - Public