From 36033010877afc62a8394a8c4b72ec3a91bf0570 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Thu, 10 Jul 2025 20:28:01 +0700
Subject: delete useless step

---
 refresh_materialized_view.ktr | 149 +++---------------------------------------
 1 file changed, 10 insertions(+), 139 deletions(-)

(limited to 'refresh_materialized_view.ktr')

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
@@ -502,16 +502,6 @@
       <to>salesperson</to>
       <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>
@@ -527,21 +517,6 @@
       <to>invoice customer group by brand and year</to>
       <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>
@@ -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>
@@ -763,120 +748,6 @@
       <draw>Y</draw>
     </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>
-- 
cgit v1.2.3