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

OTBI filter help

Received Response
1
Views
2
Comments
Reddykrishna
Reddykrishna Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

I want add the condition for the filter to pull last month whole data based on running month. Column name is "Assignment Absences Details"."Date Start"

Please help

Answers

  • Sovitendu Jalli-Oracle
    Sovitendu Jalli-Oracle Rank 3 - Community Apprentice

    Hi Krishna Reddy,

    Please use below expression in the filter expression.

    CAST("Assignment Absences Details"."Date Start" AS DATE) BETWEEN TIMESTAMPADD(SQL_TSI_MONTH, -1, TIMESTAMPADD( SQL_TSI_DAY ,DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))
    AND TIMESTAMPADD( SQL_TSI_DAY , -(1),TIMESTAMPADD( SQL_TSI_DAY ,DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))

  • Reddykrishna
    Reddykrishna Rank 1 - Community Starter

    Thank you @Sovitendu Jalli-Oracle it helps a lot