calculate_leadtime_po_to_mr Normal / ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT
ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE
0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 - 2025/07/28 14:26:08.522 - 2025/07/28 14:26:08.522 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N dw bi indoteknik (localhost) localhost POSTGRESQL Native dw_bi_indoteknik 5432 pdi Encrypted 2be989bb20084ca95810197629d9ea18e FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER 5432 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE N USE_POOLING N Table input Select values Y Select values Table input 2 Y Table input Select values 2 Y Select values 2 Sort rows Y Table input 2 Sort rows 2 Y Sort rows Merge join Y Sort rows 2 Merge join Y Merge join Select values 3 Y Select values 3 Sort rows 3 Y Sort rows 3 Unique rows Y Unique rows Modified JavaScript value Y Modified JavaScript value Select values 4 Y Select values 4 Insert / update Y Insert / update InsertUpdate Y 1 none dw bi indoteknik (localhost) 100 N public
leadtime_po_to_received_working_hour
purchase_line_id purchase_line_id = purchase_id purchase_id = received_id received_id = po_confirm_date po_confirm_date Y received_good_date received_good_date Y purchase_line_id purchase_line_id N purchase_id purchase_id N new_po_to_arrival new_po_to_arrival Y po_to_arrival_status po_to_arrival_status Y received_id received_id N 768 304 Y Merge join MergeJoin Y 1 none INNER Sort rows Sort rows 2 purchase_line_id purchase_id received_id purchase_line_id purchase_id received_id 464 304 Y Modified JavaScript value ScriptValueMod Y 1 none N 9 0 Script 1 var target_limit = 59; // Set Default Target var cat = parent_category; if (cat == null) { cat = ""; } switch (cat) { case "Cairan Berbahan Kimia": case "Komponen & Aksesoris": case "Mesin Industrial": target_limit = 46; break; case "Pengaman, Kesehatan & Keamanan": case "Peralatan Horeca & Food Service": target_limit = 66; break; case "Mesin Pembersih & Janitorial": target_limit = 99; break; case "Mesin Pertanian & Perkebunan": target_limit = 56; break; case "Peralatan Kantor & Stationery": target_limit = 95; break; case "Peralatan Listrik & Elektronik": target_limit = 71; break; case "Perkakas Tangan, Listrik & Pneumatic": target_limit = 33; break; case "Perlengkapan Logistik & Gudang": target_limit = 62; break; case "Perlengkapan Pengukuran & Pengujian": target_limit = 41; break; // --- DEFAULT () --- default: target_limit = 59; } var po_to_arrival_status = 'not achieve'; if (new_po_to_arrival != null) { if (Math.floor(new_po_to_arrival) < target_limit) { po_to_arrival_status = 'achieve'; } } po_to_arrival_status po_to_arrival_status String -1 -1 N 768 80 Y Modified JavaScript value 2 ScriptValueMod Y 1 none N 9 0 Script 1 //Script here var po_to_arrival_status = 'not achieve'; if (new_po_to_arrival <= 48) { po_to_arrival_status = 'achieve' } else{ po_to_arrival_status = 'not achieve' } po_to_arrival_status po_to_arrival_status String -1 -1 N 960 80 Y Select values SelectValues Y 1 none po_confirm_date received_good_date purchase_line_id purchase_id received_id N 320 80 Y Select values 2 SelectValues Y 1 none po_confirm_date received_good_date purchase_line_id purchase_id received_id parent_category N 176 192 Y Select values 3 SelectValues Y 1 none po_confirm_date received_good_date purchase_line_id purchase_id new_po_to_arrival received_id parent_category N 592 304 Y Select values 4 SelectValues Y 1 none po_confirm_date received_good_date purchase_line_id purchase_id new_po_to_arrival po_to_arrival_status received_id N 768 192 Y Sort rows SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N purchase_line_id Y N N 0 N purchase_id Y N N 0 N received_id Y N N 0 N 176 304 Y Sort rows 2 SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N purchase_line_id Y N N 0 N purchase_id Y N N 0 N received_id Y N N 0 N 464 192 Y Sort rows 3 SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N purchase_line_id Y N N 0 N purchase_id Y N N 0 N received_id Y N N 0 N 592 192 Y Table input TableInput N 1 none dw bi indoteknik (localhost) select po_confirm_date, received_good_date, purchase_line_id, purchase_id, received_id, parent_category from mv_leadtime_po_to_received --where purchase_id = 24864 and purchase_line_id = 140704 and received_id in (76715) 0 N N N N Date normal po_confirm_date 6 -1 Table input po_confirm_date . , none N Y 0 N N N en_US Asia/Bangkok N Date normal received_good_date 6 -1 Table input received_good_date . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal purchase_line_id 9 0 Table input purchase_line_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal purchase_id 9 0 Table input purchase_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal received_id 9 0 Table input received_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal parent_category 2147483647 -1 Table input parent_category . , none N Y 0 N N N en_US Asia/Bangkok N 176 80 Y Table input 2 TableInput Y 1 none dw bi indoteknik (localhost) WITH params AS ( SELECT ?::timestamp AS start_time, ?::timestamp AS end_time ), hours AS ( SELECT generate_series( (SELECT start_time FROM params), (SELECT end_time FROM params), interval '1 hour' ) AS ts ), filtered_hours AS ( SELECT ts FROM hours WHERE 1=1 --AND EXTRACT(HOUR FROM ts) BETWEEN 8 AND 17 --AND ( -- EXTRACT(HOUR FROM ts) > 8 OR EXTRACT(MINUTE FROM ts) >= 30 --) AND EXTRACT(DOW FROM ts) NOT IN (0) AND DATE(ts) NOT IN (SELECT holiday_date FROM holidays) ) SELECT COUNT(*) AS new_po_to_arrival, ? as purchase_line_id, ? as purchase_id, ? as received_id FROM filtered_hours; 0 Select values Y Y N N Integer normal new_po_to_arrival 15 0 Table input 2 new_po_to_arrival ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal purchase_line_id 2147483647 -1 Table input 2 purchase_line_id . , none N Y 0 N N N en_US Asia/Bangkok N String normal purchase_id 2147483647 -1 Table input 2 purchase_id . , none N Y 0 N N N en_US Asia/Bangkok N String normal received_id 2147483647 -1 Table input 2 received_id . , none N Y 0 N N N en_US Asia/Bangkok N 464 80 Y Unique rows Unique Y 1 none N N purchase_line_id N purchase_id N received_id N 592 80 Y N