Oracle Business Intelligence

Products Banner

Report to display data based on dates comparison.

Received Response
21
Views
5
Comments

Hi All,

I have requirement to display data based on dates comparison.

I have two dates supply date and ship date in my report. I have a dashboard prompt (variable prompt - PV_Supply) Supply which consists of value 'Yes'.

If user selects 'Yes' then my report should display data based on the condition (supply date < ship date)

How to filter report based on this condition?

regards,

ram.

Answers

  • ArijitC
    ArijitC ✭✭✭✭✭

    You can convert Filter to SQL and try something like this ...

    @{PV_Supply} ='Yes' and supply date < ship date

    or @{PV_Supply} ='No' and supply date > ship date

  • User_JL3CW
    User_JL3CW ✭✭✭✭✭

    Hi All,

    For the column "Supply Date" i have added filter and converted to SQL, written the  formula like this

    "Supply Date" < "Ship Date" and '@{PV_Supply}{Yes}'='Yes'

    but without selecting dashboard prompt value to 'Yes', the report is filtering data ("Supply Date" < "Ship Date").

    Please correct me.

    regards, ram.

  • ArijitC
    ArijitC ✭✭✭✭✭

    You can set default value to 'Something Else' or can change it like ...

    "Supply Date" < "Ship Date" and '@{PV_Supply}{SometingElse }'='Yes'

    You can also update default value of the dashboard prompt

  • User_JL3CW
    User_JL3CW ✭✭✭✭✭

    Hi all,

    The requirement is like this: Initially my report should display all the records.

    My dashboard prompt is have only Yes value as shown below.

    pastedImage_0.png

    As when user selects 'yes' then my report should filter based on the condition (Supply date < Ship date).

    My report should display records Supply date < ship date.

    For this i have created a variable prompt (PV_Supply) with value 'Yes'.

    The above written formula fails and it does not display any data, Please advice suitable answer.

    Regards,

    ram.

  • ArijitC
    ArijitC ✭✭✭✭✭

    Try this ..

    '@{PV_Supply}{SometingElse}'='SometingElse'

    or "Supply Date" < "Ship Date" and '@{PV_Supply}{SometingElse}'='Yes'