obiee chart 11.1.1.9 - horizontal axis

Question

hello experts.

I have a question about X axis.

I have this a chart with month/year in X Axis.

my customer would like to see chart like this:

Is that possible?

In my first chart (obiee) I get year only once because I have this formula in year column:

CASE WHEN "Time"."Month" = 6 THEN CAST("Time"."Year" AS CHAR(8)) ELSE ' ' END

Any ideas?

Thanks!

Alex1 · Answer

Thanks! But with 1024 pixels with screen resolution years and months are still overlaping, If I change resolution to 2000 it works, but not work for my costumer.

Thanks for your option!

Shiva_CBS · Answer

use

CASE WHEN "Time"."Month" = 6 THEN CHAR(13) || CAST("Time"."Year" AS CHAR(8)) ELSE ' ' END

and

set label orientation to 0.

[Deleted User] · Answer

Alex1 wrote:I know about D3 tecnology but I can't setup javascript. I would like to fix using standard obiee charts.

"fix" meaning "make a standard software behave like Excel" once more...