Business Intelligence

User_55D6X

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

[Deleted User]

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

Jerry Casey

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]

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

Jerry Casey

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

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

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]

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

Jerry Casey

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]

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]

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

Jerry Casey

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:

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!

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

Thanks for your time, Christian.