diff options
| -rw-r--r-- | calculate_margin_invoice_v3.ktr | 1408 |
1 files changed, 670 insertions, 738 deletions
diff --git a/calculate_margin_invoice_v3.ktr b/calculate_margin_invoice_v3.ktr index fa17fbb..a11ee0d 100644 --- a/calculate_margin_invoice_v3.ktr +++ b/calculate_margin_invoice_v3.ktr @@ -430,7 +430,7 @@ <created_date>2025/08/13 09:47:28.228</created_date> <modified_user>-</modified_user> <modified_date>2025/08/13 09:47:28.228</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> @@ -579,6 +579,601 @@ </hop> </order> <step> + <name>Add constants</name> + <type>Constant</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>one_hundred</name> + <type>BigNumber</type> + <format/> + <currency/> + <decimal/> + <group/> + <nullif>100</nullif> + <length>-1</length> + <precision>-1</precision> + <set_empty_string>N</set_empty_string> + </field> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>960</xloc> + <yloc>400</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Calculator</name> + <type>Calculator</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <failIfNoFile>Y</failIfNoFile> + <calculation> + <field_name>margin</field_name> + <calc_type>SUBTRACT</calc_type> + <field_a>penjualan</field_a> + <field_b>hpp</field_b> + <field_c/> + <value_type>None</value_type> + <value_length>-1</value_length> + <value_precision>-1</value_precision> + <remove>N</remove> + <conversion_mask/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + </calculation> + <calculation> + <field_name>div_margin</field_name> + <calc_type>DIVIDE</calc_type> + <field_a>margin</field_a> + <field_b>penjualan</field_b> + <field_c/> + <value_type>None</value_type> + <value_length>-1</value_length> + <value_precision>-1</value_precision> + <remove>N</remove> + <conversion_mask/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + </calculation> + <calculation> + <field_name>percent_margin</field_name> + <calc_type>MULTIPLY</calc_type> + <field_a>div_margin</field_a> + <field_b>one_hundred</field_b> + <field_c/> + <value_type>None</value_type> + <value_length>-1</value_length> + <value_precision>-1</value_precision> + <remove>N</remove> + <conversion_mask/> + <decimal_symbol/> + <grouping_symbol/> + <currency_symbol/> + </calculation> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>1104</xloc> + <yloc>400</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Filter rows</name> + <type>FilterRows</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <send_true_to>select all</send_true_to> + <send_false_to>Write to log</send_false_to> + <compare> + <condition> + <negated>N</negated> + <conditions> + <condition> + <negated>N</negated> + <leftvalue>penjualan</leftvalue> + <function>></function> + <rightvalue/> + <value> + <name>constant</name> + <type>BigNumber</type> + <text>0.0</text> + <length>-1</length> + <precision>-1</precision> + <isnull>N</isnull> + <mask>######0.0###################;-######0.0###################</mask> + </value> + </condition> + <condition> + <negated>N</negated> + <operator>AND</operator> + <leftvalue>hpp</leftvalue> + <function>></function> + <rightvalue/> + <value> + <name>constant</name> + <type>BigNumber</type> + <text>0.0</text> + <length>-1</length> + <precision>-1</precision> + <isnull>N</isnull> + <mask>######0.0###################;-######0.0###################</mask> + </value> + </condition> + </conditions> + </condition> + </compare> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>416</xloc> + <yloc>288</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Insert / update</name> + <type>InsertUpdate</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik (localhost)</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>margin_invoice_v3</table> + <key> + <name>id</name> + <field>id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>id</name> + <rename>id</rename> + <update>N</update> + </value> + <value> + <name>move_id</name> + <rename>move_id</rename> + <update>Y</update> + </value> + <value> + <name>date</name> + <rename>date</rename> + <update>Y</update> + </value> + <value> + <name>invoice_origin</name> + <rename>invoice_origin</rename> + <update>Y</update> + </value> + <value> + <name>invoice</name> + <rename>invoice</rename> + <update>Y</update> + </value> + <value> + <name>customer</name> + <rename>customer</rename> + <update>Y</update> + </value> + <value> + <name>lob</name> + <rename>lob</rename> + <update>Y</update> + </value> + <value> + <name>brand</name> + <rename>brand</rename> + <update>Y</update> + </value> + <value> + <name>product_id</name> + <rename>product_id</rename> + <update>Y</update> + </value> + <value> + <name>item_code</name> + <rename>item_code</rename> + <update>Y</update> + </value> + <value> + <name>product</name> + <rename>product</rename> + <update>Y</update> + </value> + <value> + <name>salesperson</name> + <rename>salesperson</rename> + <update>Y</update> + </value> + <value> + <name>quantity</name> + <rename>quantity</rename> + <update>Y</update> + </value> + <value> + <name>price_unit</name> + <rename>price_unit</rename> + <update>Y</update> + </value> + <value> + <name>price_subtotal</name> + <rename>price_subtotal</rename> + <update>Y</update> + </value> + <value> + <name>price_total</name> + <rename>price_total</rename> + <update>Y</update> + </value> + <value> + <name>penjualan</name> + <rename>penjualan</rename> + <update>Y</update> + </value> + <value> + <name>hpp</name> + <rename>hpp</rename> + <update>Y</update> + </value> + <value> + <name>sale_order</name> + <rename>sale_order</rename> + <update>Y</update> + </value> + <value> + <name>sale_product_id</name> + <rename>sale_product_id</rename> + <update>Y</update> + </value> + <value> + <name>vendor_id</name> + <rename>vendor_id</rename> + <update>Y</update> + </value> + <value> + <name>vendor</name> + <rename>vendor</rename> + <update>Y</update> + </value> + <value> + <name>margin</name> + <rename>margin</rename> + <update>Y</update> + </value> + <value> + <name>div_margin</name> + <rename>div_margin</rename> + <update>Y</update> + </value> + <value> + <name>percent_margin</name> + <rename>percent_margin</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>1104</xloc> + <yloc>80</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Merge join</name> + <type>MergeJoin</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <join_type>LEFT OUTER</join_type> + <step1>penjualan</step1> + <step2>hpp</step2> + <keys_1> + <key>move_id</key> + <key>product_id</key> + </keys_1> + <keys_2> + <key>move_id</key> + <key>product_id</key> + </keys_2> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>240</xloc> + <yloc>288</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Merge join 2</name> + <type>MergeJoin</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <join_type>LEFT OUTER</join_type> + <step1>Sort rows</step1> + <step2>Sort rows 2</step2> + <keys_1> + <key>id</key> + </keys_1> + <keys_2> + <key>id</key> + </keys_2> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>832</xloc> + <yloc>400</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Select values</name> + <type>SelectValues</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <fields> + <field> + <name>id</name> + </field> + <field> + <name>move_id</name> + </field> + <field> + <name>date</name> + </field> + <field> + <name>invoice_origin</name> + </field> + <field> + <name>invoice</name> + </field> + <field> + <name>customer</name> + </field> + <field> + <name>lob</name> + </field> + <field> + <name>brand</name> + </field> + <field> + <name>product_id</name> + </field> + <field> + <name>item_code</name> + </field> + <field> + <name>product</name> + </field> + <field> + <name>salesperson</name> + </field> + <field> + <name>quantity</name> + </field> + <field> + <name>price_unit</name> + </field> + <field> + <name>price_subtotal</name> + </field> + <field> + <name>price_total</name> + </field> + <field> + <name>penjualan</name> + </field> + <field> + <name>hpp</name> + </field> + <field> + <name>sale_order</name> + </field> + <field> + <name>sale_product_id</name> + </field> + <field> + <name>vendor_id</name> + </field> + <field> + <name>vendor</name> + </field> + <field> + <name>margin</name> + </field> + <field> + <name>div_margin</name> + </field> + <field> + <name>percent_margin</name> + </field> + <select_unspecified>N</select_unspecified> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>1104</xloc> + <yloc>272</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Sort rows</name> + <type>SortRows</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <directory>%%java.io.tmpdir%%</directory> + <prefix>out</prefix> + <sort_size>1000000</sort_size> + <free_memory/> + <compress>N</compress> + <compress_variable/> + <unique_rows>N</unique_rows> + <fields> + <field> + <name>id</name> + <ascending>Y</ascending> + <case_sensitive>N</case_sensitive> + <collator_enabled>N</collator_enabled> + <collator_strength>0</collator_strength> + <presorted>N</presorted> + </field> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>688</xloc> + <yloc>400</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Sort rows 2</name> + <type>SortRows</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <directory>%%java.io.tmpdir%%</directory> + <prefix>out</prefix> + <sort_size>1000000</sort_size> + <free_memory/> + <compress>N</compress> + <compress_variable/> + <unique_rows>N</unique_rows> + <fields> + <field> + <name>id</name> + <ascending>Y</ascending> + <case_sensitive>N</case_sensitive> + <collator_enabled>N</collator_enabled> + <collator_strength>0</collator_strength> + <presorted>N</presorted> + </field> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>832</xloc> + <yloc>272</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Table input</name> <type>TableInput</type> <description/> @@ -607,6 +1202,7 @@ left join brand b on b.id = p.brand_id where 1=1 and aml.account_id = 462 and am.state = 'posted' +--and aml.date >= '2025-08-20' and aml.date >= '2024-06-01' --and aml.write_date >= (now() - '3 days'::interval)</sql> <limit>0</limit> @@ -1023,48 +1619,6 @@ and aml.date >= '2024-06-01' </GUI> </step> <step> - <name>penjualan</name> - <type>SortRows</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <directory>%%java.io.tmpdir%%</directory> - <prefix>out</prefix> - <sort_size>1000000</sort_size> - <free_memory/> - <compress>N</compress> - <compress_variable/> - <unique_rows>N</unique_rows> - <fields> - <field> - <name>id</name> - <ascending>Y</ascending> - <case_sensitive>N</case_sensitive> - <collator_enabled>N</collator_enabled> - <collator_strength>0</collator_strength> - <presorted>N</presorted> - </field> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>144</xloc> - <yloc>176</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> <name>Table input 2</name> <type>TableInput</type> <description/> @@ -1090,6 +1644,7 @@ join account_move am on am.id = aml.move_id where 1=1 and aml.account_id = 466 and am.state = 'posted' +--and aml.date >= '2025-08-20' and aml.date >= '2024-06-01' --and aml.write_date >= (now() - '3 days'::interval)</sql> <limit>0</limit> @@ -1207,333 +1762,6 @@ and aml.date >= '2024-06-01' </GUI> </step> <step> - <name>hpp</name> - <type>SortRows</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <directory>%%java.io.tmpdir%%</directory> - <prefix>out</prefix> - <sort_size>1000000</sort_size> - <free_memory/> - <compress>N</compress> - <compress_variable/> - <unique_rows>N</unique_rows> - <fields> - <field> - <name>id</name> - <ascending>Y</ascending> - <case_sensitive>N</case_sensitive> - <collator_enabled>N</collator_enabled> - <collator_strength>0</collator_strength> - <presorted>N</presorted> - </field> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>320</xloc> - <yloc>176</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Merge join</name> - <type>MergeJoin</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <join_type>LEFT OUTER</join_type> - <step1>penjualan</step1> - <step2>hpp</step2> - <keys_1> - <key>move_id</key> - <key>product_id</key> - </keys_1> - <keys_2> - <key>move_id</key> - <key>product_id</key> - </keys_2> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>240</xloc> - <yloc>288</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Filter rows</name> - <type>FilterRows</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <send_true_to>select all</send_true_to> - <send_false_to>Write to log</send_false_to> - <compare> - <condition> - <negated>N</negated> - <conditions> - <condition> - <negated>N</negated> - <leftvalue>penjualan</leftvalue> - <function>></function> - <rightvalue/> - <value> - <name>constant</name> - <type>BigNumber</type> - <text>0.0</text> - <length>-1</length> - <precision>-1</precision> - <isnull>N</isnull> - <mask>######0.0###################;-######0.0###################</mask> - </value> - </condition> - <condition> - <negated>N</negated> - <operator>AND</operator> - <leftvalue>hpp</leftvalue> - <function>></function> - <rightvalue/> - <value> - <name>constant</name> - <type>BigNumber</type> - <text>0.0</text> - <length>-1</length> - <precision>-1</precision> - <isnull>N</isnull> - <mask>######0.0###################;-######0.0###################</mask> - </value> - </condition> - </conditions> - </condition> - </compare> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>416</xloc> - <yloc>288</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Write to log</name> - <type>WriteToLog</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <loglevel>log_level_basic</loglevel> - <displayHeader>Y</displayHeader> - <limitRows>N</limitRows> - <limitRowsNumber>0</limitRowsNumber> - <logmessage/> - <fields> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>416</xloc> - <yloc>400</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>select all</name> - <type>SelectValues</type> - <description/> - <distribute>N</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>id</name> - <rename/> - </field> - <field> - <name>move_id</name> - <rename/> - </field> - <field> - <name>date</name> - <rename/> - </field> - <field> - <name>invoice_origin</name> - <rename/> - </field> - <field> - <name>invoice</name> - <rename/> - </field> - <field> - <name>customer</name> - <rename/> - </field> - <field> - <name>lob</name> - <rename/> - </field> - <field> - <name>brand</name> - <rename/> - </field> - <field> - <name>product_id</name> - <rename/> - </field> - <field> - <name>item_code</name> - <rename/> - </field> - <field> - <name>product</name> - <rename/> - </field> - <field> - <name>salesperson</name> - <rename/> - </field> - <field> - <name>quantity</name> - <rename/> - </field> - <field> - <name>price_unit</name> - <rename/> - </field> - <field> - <name>price_subtotal</name> - <rename/> - </field> - <field> - <name>price_total</name> - <rename/> - </field> - <field> - <name>penjualan</name> - <rename/> - </field> - <field> - <name>id_1</name> - <rename/> - </field> - <field> - <name>move_id_1</name> - <rename/> - </field> - <field> - <name>product_id_1</name> - <rename/> - </field> - <field> - <name>hpp</name> - <rename/> - </field> - <select_unspecified>N</select_unspecified> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>560</xloc> - <yloc>288</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>param only</name> - <type>SelectValues</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <fields> - <field> - <name>id</name> - <rename/> - </field> - <field> - <name>invoice_origin</name> - <rename/> - </field> - <field> - <name>product_id</name> - <rename/> - </field> - <select_unspecified>N</select_unspecified> - </fields> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>688</xloc> - <yloc>192</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> <name>Table input 3</name> <type>TableInput</type> <description/> @@ -1684,7 +1912,39 @@ and tso.name = ? and tsol.vendor_id = ?</sql> </remotesteps> <GUI> <xloc>832</xloc> - <yloc>192</yloc> + <yloc>80</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>Write to log</name> + <type>WriteToLog</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <loglevel>log_level_basic</loglevel> + <displayHeader>Y</displayHeader> + <limitRows>N</limitRows> + <limitRowsNumber>0</limitRowsNumber> + <logmessage/> + <fields> + </fields> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>416</xloc> + <yloc>400</yloc> <draw>Y</draw> </GUI> </step> @@ -1702,87 +1962,66 @@ and tso.name = ? and tsol.vendor_id = ?</sql> <fields> <field> <name>id</name> - <rename/> </field> <field> <name>move_id</name> - <rename/> </field> <field> <name>date</name> - <rename/> </field> <field> <name>invoice_origin</name> - <rename/> </field> <field> <name>invoice</name> - <rename/> </field> <field> <name>customer</name> - <rename/> </field> <field> <name>lob</name> - <rename/> </field> <field> <name>brand</name> - <rename/> </field> <field> <name>product_id</name> - <rename/> </field> <field> <name>item_code</name> - <rename/> </field> <field> <name>product</name> - <rename/> </field> <field> <name>salesperson</name> - <rename/> </field> <field> <name>quantity</name> - <rename/> </field> <field> <name>price_unit</name> - <rename/> </field> <field> <name>price_subtotal</name> - <rename/> </field> <field> <name>price_total</name> - <rename/> </field> <field> <name>penjualan</name> - <rename/> </field> <field> <name>id_1</name> - <rename/> </field> <field> <name>move_id_1</name> - <rename/> </field> <field> <name>product_id_1</name> - <rename/> </field> <field> <name>hpp</name> - <rename/> </field> <select_unspecified>N</select_unspecified> </fields> @@ -1801,7 +2040,7 @@ and tso.name = ? and tsol.vendor_id = ?</sql> </GUI> </step> <step> - <name>Sort rows</name> + <name>hpp</name> <type>SortRows</type> <description/> <distribute>Y</distribute> @@ -1837,14 +2076,14 @@ and tso.name = ? and tsol.vendor_id = ?</sql> </output> </remotesteps> <GUI> - <xloc>688</xloc> - <yloc>400</yloc> + <xloc>320</xloc> + <yloc>176</yloc> <draw>Y</draw> </GUI> </step> <step> - <name>Sort rows 2</name> - <type>SortRows</type> + <name>param only</name> + <type>SelectValues</type> <description/> <distribute>Y</distribute> <custom_distribution/> @@ -1853,22 +2092,17 @@ and tso.name = ? and tsol.vendor_id = ?</sql> <method>none</method> <schema_name/> </partitioning> - <directory>%%java.io.tmpdir%%</directory> - <prefix>out</prefix> - <sort_size>1000000</sort_size> - <free_memory/> - <compress>N</compress> - <compress_variable/> - <unique_rows>N</unique_rows> <fields> <field> <name>id</name> - <ascending>Y</ascending> - <case_sensitive>N</case_sensitive> - <collator_enabled>N</collator_enabled> - <collator_strength>0</collator_strength> - <presorted>N</presorted> </field> + <field> + <name>invoice_origin</name> + </field> + <field> + <name>product_id</name> + </field> + <select_unspecified>N</select_unspecified> </fields> <attributes/> <cluster_schema/> @@ -1879,119 +2113,14 @@ and tso.name = ? and tsol.vendor_id = ?</sql> </output> </remotesteps> <GUI> - <xloc>832</xloc> - <yloc>272</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Merge join 2</name> - <type>MergeJoin</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <join_type>LEFT OUTER</join_type> - <step1>Sort rows</step1> - <step2>Sort rows 2</step2> - <keys_1> - <key>id</key> - </keys_1> - <keys_2> - <key>id</key> - </keys_2> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>832</xloc> - <yloc>400</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Calculator</name> - <type>Calculator</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <failIfNoFile>Y</failIfNoFile> - <calculation> - <field_name>margin</field_name> - <calc_type>SUBTRACT</calc_type> - <field_a>penjualan</field_a> - <field_b>hpp</field_b> - <field_c/> - <value_type>None</value_type> - <value_length>-1</value_length> - <value_precision>-1</value_precision> - <remove>N</remove> - <conversion_mask/> - <decimal_symbol/> - <grouping_symbol/> - <currency_symbol/> - </calculation> - <calculation> - <field_name>div_margin</field_name> - <calc_type>DIVIDE</calc_type> - <field_a>margin</field_a> - <field_b>penjualan</field_b> - <field_c/> - <value_type>None</value_type> - <value_length>-1</value_length> - <value_precision>-1</value_precision> - <remove>N</remove> - <conversion_mask/> - <decimal_symbol/> - <grouping_symbol/> - <currency_symbol/> - </calculation> - <calculation> - <field_name>percent_margin</field_name> - <calc_type>MULTIPLY</calc_type> - <field_a>div_margin</field_a> - <field_b>one_hundred</field_b> - <field_c/> - <value_type>None</value_type> - <value_length>-1</value_length> - <value_precision>-1</value_precision> - <remove>N</remove> - <conversion_mask/> - <decimal_symbol/> - <grouping_symbol/> - <currency_symbol/> - </calculation> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>992</xloc> - <yloc>160</yloc> + <xloc>688</xloc> + <yloc>192</yloc> <draw>Y</draw> </GUI> </step> <step> - <name>Add constants</name> - <type>Constant</type> + <name>penjualan</name> + <type>SortRows</type> <description/> <distribute>Y</distribute> <custom_distribution/> @@ -2000,18 +2129,21 @@ and tso.name = ? and tsol.vendor_id = ?</sql> <method>none</method> <schema_name/> </partitioning> + <directory>%%java.io.tmpdir%%</directory> + <prefix>out</prefix> + <sort_size>1000000</sort_size> + <free_memory/> + <compress>N</compress> + <compress_variable/> + <unique_rows>N</unique_rows> <fields> <field> - <name>one_hundred</name> - <type>BigNumber</type> - <format/> - <currency/> - <decimal/> - <group/> - <nullif>100</nullif> - <length>-1</length> - <precision>-1</precision> - <set_empty_string>N</set_empty_string> + <name>id</name> + <ascending>Y</ascending> + <case_sensitive>N</case_sensitive> + <collator_enabled>N</collator_enabled> + <collator_strength>0</collator_strength> + <presorted>N</presorted> </field> </fields> <attributes/> @@ -2023,16 +2155,16 @@ and tso.name = ? and tsol.vendor_id = ?</sql> </output> </remotesteps> <GUI> - <xloc>992</xloc> - <yloc>32</yloc> + <xloc>144</xloc> + <yloc>176</yloc> <draw>Y</draw> </GUI> </step> <step> - <name>Select values</name> + <name>select all</name> <type>SelectValues</type> <description/> - <distribute>Y</distribute> + <distribute>N</distribute> <custom_distribution/> <copies>1</copies> <partitioning> @@ -2042,103 +2174,66 @@ and tso.name = ? and tsol.vendor_id = ?</sql> <fields> <field> <name>id</name> - <rename/> </field> <field> <name>move_id</name> - <rename/> </field> <field> <name>date</name> - <rename/> </field> <field> <name>invoice_origin</name> - <rename/> </field> <field> <name>invoice</name> - <rename/> </field> <field> <name>customer</name> - <rename/> </field> <field> <name>lob</name> - <rename/> </field> <field> <name>brand</name> - <rename/> </field> <field> <name>product_id</name> - <rename/> </field> <field> <name>item_code</name> - <rename/> </field> <field> <name>product</name> - <rename/> </field> <field> <name>salesperson</name> - <rename/> </field> <field> <name>quantity</name> - <rename/> </field> <field> <name>price_unit</name> - <rename/> </field> <field> <name>price_subtotal</name> - <rename/> </field> <field> <name>price_total</name> - <rename/> </field> <field> <name>penjualan</name> - <rename/> - </field> - <field> - <name>hpp</name> - <rename/> - </field> - <field> - <name>sale_order</name> - <rename/> - </field> - <field> - <name>sale_product_id</name> - <rename/> - </field> - <field> - <name>vendor_id</name> - <rename/> </field> <field> - <name>vendor</name> - <rename/> + <name>id_1</name> </field> <field> - <name>margin</name> - <rename/> + <name>move_id_1</name> </field> <field> - <name>div_margin</name> - <rename/> + <name>product_id_1</name> </field> <field> - <name>percent_margin</name> - <rename/> + <name>hpp</name> </field> <select_unspecified>N</select_unspecified> </fields> @@ -2151,171 +2246,8 @@ and tso.name = ? and tsol.vendor_id = ?</sql> </output> </remotesteps> <GUI> - <xloc>992</xloc> - <yloc>256</yloc> - <draw>Y</draw> - </GUI> - </step> - <step> - <name>Insert / update</name> - <type>InsertUpdate</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <connection>dw bi indoteknik (localhost)</connection> - <commit>100</commit> - <update_bypassed>N</update_bypassed> - <lookup> - <schema>public</schema> - <table>margin_invoice_v3</table> - <key> - <name/> - <field>id</field> - <condition/> - <name2/> - </key> - <value> - <name>id</name> - <rename>id</rename> - <update>N</update> - </value> - <value> - <name>move_id</name> - <rename>move_id</rename> - <update>Y</update> - </value> - <value> - <name>date</name> - <rename>date</rename> - <update>Y</update> - </value> - <value> - <name>invoice_origin</name> - <rename>invoice_origin</rename> - <update>Y</update> - </value> - <value> - <name>invoice</name> - <rename>invoice</rename> - <update>Y</update> - </value> - <value> - <name>customer</name> - <rename>customer</rename> - <update>Y</update> - </value> - <value> - <name>lob</name> - <rename>lob</rename> - <update>Y</update> - </value> - <value> - <name>brand</name> - <rename>brand</rename> - <update>Y</update> - </value> - <value> - <name>product_id</name> - <rename>product_id</rename> - <update>Y</update> - </value> - <value> - <name>item_code</name> - <rename>item_code</rename> - <update>Y</update> - </value> - <value> - <name>product</name> - <rename>product</rename> - <update>Y</update> - </value> - <value> - <name>salesperson</name> - <rename>salesperson</rename> - <update>Y</update> - </value> - <value> - <name>quantity</name> - <rename>quantity</rename> - <update>Y</update> - </value> - <value> - <name>price_unit</name> - <rename>price_unit</rename> - <update>Y</update> - </value> - <value> - <name>price_subtotal</name> - <rename>price_subtotal</rename> - <update>Y</update> - </value> - <value> - <name>price_total</name> - <rename>price_total</rename> - <update>Y</update> - </value> - <value> - <name>penjualan</name> - <rename>penjualan</rename> - <update>Y</update> - </value> - <value> - <name>hpp</name> - <rename>hpp</rename> - <update>Y</update> - </value> - <value> - <name>sale_order</name> - <rename>sale_order</rename> - <update>Y</update> - </value> - <value> - <name>sale_product_id</name> - <rename>sale_product_id</rename> - <update>Y</update> - </value> - <value> - <name>vendor_id</name> - <rename>vendor_id</rename> - <update>Y</update> - </value> - <value> - <name>vendor</name> - <rename>vendor</rename> - <update>Y</update> - </value> - <value> - <name>margin</name> - <rename>margin</rename> - <update>Y</update> - </value> - <value> - <name>div_margin</name> - <rename>div_margin</rename> - <update>Y</update> - </value> - <value> - <name>percent_margin</name> - <rename>percent_margin</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>992</xloc> - <yloc>352</yloc> + <xloc>560</xloc> + <yloc>288</yloc> <draw>Y</draw> </GUI> </step> |