diff options
| -rw-r--r-- | refresh_materialized_view.ktr | 149 |
1 files changed, 139 insertions, 10 deletions
diff --git a/refresh_materialized_view.ktr b/refresh_materialized_view.ktr index 5435816..ffa216f 100644 --- a/refresh_materialized_view.ktr +++ b/refresh_materialized_view.ktr @@ -537,6 +537,21 @@ <to>growth category brand per year</to> <enabled>Y</enabled> </hop> + <hop> + <from>growth category brand per year</from> + <to>sale order</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>sale order group</from> + <to>compare conversion rate brand</to> + <enabled>Y</enabled> + </hop> + <hop> + <from>sale order</from> + <to>sale order group</to> + <enabled>Y</enabled> + </hop> </order> <step> <name>accurate</name> @@ -691,6 +706,82 @@ </GUI> </step> <step> + <name>growth brand per year</name> + <type>ExecSQL</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik (localhost)</connection> + <execute_each_row>N</execute_each_row> + <single_statement>N</single_statement> + <replace_variables>N</replace_variables> + <quoteString>N</quoteString> + <sql>refresh materialized view mv_brand_per_year</sql> + <set_params>N</set_params> + <insert_field/> + <update_field/> + <delete_field/> + <read_field/> + <arguments> + </arguments> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>720</xloc> + <yloc>304</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> + <name>growth category brand per year</name> + <type>ExecSQL</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik (localhost)</connection> + <execute_each_row>N</execute_each_row> + <single_statement>N</single_statement> + <replace_variables>N</replace_variables> + <quoteString>N</quoteString> + <sql>refresh materialized view mv_category_brand_per_year</sql> + <set_params>N</set_params> + <insert_field/> + <update_field/> + <delete_field/> + <read_field/> + <arguments> + </arguments> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>560</xloc> + <yloc>304</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>growth existing customer</name> <type>ExecSQL</type> <description/> @@ -767,6 +858,44 @@ </GUI> </step> <step> + <name>invoice customer group by brand and year</name> + <type>ExecSQL</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik (localhost)</connection> + <execute_each_row>N</execute_each_row> + <single_statement>N</single_statement> + <replace_variables>N</replace_variables> + <quoteString>N</quoteString> + <sql>refresh materialized view mv_invoice_customer_group_brand_year</sql> + <set_params>N</set_params> + <insert_field/> + <update_field/> + <delete_field/> + <read_field/> + <arguments> + </arguments> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>944</xloc> + <yloc>304</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>salesperson</name> <type>ExecSQL</type> <description/> @@ -843,7 +972,7 @@ </GUI> </step> <step> - <name>invoice customer group by brand and year</name> + <name>sale order</name> <type>ExecSQL</type> <description/> <distribute>Y</distribute> @@ -858,7 +987,7 @@ <single_statement>N</single_statement> <replace_variables>N</replace_variables> <quoteString>N</quoteString> - <sql>refresh materialized view mv_invoice_customer_group_brand_year</sql> + <sql>refresh materialized view mv_sale_order</sql> <set_params>N</set_params> <insert_field/> <update_field/> @@ -875,13 +1004,13 @@ </output> </remotesteps> <GUI> - <xloc>944</xloc> + <xloc>400</xloc> <yloc>304</yloc> <draw>Y</draw> </GUI> </step> <step> - <name>growth brand per year</name> + <name>compare conversion rate brand</name> <type>ExecSQL</type> <description/> <distribute>Y</distribute> @@ -896,7 +1025,7 @@ <single_statement>N</single_statement> <replace_variables>N</replace_variables> <quoteString>N</quoteString> - <sql>refresh materialized view mv_brand_per_year</sql> + <sql>refresh materialized view mv_compare_conversion_rate_brand</sql> <set_params>N</set_params> <insert_field/> <update_field/> @@ -913,13 +1042,13 @@ </output> </remotesteps> <GUI> - <xloc>720</xloc> - <yloc>304</yloc> + <xloc>240</xloc> + <yloc>432</yloc> <draw>Y</draw> </GUI> </step> <step> - <name>growth category brand per year</name> + <name>sale order group</name> <type>ExecSQL</type> <description/> <distribute>Y</distribute> @@ -934,7 +1063,7 @@ <single_statement>N</single_statement> <replace_variables>N</replace_variables> <quoteString>N</quoteString> - <sql>refresh materialized view mv_category_brand_per_year</sql> + <sql>refresh materialized view mv_sale_order_group</sql> <set_params>N</set_params> <insert_field/> <update_field/> @@ -951,7 +1080,7 @@ </output> </remotesteps> <GUI> - <xloc>560</xloc> + <xloc>240</xloc> <yloc>304</yloc> <draw>Y</draw> </GUI> |