Oracle Communities

Oracle Analytics and AI

Child Item

Oracle Analytics AI Assistant - Ability to add numeric / text responses to the canvas

From November 2025 release version onwards, it is observed that the AI Assistant responses in the form of numeric values or text descriptions - are not having the provision to add to the canvas. This ability seems to be confined to only graphs generated.

Why this was important?

Only when we move the response to the canvas and keep it active, could we study the corresponding Logical SQL to evaluate the mappings and the need for any further optimisations.

Question:

Can we add the missing ability to add the numeric/text responses to the canvas, to be able to assess its LSQL? If not, is there any way to access the LSQL in any alternate way?

If there is no alternate way, happy to add this as a suggestion in the Idea Lab.

Find more posts tagged with

AI Assistant

Oracle Analytics Cloud

Oracle Analytics AI Assistant

AI Assistant feature

Accepted answers

Ambili

Found a workaround for this, during my discussion with @Lalitha Venkataraman-Oracle. We can use 'Chart Type' option to change similar text responses to say, a 'Table' type or any chart type - and the resulting response allows you to add it to the canvas, to perform any further investigations on it. Hope this helps everyone in need!

All comments

Mohammed Rafi

Internally, numeric/text responses are often generated through:

Aggregated AI interpretation layer
Semantic query abstraction
Sometimes post-processed responses (not always a 1:1 logical query object)

So Oracle restricts “Add to Canvas” because those responses are not always backed by a reusable visualization object.

Before this change, the workflow was:

Ask AI question
Add result to canvas
Open visualization
Inspect Logical SQL
Validate mappings & joins

Now:

Pure KPI or textual answers never become a canvas object
No canvas object = no LSQL inspector
No LSQL = harder semantic model debugging

For model tuning (especially in FDI and custom RPD), this is a real loss.

Mohammed Rafi

No — there is currently no configuration, feature flag, or admin setting to force numeric/text AI responses onto the canvas.

This limitation exists in:

OAC (Oracle Analytics Cloud)
FDI embedded analytics (since it uses the same AI layer)

Even service administrators cannot override this behaviour.

Workaround: Use “Explain” + Rebuild in Workbook Manually

If AI gives you a numeric/text response:

Copy the interpreted fields/measures
Recreate the same logic in a workbook visualization
Then inspect Logical SQL from the workbook

This is actually more reliable for optimisation analysis.

Ambili

Thank you, @Mohammed Rafi for your detailed response. I agree that the new workflow change is definitely a loss for model optimisations. I do like your suggested workaround by rebuilding the visualisation manually. As long as, we have the visibility of all the filters and conditions used in arriving at the response, this can help to a good extent. In scenarios wherein this is not the case, we are again missing the clear logic and struggle to optimise further to derive expected results.

Ambili