KB329106: Ports used by MicroStrategy Services in MicroStrategy Secure Enterprise 10.x

• Strategy

OVERVIEW
Below is a list of some services that are installed with Strategy 10.x and their respective port numbers:
Refer to the following Strategy Knowledge Base document for details on ports used by other Strategy products:

KB34971: What TCP/IP ports are used by the MicroStrategy Product Suite?

Custom group that displays Top 10 Customers and Bottom 5 Items EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom. [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL <PROPERTYSET NAME="System SQL Templates"> <PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" /> <PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" /> <PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/> <PROPERTY NAME="CatalogCacheMode" VALUE="3" /> <PROPERTY NAME="CatalogRetrievalMode" VALUE="0" /> <PROPERTY NAME="SupportsKerberos" VALUE="1"/> </PROPERTYSET> <PROPERTYSET NAME="System SQL Templates"> <PROPERTY NAME="CatalogCacheMode" VALUE="3" /> <PROPERTY NAME="CatalogRetrievalMode" VALUE="2" /> </PROPERTYSET> SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Service NameProcess NamePortConfigurable?Strategy Intelligence Server	Custom group that displays Top 10 Customers and Bottom 5 Items EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom. [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL <PROPERTYSET NAME="System SQL Templates"> <PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" /> <PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" /> <PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/> <PROPERTY NAME="CatalogCacheMode" VALUE="3" /> <PROPERTY NAME="CatalogRetrievalMode" VALUE="0" /> <PROPERTY NAME="SupportsKerberos" VALUE="1"/> </PROPERTYSET> <PROPERTYSET NAME="System SQL Templates"> <PROPERTY NAME="CatalogCacheMode" VALUE="3" /> <PROPERTY NAME="CatalogRetrievalMode" VALUE="2" /> </PROPERTYSET> SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Service NameProcess NamePortConfigurable?Strategy Intelligence Server	Custom group that displays Top 10 Customers and Bottom 5 Items EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom. [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL <PROPERTYSET NAME="System SQL Templates"> <PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" /> <PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" /> <PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/> <PROPERTY NAME="CatalogCacheMode" VALUE="3" /> <PROPERTY NAME="CatalogRetrievalMode" VALUE="0" /> <PROPERTY NAME="SupportsKerberos" VALUE="1"/> </PROPERTYSET> <PROPERTYSET NAME="System SQL Templates"> <PROPERTY NAME="CatalogCacheMode" VALUE="3" /> <PROPERTY NAME="CatalogRetrievalMode" VALUE="2" /> </PROPERTYSET> SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Service NameProcess NamePortConfigurable?Strategy Intelligence Server	Custom group that displays Top 10 Customers and Bottom 5 Items EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom. [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL <PROPERTYSET NAME="System SQL Templates"> <PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" /> <PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" /> <PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/> <PROPERTY NAME="CatalogCacheMode" VALUE="3" /> <PROPERTY NAME="CatalogRetrievalMode" VALUE="0" /> <PROPERTY NAME="SupportsKerberos" VALUE="1"/> </PROPERTYSET> <PROPERTYSET NAME="System SQL Templates"> <PROPERTY NAME="CatalogCacheMode" VALUE="3" /> <PROPERTY NAME="CatalogRetrievalMode" VALUE="2" /> </PROPERTYSET> SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Service NameProcess NamePortConfigurable?Strategy Intelligence Server
Custom group that displays Top 10 Customers and Bottom 5 Items EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom. [MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName= MySparkDSN=MicroStrategy ODBC Driver for Apache Spark SQL <PROPERTYSET NAME="System SQL Templates"> <PROPERTY NAME="CatalogTableSQL" VALUE="SHOW TABLES" /> <PROPERTY NAME="CatalogColumnSQL" VALUE="DESCRIBE #TABLE_LIST#" /> <PROPERTY NAME="TempTableDropSQL" VALUE="DROP TABLE #T#"/> <PROPERTY NAME="CatalogCacheMode" VALUE="3" /> <PROPERTY NAME="CatalogRetrievalMode" VALUE="0" /> <PROPERTY NAME="SupportsKerberos" VALUE="1"/> </PROPERTYSET> <PROPERTYSET NAME="System SQL Templates"> <PROPERTY NAME="CatalogCacheMode" VALUE="3" /> <PROPERTY NAME="CatalogRetrievalMode" VALUE="2" /> </PROPERTYSET> SettingValueReasonIntermediate Table Type:PermanentTable-creation-modifying VLDB properties (most settings under the Tables menu) are ignored when 'True Temporary Tables' are chosen.Table Qualifier:GLOBAL TEMPORARYThis instructs Oracle to create global temporary tables.Table Space:ON COMMIT PRESERVE ROWSThis instructs Oracle not to delete the data after a transaction committed. If this is not specified Oracle assumes the 'ON COMMIT DELETE ROWS' option.Drop Temp Table Method:Do NothingGlobal temporary tables cannot be dropped within the session that created them. A batch-query run at the end of the day is recommended to delete all the temporary table structures.Table Creation Type:ExplicitGlobal temporary tables can only be created using explicit table creation.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTGlobal temporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Insert Pre Statement x(Pre/Post Statements folder)CREATE INDEX I_??? ON ??? (!!!)Global temporary tables may be indexed, It is up to the system administrator to choose the best indexing options. The '???' wildcard will be replaced by the table name and the '!!!' wildcard will be replaced by the tables' keys.SettingValueReasonIntermediate Table TypeTrue Temporary TableThis is the default setting for Oracle, the NOLOGGING option and the implicit table creation setting will be applied automatically.Table Post Statement x(Pre/Post Statements folder)ANALYZE TABLE ??? ESTIMATE STATISTICS SAMPLE 25 PERCENTTemporary tables may be analyzed, which is important for Oracle Cost Based Optimization (CBO). It is up to the system administrator to choose the best analyzing options.Service NameProcess NamePortConfigurable?Strategy Intelligence Server	Windows : MSTRSvr2_64.exe Linux / UNIX: MSTRSvr 34952YesMessaging Service (Apache Zookeeper) installed with Intelligence Server since Strategy version 10.5)	Linux / UNIX: MSTRSvr 34952YesMessaging Service (Apache Zookeeper) installed with Intelligence Server since Strategy version 10.5)	Linux / UNIX: MSTRSvr 34952YesMessaging Service (Apache Zookeeper) installed with Intelligence Server since Strategy version 10.5)
Linux / UNIX: MSTRSvr 34952YesMessaging Service (Apache Zookeeper) installed with Intelligence Server since Strategy version 10.5)	Windows: java.exe Linux / UNIX: java 2181 NoMessaging Service (Apache Kafka) (installed with Intelligence Server since Strategy version 10.5)	Linux / UNIX: java 2181 NoMessaging Service (Apache Kafka) (installed with Intelligence Server since Strategy version 10.5)	Linux / UNIX: java 2181 NoMessaging Service (Apache Kafka) (installed with Intelligence Server since Strategy version 10.5)
Linux / UNIX: java 2181 NoMessaging Service (Apache Kafka) (installed with Intelligence Server since Strategy version 10.5)	Windows: java.exe Linux / UNIX: java 9092 NoData Wrangler (installed with Intelligence Server since Strategy version 10.0)	Linux / UNIX: java 9092 NoData Wrangler (installed with Intelligence Server since Strategy version 10.0)	Linux / UNIX: java 9092 NoData Wrangler (installed with Intelligence Server since Strategy version 10.0)
Linux / UNIX: java 9092 NoData Wrangler (installed with Intelligence Server since Strategy version 10.0)	Windows: M8RefSvr_64.exe Linux / UNIX: MJRefSvr 3333 NoStrategy PDF Export Service (in Strategy version 10.6 and later)	Linux / UNIX: MJRefSvr 3333 NoStrategy PDF Export Service (in Strategy version 10.6 and later)	Linux / UNIX: MJRefSvr 3333 NoStrategy PDF Export Service (in Strategy version 10.6 and later)
Linux / UNIX: MJRefSvr 3333 NoStrategy PDF Export Service (in Strategy version 10.6 and later)	Windows: nssm Linux / UNIX: -- 20100 NoHadoop Gateway Manager (installed with Intelligence Server since 10.6 and later)	Linux / UNIX: -- 20100 NoHadoop Gateway Manager (installed with Intelligence Server since 10.6 and later)	Linux / UNIX: -- 20100 NoHadoop Gateway Manager (installed with Intelligence Server since 10.6 and later)
Linux / UNIX: -- 20100 NoHadoop Gateway Manager (installed with Intelligence Server since 10.6 and later)	Windows: MJHGoSMgr_64.exe Linux / UNIX: MJHGoSMgr 5688 NoHealth Agent	Linux / UNIX: MJHGoSMgr 5688 NoHealth Agent	Linux / UNIX: MJHGoSMgr 5688 NoHealth Agent
Linux / UNIX: MJHGoSMgr 5688 NoHealth Agent	Windows: MSTRExec.exe Linux / UNIX: MSTRExec 44440 YesListener Service	Linux / UNIX: MSTRExec 44440 YesListener Service	Linux / UNIX: MSTRExec 44440 YesListener Service
Linux / UNIX: MSTRExec 44440 YesListener Service	Windows: MSTRLsn2_64.exe Linux / UNIX: MSTRLsn 30172 No Enterprise Manager Data Loader	Linux / UNIX: MSTRLsn 30172 No Enterprise Manager Data Loader	Linux / UNIX: MSTRLsn 30172 No Enterprise Manager Data Loader
Linux / UNIX: MSTRLsn 30172 No Enterprise Manager Data Loader	Windows: MSTREMService.exe Linux / UNIX: MSTREMService 9999 Yes	Linux / UNIX: MSTREMService 9999 Yes	Linux / UNIX: MSTREMService 9999 Yes

Comment

0 comments

Details

Knowledge Article

Published:

July 17, 2017

Last Updated:

July 31, 2017

[MySparkDSN] Driver=/var/opt/MicroStrategy/install/lib/MYsparkXX.so Description=MicroStrategy ODBC Driver for Apache Spark SQL ApplicationUsingThreads=1 ArraySize=16384 AuthenticationMethod=0 CryptoProtocolVersion= CryptoLibName= Database=default DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EncryptionMethod= GSSClient=/lib64/libgssapi_krb5.so.2.2 HostName= HostNameInCertificate= IANAAppCodePage= KeepAlive=0 KeyPassword= Keystore= KeystorePassword= LoginTimeout=15 LogonID= MaxStringSize=4000 MinLongVarcharSize= PortNumber=10000 PRNGSeedFile= PRNGSeedSource= ProxyUser= RemoveColumnQualifiers=0 ServicePrincipalName= SSLLibName=