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

Setting relative dates in a filter for an OTBI Analysis

Received Response
1833
Views
17
Comments
2»

Answers

  • Tim Welsh
    Tim Welsh Rank 3 - Community Apprentice

    Hi Manoj, in the report header, not column header.  Thanks!

  • Manoj Cheruvathoor-17353
    Manoj Cheruvathoor-17353 Rank 2 - Community Beginner

    hi Tim,

    I tried to get the Period in the report header. don't think there is a way. One question do you schedule this report  and mail it or just run it from the OBI.

    Thanks
    Manoj

  • Tim Welsh
    Tim Welsh Rank 3 - Community Apprentice

    Manoj,  It's scheduled and delivered via email in html format.  

  • Murali Gangidi
    Murali Gangidi Rank 1 - Community Starter

    Hi Manoj,

    Do you know how can this be used in Prompts. I have a Date Prompt and need to default the date as (CURRENT_DATE-1) because the report will be scheduled and can run adhoc when needed to input the dates by the user.

    I tried this with SQL Expression in Prompts but didn't work.

     

    SELECT
    CASE WHEN 1=0 THEN
    "Cash Management - Bank Statements Real Time"."Time"."Report Date" ELSE timestampadd
    (SQL_TSI_DAY,-1,CURRENT_DATE) END
    FROM "Cash Management - Bank Statements Real Time"

     

    When i tried this with Variable Expression and it's working correctly defaulting to CURRENT_DATE, but need (CURRENT_DATE)-1

    Attached screenshot

     

  • Murali Gangidi
    Murali Gangidi Rank 1 - Community Starter

    Do you know how can this be used in Prompts. I have a Date Prompt and need to default the date as (CURRENT_DATE-1) because the report will be scheduled and can run adhoc when needed to input the dates by the user.

    I tried this with SQL Expression in Prompts but didn't work.

     

    SELECT
    CASE WHEN 1=0 THEN
    "Cash Management - Bank Statements Real Time"."Time"."Report Date" ELSE timestampadd
    (SQL_TSI_DAY,-1,CURRENT_DATE) END
    FROM "Cash Management - Bank Statements Real Time"

     

    When i tried this with Variable Expression and it's working correctly defaulting to CURRENT_DATE, but need (CURRENT_DATE)-1

    Attached screenshot

  • Farooq H Syed
    Farooq H Syed Rank 4 - Community Specialist

    thank for sharing

  • Kamran Butt-161785
    Kamran Butt-161785 Rank 3 - Community Apprentice

    Hi Murali,

    I have a similar requirement in which I need the date prompt to show last year's date. Did you have any luck with this?

    Thanks!

    -Kamran