obiee chart 11.1.1.9 - horizontal axis — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

obiee chart 11.1.1.9 - horizontal axis

Received Response
61
Views
6
Comments
Alex1
Alex1 Rank 4 - Community Specialist
edited Aug 13, 2024 5:50PM in Oracle Analytics Cloud and Server

hello experts.

I have a question about X axis.

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

pastedImage_0.png

my customer would like to see chart like this:

pastedImage_1.png

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!

Answers

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    Horizontal axis in obiee has option to change the level orientation.

    pastedImage_0.png

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    I am not sure if the question is about filtering Year or orientation of X axis. If it is about filtering Year, then you can add another year column in the analysis. Add a filter on that column. Hide the column.

    pastedImage_0.png

  • Alex1
    Alex1 Rank 4 - Community Specialist

    Thanks for your replies.

    My requeriment is show all months and a year once. I know about Label orientation in X Axis. If I apply this option I see this:

    pastedImage_0.png

    Month and Years are overlap and not work for my customer.

    Any help?

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

    Thanks

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    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...

  • Shiva_CBS
    Shiva_CBS Rank 1 - Community Starter

    use

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

    and

    set label orientation to 0.

  • Alex1
    Alex1 Rank 4 - Community Specialist

    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!