Oracle Business Intelligence Applications

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

Business Intelligence

Received Response
12
Views
12
Comments

Good morning.

The graphs of the analysis are not shown, neither in design nor in execution. Attached image

Buenos dias.

No se muestran los graficos de los analisis, ni en diseño ni  en ejecucion. Imagen adjunta

pastedImage_0.png

«1

Answers

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

    What exact version? What exact browser? Etc. etc. etc.

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    I recently posted a similar question about a problem in OBIEE 12.2.1.3.0:

    In my case, the presence of conditional formatting within the chart seems to be the issue.

    Remove the conditional formats, and the chart renders.

    I confirmed that the patch that @Mostafa Morsey identified was installed, but haven't heard anything further.

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

    Because of conditional formatting? What are you formatting and how?

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    Hi Christian,
    In 11G, I had successfully applied these two conditions:

    pastedImage_0.png

    In 12.2.1.3.0, it simply doesn't render.  I have tried rebuilding it from scratch in 12C, without success. 
    It will render with a single condition, but not with a calculated combination of the two columns.

    I also tried with a simple version of that first, concatenated column.

    Any ideas?

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    P.S., I'm only showing the "legend" I created in Narrative View, because I no longer have access to the successful rendering.

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

    Does it work when you base your condition on an actual column and not a calculated one?

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    Sorry!

    This was a misstatement: "It will render with a single condition, but not with a calculated combination of the two columns."

    (Too many trials and failures back when I had access to both 11G and 12C.)
    Now that I'm back into it, it won't render with any conditional formatting on any column.

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

    I can't reproduce this in my on-premises or cloud. Tested 12.2.1.2, 12.2.1.4, and 12.2.5.1

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

    @3280715 Did you abandon your thread or not updating it anymore as Jerry and me are discussing on the side?

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    I just discovered the limit I'm bumping into, and a solution for this particular instance.
    I went back to trying a combined column and adding one condition at a time. With 10 possible combinations, it rendered up to six. 
    This worked:

    pastedImage_0.png

    But when I added a seventh, or tried to add 1B to Condition 5, it stopped rendering the chart.

    So, I went back to the calculated column to consolidate the combinations in the formula, and it worked!

    pastedImage_1.png

    Luckily for me,  there were only 6 formats I wanted to achieve.

    Thanks for your time, Christian.