KB7850: How to model recursive hierarchies in MicroStrategy Engine

A table containing data that points to another row within the same table is said to have a recursive reference or to conform a recursive hierarchy.
 
A common structure is the following table:

 
In this table, the PARENT_ID column logically points to another row in the same table (ID column). The parent-child relationships go three levels deep. If this table is deconstructed into a tree structure, the tree looks like the following:

 
To model a schema such as this in Strategy, users must execute the steps outlined below:

1. Decompose the recursive hierarchy into several tables.
   The original table shown below:
   

   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5

   
    
   Becomes the following lookup and fact tables:
   
• Lookup tables:
2. LU_Level_1
   

   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5

   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5

   
    
   LU_Level_2
    
   

   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5

   
    
   LU_Level_3
    
   

   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5

   
   
• Fact tables:
3. FACT_LEVELS
   

   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5
   X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5	X Service NameDefault PortApache Kafka 9092Apache Tomcat 8.0 Tomcat8 8080Apache Tomcat 8.0 usherGW 9501Apache Tomcat 8.0 usherIDM  1443 & 2443Apache ZooKeeper 2181Apache2.4 443Memcached 11211MongoDB 27017MySQL 3306Redis 6379Strategy Collaboration/Realtime Service 3000Strategy Intelligence Server 34952Strategy PDFExport Service 20100Strategy REST Server 7070Strategy Usher Analytics Log Consumer Strategy Distribution Manager Strategy Enterprise Manager Data Loader Strategy Execution Engine Strategy Health Agent Strategy Listener Strategy Logging Client Strategy Logging Consumer Strategy Logging Server Strategy Master Health Agent Strategy MongoDB SQL Engine Strategy NC PDF Formatter Strategy SMTP Service Strategy System Monitor DayRevenueMovingRevenue1/1/20001501501/2/20001002501/3/20002004501/4/20001004001/5/2000250550VLDB CategoryVLDB Property SettingValue Select / InsertSQL Hint/*MSTRProject=!p;MSTRReport=!o;MSTRUser=!u;MSTRJob=!j;*/VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR=!o;Project=!p;User=!u;Job=!j;’Pre/Post StatementsClean-up Post statementreset query_group;VLDB CategoryVLDB Property SettingValue E.g.Pre/Post StatementsReport Pre Statementset query_group to ‘MSTR_High=!o;’Pre/Post StatementsClean-up Post statementreset query_group;PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5PARENT_IDIDSALESNULL112.51218.5136.5242.5251003633.33750.5L1_ID1L1_IDL2_ID1213L2_IDL3_ID24253637IDSALES112.5218.536.542.55100633.3750.5

   
    
   
4. Create the attributes in Strategy Developer:
    
   

   ID Form:   L1_ID from LU_Level_1   L1_ID from LU_Level_2 DESC Form: (only for display purposes)   ApplySimple("'ID: ' + cast(#0 as varchar (10))",[L1_ID] ) LU_Level_1 (child of L1) ID Form:   L2_ID from LU_Level_2   L2_ID from LU_Level_3 DESC Form: (only for display purposes)   ApplySimple("'ID: ' + cast(#0 as varchar (10))",[L2_ID] ) from LU_Level_2 (child of L2) ID Form:   L3_ID from LU_Level_3   ID from FACT_LEVELS DESC Form: (only for display purposes)   ApplySimple("'ID: ' + cast(#0 as varchar (10))",[L3_ID] ) from LU_Level_3

   ID Form:   L1_ID from LU_Level_1   L1_ID from LU_Level_2 DESC Form: (only for display purposes)   ApplySimple("'ID: ' + cast(#0 as varchar (10))",[L1_ID] ) LU_Level_1 (child of L1) ID Form:   L2_ID from LU_Level_2   L2_ID from LU_Level_3 DESC Form: (only for display purposes)   ApplySimple("'ID: ' + cast(#0 as varchar (10))",[L2_ID] ) from LU_Level_2 (child of L2) ID Form:   L3_ID from LU_Level_3   ID from FACT_LEVELS DESC Form: (only for display purposes)   ApplySimple("'ID: ' + cast(#0 as varchar (10))",[L3_ID] ) from LU_Level_3

   
    
   
5. Create the fact in Strategy Developer:
   Fact: [FLAT_SALES]
     SALES from FACT_LEVELS
    
   
6. Create the metric in Strategy Developer:
   Metric: [FLAT_SALES]  Sum([FLAT_SALES]) {~}
    
   
7. Three reports in Strategy Developer return the following results:

 
If the aggregation of lower levels (explained above) is not desired, please perform the following additional steps:

• Using Strategy Developer under:
  '//Schema Objects/Tables' rename the [FACT_LEVELS] table to [FACT_LEVELS (1)] 
  
   Create a table alias of the [FACT_LEVELS (1)] table for each one of the levels: 
  

• Name the aliases [FACT_LEVELS (2)] and [FACT_LEVELS (3)]. 
• Map the attributes to their corresponding fact table:
   
  

  ID Form:   L1_ID from LU_Level_1   L1_ID from LU_Level_2   ID from FACT_LEVELS(1) DESC Form: (only for display purposes)   ApplySimple("'ID: ' + cast(#0 as varchar (10))",[L1_ID] ) from LU_Level_1 (child of L1) ID Form:   L2_ID from LU_Level_2   L2_ID from LU_Level_3   ID from FACT_LEVELS(2) DESC Form: (only for display purposes)   ApplySimple("'ID: ' + cast(#0 as varchar (10))",[L2_ID] ) from LU_Level_2 (child of L2) ID Form:   L3_ID from LU_Level_3   ID from FACT_LEVELS(3) DESC Form: (only for display purposes)   ApplySimple("'ID: ' + cast(#0 as varchar (10))",[L3_ID] ) from LU_Level_3

  ID Form:   L1_ID from LU_Level_1   L1_ID from LU_Level_2   ID from FACT_LEVELS(1) DESC Form: (only for display purposes)   ApplySimple("'ID: ' + cast(#0 as varchar (10))",[L1_ID] ) from LU_Level_1 (child of L1) ID Form:   L2_ID from LU_Level_2   L2_ID from LU_Level_3   ID from FACT_LEVELS(2) DESC Form: (only for display purposes)   ApplySimple("'ID: ' + cast(#0 as varchar (10))",[L2_ID] ) from LU_Level_2 (child of L2) ID Form:   L3_ID from LU_Level_3   ID from FACT_LEVELS(3) DESC Form: (only for display purposes)   ApplySimple("'ID: ' + cast(#0 as varchar (10))",[L3_ID] ) from LU_Level_3

  
   
  
• Create the fact in Strategy Developer:
  Fact: [LEVELD_SALES]
        SALES from FACT_LEVELS(1)
        SALES from FACT_LEVELS(2)
        SALES from FACT_LEVELS(3)
   
  
• Create the metric in Strategy Developer:
  Metric: [LEVELED SALES] 
        Sum([LEVELED_SALES]) {~} 
   
  
• Three reports in Strategy Developer return the following results:

 
IMPORTANT NOTE: In the previous example, each level is NOT a child of itself. If needed, the lookup tables should be modified to reflect that, following the business model below:

• Lookup tables:

LU_Level_1

 
LU_Level_2
 

 
LU_Level_3
 

 
The same set of reports -- shown above -- returns the following data: