Defining the range in OBIEE graph 0-10, 10-20, based on data

2725052 · Feb 10, 2016 4:02PM

Hi,

I have requirement in OBIEE 11g reporting where as attached in the image we need to display range of data even there is datapoint.

For eg. Range in X-Axis 0-10, 10-20, 20-30, 30,40, 50-60 with blank data and continue with 60-70...90-100 with data

The range should be defined based on the maximum value in Rate field. eg. 95 in max value which falls in range of 90-100.

so the graph should display data from 0-10,10-20,20-30.......90-100.

cesar.advincula.o · Feb 12, 2016 11:46AM

Hello, if your requirment its that, you have to create a new column based in the data in range that you want, so you could implement in two ways::

1-Via Oracle BI Answers

BASED IN YOUR RATE, you could create a new column in oracle bi answers something like this

CASE WHEN RATE > 60 OR RATE <= 70 THEN '60-70 '

WHEN RATE > 70 OR RATE <= 80 THEN '70-80'

WHEN RATE > 80 OR RATE <= 90 THEN '80-90'

WHEN RATE > 90 OR RATE < 100 THEN '90-100'

ELSE END

2-Via ETL. is the same the same logic that you have to implement in your query,

When you get the column you could put in it in the horizontal axis in your view.

I did a sample as a your requeriment

Oracle Analytics Forum