Skip to Content

How to create filter in IDT?

Dear Experts,

I have a requirement where I have to show webi user filter/prompt with two choices,
1) PAX
2) STAFF

where user can pick one or both.

Issue is that we differentiate PAX and STAFF on a given column in Database called STAFF_No. (Staff Number), for particular record if STAFF_No is null then we consider it as PAX else it is considered as STAFF.

if user selects PAX from prompt then it should show STAFF_No with null values, alternatively if user selects STAFF then it should show STAFF_No with values.


So how can I achieve it, whether in WEBI or in IDT?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 27, 2018 at 03:48 PM

    Asad,

    Create an object in IDT, called as Staff Type (if this name makes sense), with the below code (if you've Oracle as back end database). If the back end database is different, you'll have to use different syntax.

    Case
    When TableName.Staff_No Is Null Then 'PAX'
    Else 'STAFF'
    End

    Save and publish the Universe, and create a Prompt on this Staff Type object in the report. Makes sense?

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded