How to build an inventory analysis coupled with time constrained measure?

Jonathan Chan gmg

Summary

An analysis, contain info. on on-hand-quantity and open quantity, does not produce results after 15mins of run time. This happens when a time constrained measured has been added.

Content

Hello Oracle Community,

I am trying to create an analysis showing both inventory-on-hand and outstanding-work-order (Open Quantity) quantities, but the analysis kept running for 15mins without producing any results.  I had to stop the refresh process.  Would you know the suitable codes to produce the results needed?

So far I had successfully built and ran the inventory-on-hand portion of the analysis.  Then I try to add and modify the "Open Quantity" ("Manufacturing - Actual Production Real Time"."Actual Production"."Open Quantity") fact with the following code to try to display work-order-quantities that are outstanding for each SKU.  However the analysis keeps loading without producing a result, and I had to stop the refresh process after it has been running for 15mins:

CASE WHEN 

"Manufacturing - Actual Production Real Time"."Work Order"."Scheduled Start Date" >= CURRENT_DATE 

THEN 

"Manufacturing - Actual Production Real Time"."Actual Production"."Open Quantity"  

ELSE 

0 

END

I also tried the follow alternative approaches but they offer either more or less than what is needed:
• If I just add "Start Date" dimension ("Manufacturing - Actual Production Real Time"."Work Order"."Scheduled Start Date") to the analysis, it will display one record/row per each time there was outstanding quantity historically.  This is too much information because I do not need to see work order quantities from the past for each SKU.

• If I add Start Date dimension into the analysis and click the filter button to filter this column to show present and future dates, then only SKUs with outstanding work order quantities will show up.  SKUs without outstanding work order quantities will not be displayed.

I am also under the constraint that I am unable to use EVALUATE() functions because it is not turn on in my account.

Thank you.

Version

Oracle Business Intelligence 11.1.1.9.0