OBIEE 12c Trellis bubble chart common bubble size/scale

Ajith Aravind-Oracle

Hi,

We are using the bubble chart in trellis simple graph. Is it possible to set a common bubble size scale for the whole graph?

The problem is that there is only one bubble in each cell, all the bubbles scales to a default size and the relativity between each cell cannot be seen. I have attached a sample graph. The scale option in the graph properties only has scale for x and y axis, so is there a way to change it in the xml or html?

Thanks,

[Deleted User]

Create a fake measure that's always 1 and assign that to the bubble size?

Ajith Aravind-Oracle

Hi Christain,

My original post may not have been very informative, so I'll just just add some more info. The idea is to have the size of the bubble driven by a real measure so that bubbles would have different sizes in each cell i.e., a uniform bubble scale throughout the trellis so that we can compare metrics between subplot. So what I believe obiee does is it scales bubbles within each sub plot individually and this makes each subplot looks somewhat identical and the relative comparison between the subplots are lost. And I do agree that this might seem very trivial.

Pardon my crude example of the issue below.

This is my sample data.

This is what we are trying to replicate in OBIEE(the screenshot is from DVD).

or

Note how the bubble size differs from each cell.

A plot of this in OBIEE would look something like this.

So my question was can we control the bubble size or set a uniform scale throughout the trellis graph as i don't see any options for the z axis in the graph properties?

[Deleted User]

"The idea is to have the size of the bubble driven by a real measure so that bubbles would have different sizes in each cell"

"Note how the bubble size differs from each cell."

....errr yeah of course they are different sizes because the measure is different. How could "a real measure" "drive the size of the bubble" but the bubbles be the same size?!

That's like asking for 7 red lines, all strictly perpendicular, some with green ink, some with transparent ink...

https://www.youtube.com/watch?v=BKorP55Aqvg

Ajith Aravind-Oracle

"How could "a real measure" "drive the size of the bubble" but the bubbles be the same size?!"

Did you even see the 3rd graph from obiee?

Ajith Aravind-Oracle

I'm adding some more example of the issue below.

And guessing a uniform scale for the bubble size cannot be achieved in obiee. Though it'd be interesting to know what is the logic behind it ✌.