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

Month subject OBIEE sort order

Received Response
791
Views
36
Comments
124»

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @ User_LL6E2

    Technically it should work. Are you getting any Error?

    Regards,

    Arjun

  • User_LL6E2
    User_LL6E2 Rank 3 - Community Apprentice

    Im getting the below errors. Also attached.

    month.png


    Formula syntax is invalid.

    [nQSError: 10058] A general error has occurred. Please have your System Administrator look at the log for more details on this error. (HY000)

    [nQSError: 43113] Message returned from OBIS. Please have your System Administrator look at the log for more details on this error. (HY000)

    [nQSError: 27002] Near : Syntax error Please have your System Administrator look at the log for more details on this error. (HY000)

    [nQSError: 26012] . Please have your System Administrator look at the log for more details on this error. (HY000)

    SQL Issued: SELECT case when "Calendar"."Month" = 'APR' then 1 when "Calendar"."Month" = 'MAY' then 2 when "Calendar"."Month" = 'JUN' then 3 when "Calendar"."Month" = 'JUL' then 4 when "Calendar"."Month" = 'AUG' then 5 when "Calendar"."Month" = 'SEP' then 6 when "Calendar"."Month" = 'OCT' then 7 when "Calendar"."Month" = 'NOV' then 8 when "Calendar"."Month" = 'DEC' then 9 when "Calendar"."Month" = 'JAN' then10 when "Calendar"."Month" = 'FEB' then11 when "Calendar"."Month" = 'MAR' then 12 else "Calendar"."Month" end FROM "Statistics-History and Forecast"

    OK (Ignore Error)

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist
    edited January 2024

    Hi @User_LL6E2

    Its an syntax Error - Try below

     case when "Calendar"."Month" = 'APR' then 1

        when "Calendar"."Month" = 'MAY' then 2

       when "Calendar"."Month" = 'JUN' then 3

     when "Calendar"."Month" = 'JUL' then 4

    when "Calendar"."Month" = 'AUG' then 5

    when "Calendar"."Month" = 'SEP' then 6

    when "Calendar"."Month" = 'OCT' then 7

    when "Calendar"."Month" = 'NOV' then 8

    when "Calendar"."Month" = 'DEC' then 9

     when "Calendar"."Month" = 'JAN' then 10

    when "Calendar"."Month" = 'FEB' then 11

    when "Calendar"."Month" = 'MAR' then 12

     else "Calendar"."Month" end


    Note: Above will give the result if you don't have any data type issues.

    Regards,

    Arjun

  • User_LL6E2
    User_LL6E2 Rank 3 - Community Apprentice

    Oh must be close.

    Screenshot 2024-01-20 133050.png

    It let the report proceed after inserting the code in the month column formula, which it wasnt doing. But unfortunately now I get the attached errors with no report.

    Screenshot 2024-01-20 132943.png


  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @User_LL6E2

    My suggestion is to remove the remaining columns from report and validate/run report with only CASE statement column to fix the issue.

    Regards,

    Arjun

  • Clare Murtagh - new
    Clare Murtagh - new Rank 5 - Community Champion
    edited February 2024

    We have used the format 2024 01, 2024 02 etc; where 01 is fiscal month. March will show as 2025 03.