Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

SQL query in OBIEE SQL prompt error

Received Response
21
Views
1
Comments
User_Y2R87
User_Y2R87 Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Hi,

I tried last 12 months in YYYYMM format as a SQL query result in OBIEE sql prompt. but its throwing error.

Select TO_CHAR( ADD_MONTHS( TRUNC(SYSDATE,'year') , LEVEL-4 ), 'YYYYMM' ) Month
FROM dual
CONNECT BY LEVEL <= 12
;

below is this scenario i'm trying to attain

Answers

  • Raghavan p-Oracle
    Raghavan p-Oracle Rank 5 - Community Champion

    Hi @User_Y2R87,

    Try below:

    ===

    Select TO_CHAR( ADD_MONTHS( TRUNC(SYSDATE,'YYYY') , LEVEL-4 ), 'YYYYMM' ) Month
    FROM dual
    CONNECT BY LEVEL <= 12

    ====

    Best Regards,

    Raghavan