Oracle Transactional Business Intelligence
How to build an inventory analysis coupled with time constrained measure?
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.
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:
"Manufacturing - Actual Production Real Time"."Work Order"."Scheduled Start Date" >= CURRENT_DATE
"Manufacturing - Actual Production Real Time"."Actual Production"."Open Quantity"
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.
Oracle Business Intelligence 18.104.22.168.0