Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

AI Assistant throws error for column name having the character '$'

Accepted answer
62
Views
5
Comments
Jahnavi-Oracle
Jahnavi-Oracle Rank 6 - Analytics & AI Lead
in Oracle Analytics Forum

Hi Team,

We have recently started using the AI assistant in OAC May Update. We did the indexing for a subject area and tried the AI assitant for it. But we have noticed that for all the measure columns where we have the character as '$' in the column name the asistant throws error. I also saw a blog which suggested that special character migt create an issue so we tried to give synonym as well for the said column but the error persists. Any workaround or anyone else who has seen the same issue.

Tagged:

Best Answers

  • Bret Grinslade - Oracle Analytics-Oracle
    Bret Grinslade - Oracle Analytics-Oracle Mod
    Answer ✓

    This looks like an issue with the Assistant which I can repro. As a work around — you could rename the column in a dataset to something from say $ Amount to USD Amount … for now.

  • Jacques V.-Oracle
    Jacques V.-Oracle Mod
    Answer ✓

    You should definitely an SR for this. I believe this is currently a known limitation on special characters. We do not allow these chars in the synonyms either.

    Filing an SR will allow you to track our progress to changing this.

    As @bret mentioned , Renaming or creating a duplicate column without that char in the SA could allow you to move forward for now.

Answers