calculate_profit_loss 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 - 2024/05/15 15:44:47.232 - 2024/05/15 15:44:47.232 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 calculate gross profit Append streams Y calculate net profit Append streams Y Append streams Select values Y Select values Insert / update Y calculate gross profit TableInput Y 1 none dw bi indoteknik (localhost) select 99998 as id, 'GROSS PROFIT' as name, (select sum(ly_full) from profit_and_loss pal where pal.id in(322,323)) as ly_full, (select sum(ly_running) from profit_and_loss pal where pal.id in(322,323)) as ly_running, (select sum(ly_current) from profit_and_loss pal where pal.id in(322,323)) as ly_current, (select sum(fy1) from profit_and_loss pal where pal.id in(322,323)) as fy1, (select sum(fy2) from profit_and_loss pal where pal.id in(322,323)) as fy2, (select sum(fy3) from profit_and_loss pal where pal.id in(322,323)) as fy3, (select sum(fy4) from profit_and_loss pal where pal.id in(322,323)) as fy4, (select sum(fy5) from profit_and_loss pal where pal.id in(322,323)) as fy5, (select sum(fy6) from profit_and_loss pal where pal.id in(322,323)) as fy6, (select sum(fy7) from profit_and_loss pal where pal.id in(322,323)) as fy7, (select sum(fy8) from profit_and_loss pal where pal.id in(322,323)) as fy8, (select sum(fy9) from profit_and_loss pal where pal.id in(322,323)) as fy9, (select sum(fy10) from profit_and_loss pal where pal.id in(322,323)) as fy10, (select sum(fy11) from profit_and_loss pal where pal.id in(322,323)) as fy11, (select sum(fy12) from profit_and_loss pal where pal.id in(322,323)) as fy12, (select sum(total_fy) from profit_and_loss pal where pal.id in(322,323)) as total_fy 0 N N N N Integer normal id 9 0 calculate gross profit id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N String normal name 2147483647 -1 calculate gross profit name . , none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal ly_full -1 -1 calculate gross profit ly_full ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal ly_running -1 -1 calculate gross profit ly_running ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal ly_current -1 -1 calculate gross profit ly_current ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy1 -1 -1 calculate gross profit fy1 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy2 -1 -1 calculate gross profit fy2 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy3 -1 -1 calculate gross profit fy3 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy4 -1 -1 calculate gross profit fy4 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy5 -1 -1 calculate gross profit fy5 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy6 -1 -1 calculate gross profit fy6 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy7 -1 -1 calculate gross profit fy7 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy8 -1 -1 calculate gross profit fy8 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy9 -1 -1 calculate gross profit fy9 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy10 -1 -1 calculate gross profit fy10 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy11 -1 -1 calculate gross profit fy11 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy12 -1 -1 calculate gross profit fy12 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N

288 112 Y calculate net profit TableInput Y 1 none dw bi indoteknik (localhost) select 99999 as id, 'NET PROFIT' as name, (select sum(ly_full) from profit_and_loss pal where pal.id < 90000) as ly_full, (select sum(ly_running) from profit_and_loss pal where pal.id < 90000) as ly_running, (select sum(ly_current) from profit_and_loss pal where pal.id < 90000) as ly_current, (select sum(fy1) from profit_and_loss pal where pal.id < 90000) as fy1, (select sum(fy2) from profit_and_loss pal where pal.id < 90000) as fy2, (select sum(fy3) from profit_and_loss pal where pal.id < 90000) as fy3, (select sum(fy4) from profit_and_loss pal where pal.id < 90000) as fy4, (select sum(fy5) from profit_and_loss pal where pal.id < 90000) as fy5, (select sum(fy6) from profit_and_loss pal where pal.id < 90000) as fy6, (select sum(fy7) from profit_and_loss pal where pal.id < 90000) as fy7, (select sum(fy8) from profit_and_loss pal where pal.id < 90000) as fy8, (select sum(fy9) from profit_and_loss pal where pal.id < 90000) as fy9, (select sum(fy10) from profit_and_loss pal where pal.id < 90000) as fy10, (select sum(fy11) from profit_and_loss pal where pal.id < 90000) as fy11, (select sum(fy12) from profit_and_loss pal where pal.id < 90000) as fy12, (select sum(total_fy) from profit_and_loss pal where pal.id < 90000) as total_fy 0 N N N N Integer normal id 9 0 calculate net profit id ####0;-####0 . , none N Y 0 N N N en_ID Asia/Bangkok N String normal name 2147483647 -1 calculate net profit name . , none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal ly_full -1 -1 calculate net profit ly_full ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal ly_running -1 -1 calculate net profit ly_running ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal ly_current -1 -1 calculate net profit ly_current ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy1 -1 -1 calculate net profit fy1 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy2 -1 -1 calculate net profit fy2 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy3 -1 -1 calculate net profit fy3 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy4 -1 -1 calculate net profit fy4 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy5 -1 -1 calculate net profit fy5 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy6 -1 -1 calculate net profit fy6 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy7 -1 -1 calculate net profit fy7 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy8 -1 -1 calculate net profit fy8 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy9 -1 -1 calculate net profit fy9 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy10 -1 -1 calculate net profit fy10 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy11 -1 -1 calculate net profit fy11 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal fy12 -1 -1 calculate net profit fy12 ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N BigNumber normal total_fy -1 -1 calculate net profit total_fy ######0.0###################;-######0.0################### . none N Y 0 N N N en_ID Asia/Bangkok N

512 112 Y Append streams Append Y 1 none calculate gross profit calculate net profit

288 224 Y Select values SelectValues Y 1 none id name ly_full ly_running ly_current fy1 fy2 fy3 fy4 fy5 fy6 fy7 fy8 fy9 fy10 fy11 fy12 total_fy N

512 224 Y Insert / update InsertUpdate Y 1 none dw bi indoteknik (localhost) 100 N public profit_and_loss id id = id id N name name Y ly_full ly_full Y ly_running ly_running Y ly_current ly_current Y fy1 fy1 Y fy2 fy2 Y fy3 fy3 Y fy4 fy4 Y fy5 fy5 Y fy6 fy6 Y fy7 fy7 Y fy8 fy8 Y fy9 fy9 Y fy10 fy10 Y fy11 fy11 Y fy12 fy12 Y total_fy total_fy Y

704 224 Y N