Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Text issue in SQL box in Analysis

Received Response
22
Views
6
Comments
Boček Petr
Boček Petr Rank 4 - Community Specialist
edited Aug 13, 2024 5:52PM in Oracle Analytics Cloud and Server

Hi All,

  any idea what could be wrong? If I go to the Advanced tab in the analysis and click New Analysis button under the SQL Issued box new pop up window appears with SQL query. But the special characters are replaced with such codes &#39 or &quot and so on.

box1.png

If I click OK error appears.

box2.png

Please can anybody advice?

Best regards

Petr

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    You don't really need to use this New Analysis on the Advanced tab. It looks like you have special characters in your column names (which shouldn't be a problem by the way).

    If I may ask, why are you using the New Analysis button on the Advanced tab?

  • Boček Petr
    Boček Petr Rank 4 - Community Specialist

    Hi Joel, thanks for replying to my issue. Actually I don't have any special characters in column name. The names are in standard way like "Table"."Column" but in SQL code it is visible as "Table"."column".

    I'm not using this New Analysis but the client does and is asking for fixing this. I adviced them to use other technics to reach the same result but we still want to get this fixed asi it is supposed to be working. In 11.9 version it was ok.

    So I suppose there should be some coding settings but I can't find any...

    Best regards

    Petr

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    Boček Petr wrote:Actually I don't have any special characters in column name.

    pastedImage_1.png

    á == http://www.fileformat.info/info/unicode/char/e1/index.htm

    Actually you do

  • Boček Petr
    Boček Petr Rank 4 - Community Specialist

    Ok in terms of english alphabet, yes I do :-) Ok I will check to have some analysis excluding any special characters and let's see.

    Nevertheless this was not a problem in 11.9g :-(

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    "in 11.9g" with the same browser as well?

    Maybe just copy+paste out what the buffer captures when you Ctrl+C thigns in 11 and 12 respectively and put it into a pure text file to see when and where the covnersion happens

  • Boček Petr
    Boček Petr Rank 4 - Community Specialist

    Same browser. I did what you asked for Christian but no success. If I paste it to notepad it looks same as the source.

    I also crested analysis without any special charactet but the result is still the same. So in 12 version I see &quot instead of " and saving is not accepting the code with &quot...

    Petr