diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2024-11-13 15:10:21 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2024-11-13 15:10:21 +0700 |
| commit | e59cb0efe5f17160173ec1a4c86bbfbd3b83895a (patch) | |
| tree | c82d9c25abc093965e25697b23165750fd940060 /calculate_financial_report.ktr | |
| parent | a1f8abf5c5be6ad99eb21bff6b7a85b399e1b7c8 (diff) | |
change password
Diffstat (limited to 'calculate_financial_report.ktr')
| -rw-r--r-- | calculate_financial_report.ktr | 90 |
1 files changed, 36 insertions, 54 deletions
diff --git a/calculate_financial_report.ktr b/calculate_financial_report.ktr index f3094f7..e45bb23 100644 --- a/calculate_financial_report.ktr +++ b/calculate_financial_report.ktr @@ -442,8 +442,8 @@ <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> - <username>odoo</username> - <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> + <username>pdi</username> + <password>Encrypted 2be989bb20084ca95810197629d9ea18e</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -981,6 +981,40 @@ </GUI> </step> <step> + <name>Merge join 15</name> + <type>MergeJoin</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <join_type>INNER</join_type> + <step1>Merge join 14</step1> + <step2>total_fy</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>608</xloc> + <yloc>256</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Merge join 2</name> <type>MergeJoin</type> <description/> @@ -1266,75 +1300,57 @@ <fields> <field> <name>id</name> - <rename/> </field> <field> <name>name</name> - <rename/> </field> <field> <name>ly_full</name> - <rename/> </field> <field> <name>ly_running</name> - <rename/> </field> <field> <name>ly_current</name> - <rename/> </field> <field> <name>fy1</name> - <rename/> </field> <field> <name>fy2</name> - <rename/> </field> <field> <name>fy3</name> - <rename/> </field> <field> <name>fy4</name> - <rename/> </field> <field> <name>fy5</name> - <rename/> </field> <field> <name>fy6</name> - <rename/> </field> <field> <name>fy7</name> - <rename/> </field> <field> <name>fy8</name> - <rename/> </field> <field> <name>fy9</name> - <rename/> </field> <field> <name>fy10</name> - <rename/> </field> <field> <name>fy11</name> - <rename/> </field> <field> <name>fy12</name> - <rename/> </field> <field> <name>total_fy</name> - <rename/> </field> <select_unspecified>N</select_unspecified> </fields> @@ -3269,40 +3285,6 @@ order by id</sql> <draw>Y</draw> </GUI> </step> - <step> - <name>Merge join 15</name> - <type>MergeJoin</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <join_type>INNER</join_type> - <step1>Merge join 14</step1> - <step2>total_fy</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>608</xloc> - <yloc>256</yloc> - <draw>Y</draw> - </GUI> - </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> |