Oracle Analytics Cloud and Server

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
41
Views
5
Comments

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.

Best Answers

  • 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.

  • 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