Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Hello, does anyone here know if we can use commands like LAST_DAY() or EXTRACT() etc in OAS DV?

Accepted answer
41
Views
2
Comments
User_B6HPR
User_B6HPR Rank 1 - Community Starter
in Oracle Analytics Forum

Hello, does anyone here know if we can use commands like LAST_DAY() or EXTRACT() etc in OAS DV? I would like to create a dataset from a MSSQL database in OAS DV by using the manual query but I always get error pop up saying unexpected error or syntax not invalid logical sql statements. Thank you!

Tagged:

Best Answer

  • Ram-Oracle
    Ram-Oracle Rank 6 - Analytics & AI Lead
    Answer ✓

    Hi @User_B6HPR ,Please check the screenshots below to use last_day ,extract month in the dataset.

    last_day:

    image.png

    output:

    image.png

    extract month:

    image.png

    output:

    image.png

    The datasource for the above test case is ORACLE.

    As these functions are db functions ,for mssql database you may need to use equivalent functions related to last day and extract function.

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics & AI Strategist

    @User_B6HPR - Please find the list of Time Series Functions currently supported by OAC DV for creating custom calculations.

    image.png

    Kindly use anything within the list to achieve your requirement. Thanks!