delete useless step

1 files changed, 10 insertions, 139 deletions

diff --git a/refresh_materialized_view.ktr b/refresh_materialized_view.ktr
index 8add850..50742d7 100644
--- a/refresh_materialized_view.ktr
+++ b/refresh_materialized_view.ktr
@@ -503,16 +503,6 @@
       <enabled>Y</enabled>
     </hop>
     <hop>
-      <from>salesperson</from>
-      <to>customer_current_year</to>
-      <enabled>Y</enabled>
-    </hop>
-    <hop>
-      <from>customer_current_year</from>
-      <to>update quarter</to>
-      <enabled>Y</enabled>
-    </hop>
-    <hop>
       <from>update quarter</from>
       <to>growth existing customer</to>
       <enabled>Y</enabled>
@@ -528,21 +518,6 @@
       <enabled>Y</enabled>
     </hop>
     <hop>
-      <from>invoice customer group by brand and year</from>
-      <to>growth brand per year</to>
-      <enabled>Y</enabled>
-    </hop>
-    <hop>
-      <from>growth brand per year</from>
-      <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>
@@ -572,6 +547,16 @@
       <to>leadtime po to received</to>
       <enabled>Y</enabled>
     </hop>
+    <hop>
+      <from>invoice customer group by brand and year</from>
+      <to>sale order</to>
+      <enabled>Y</enabled>
+    </hop>
+    <hop>
+      <from>salesperson</from>
+      <to>update quarter</to>
+      <enabled>Y</enabled>
+    </hop>
   </order>
   <step>
     <name>accurate</name>
@@ -764,120 +749,6 @@
     </GUI>
   </step>
   <step>
-    <name>customer_current_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 dw_customer_current_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>880</xloc>
-      <yloc>160</yloc>
-      <draw>Y</draw>
-    </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>736</xloc>
-      <yloc>240</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/>