Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

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

Unable to use filter in OTBI Column of Maintenance Management Subject Area

Received Response
21
Views
1
Comments
Umer Naeem
Umer Naeem Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Forum

Hi!

I am using below formula to filter the WOs Count which are completed when OTBI executes.

FILTER(COUNT(DISTINCT "Work Order"."Work Order Id") USING (("Work Order Status"."Status" = 'Completed') AND ("Work Order"."Actual End Date" = timestampadd(sql_tsi_day,0,CURRENT_DATE))))

But its not showing correct data. Kindly guide.

Thanks.

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics & AI Coach

    Hi Umer,

    So you will get a count of the distinct work orders that are completed and end is today. Maybe if you post what is your actual result versus what is your expected result. Use the simplest set of data you can. If data security is an issue then change the values to "Apples" and "Oranges".

    Looking at your formula to take a wild guess is actual end date a day date YYYYMMDD or a datetime YYYY-MM-DD"T"HH24:MI:SS. If a datetime, it is unlikely any of your work orders end exactly this second on this day so you will get almost no matches? Is that the issue.