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

Graphs migrated from 11g to 12c showing "0.000" on data labels when no data exists

Received Response
2
Views
2
Comments
jepva
jepva Rank 5 - Community Champion
edited Aug 13, 2024 6:13PM in Oracle Analytics Cloud and Server

As the title says, some of the bar graphs migrated into 12c are displaying 0 values when they shouldn't be.  The requirement is to display data labels, but in 11g null or 0 values would not show (which is correct).  However in 12c, we get nasty looking "0.000" for data points where there should not be a label.

The "Show null values as 0" is already unchecked - checking or unchecking this has no effect.  I also tried using the NULLIF function in the formulas but this has no effect on the graph data labels either.

My guess is this is some sort of bug that happens during the migration.  Newly created graphs in 12c do not have this problem.  Currently getting the run around from Oracle.  IT would obviously be a ton of work to have to re-create all the graphs where this is a problem.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    As you can create a chart without the issue why don't you just compare for a same chart the migrated one with the newly created XML?

    You will be able to identify what is different and maybe find out it's just an attribute or 2 in the XML and a search/replace in the catalog will fix your issues.

  • jepva
    jepva Rank 5 - Community Champion

    Oracle got back to me and it is a known bug after all.  Thanks for your suggestion though, I will try comparing XML and see if there is a tag causing this somewhere.