[OBIEE 10g] Using SQL based scale makers

       OBIEE Using SQL based scale makers

Let's start with a simple report based on the sample sales repository:

And put it in a vertical bar graph:

If we want to add a scale marker goto the   axis scaling menu and press 

Edit Scale markers, press add:

 

Click on the edit button 

Now  enter an SQL statement for which the first column gives back the value you want to use for your scale marker. In this case: 

SELECT MIN("F1 Revenue"."1-01 Revenue (Sum All)" ) saw_0, "D0 Time"."T02 Per Name Month" saw_1 FROM "Sample Sales" ORDER BY saw_1

Do the same for the MAX marker:

SELECT MAX("F1 Revenue"."1-01 Revenue (Sum All)" ) saw_0, "D0 Time"."T02 Per Name Month" saw_1 FROM "Sample Sales" ORDER BY saw_1

Specify  the Marker caption, color and line width:

And have a look at the results: