This section shows the step by step configuration of the keys related to activation of Core Server data types.
Go to the Configuration page of Analysis Server web interface.
Navigating to the Configuration Page
Locate the corresponding key to the data type you want to activate (e.g., If you will activate data type 58, find Root.Etl.Datatypes.58.Active), click it, then set its value to true.
Learn more about the corresponding keys and default values for each data type in the Data Types Configuration Keys table.
Data Types Configuration Keys
Keys
Default Value
Description
Root.Etl.Datatypes.2.Active
TRUE
Setting this to true loads data type 2 in the SQL database.
Root.Etl.Datatypes.24.Active
TRUE
Setting this to true loads data type 24 in the SQL and OLAP databases.
Root.Etl.Datatypes.29.Active
TRUE
Setting this to true loads data type 29 in the SQL and OLAP databases.
Root.Etl.Datatypes.49.Active
FALSE
Setting this to true loads data type 49 in the SQL and OLAP databases.
Root.Etl.Datatypes.56.Active
FALSE
Setting this to true loads data type 56 in the SQL database.
Root.Etl.Datatypes.57.Active
FALSE
Setting this to true loads data type 57 in the SQL database.
Root.Etl.Datatypes.58.Active
FALSE
Setting this to true loads data type 58 in the SQL database.
Root.Etl.Datatypes.70.Active
TRUE
Setting this to true loads data type 70 in the SQL and OLAP databases.
Root.Etl.Datatypes.75.Active
TRUE
Setting this to true loads data type 75 in the SQL and OLAP databases.
Root.Etl.Datatypes.78.Active
TRUE
Setting this to true loads data type 78 in the SQL database.
Root.Etl.Datatypes.87.Active
TRUE
Setting this to true loads data type 87 in the SQL database.
Root.Etl.Datatypes.89.Active
TRUE
Setting this to true loads data type 89 in the SQL and OLAP databases.
Root.Etl.Datatypes.90.Active
TRUE
Setting this to true loads data type 90 in the SQL and OLAP databases.
Root.Etl.Datatypes.91.Active
TRUE
Setting this to true loads data type 91 in the SQL and OLAP databases.
Root.Etl.Datatypes.92.Active
TRUE
Setting this to true loads data type 92 in the SQL and OLAP databases.
Root.Etl.Datatypes.93.Active
TRUE
Setting this to true loads data type 93 in the SQL and OLAP databases.
Root.Etl.Datatypes.94.Active
TRUE
Setting this to true loads data type 94 in the SQL and OLAP databases.
Root.Etl.Datatypes.95.Active
TRUE
Setting this to true loads data type 95 in the SQL and OLAP databases.
Root.Etl.Datatypes.97.Active
TRUE
Setting this to true loads data type 97 in the SQL and OLAP databases.
Root.Etl.Datatypes.98.Active
TRUE
Setting this to true loads data type 98 in the SQL and OLAP databases.
Root.Etl.Datatypes.99.Active
TRUE
Setting this to true loads data type 99 in the SQL and OLAP databases.
Root.Etl.Datatypes.102.Active
TRUE
Setting this to true loads data type 102 in the SQL and OLAP databases.
Root.Etl.Datatypes.103.Active
TRUE
Setting this to true loads data type 103 in the SQL and OLAP databases.
Root.Etl.Datatypes.104.Active
TRUE
Setting this to true loads data type 104 in the SQL and OLAP databases.
Root.Etl.Datatypes.107.Active
TRUE
Setting this to true loads data type 107 in the SQL and OLAP databases.
Root.Etl.Datatypes.108.Active
TRUE
Setting this to true loads data type 108 in the SQL and OLAP databases.
Root.Etl.Datatypes.109.Active
TRUE
Setting this to true loads data type 109 in the SQL and OLAP databases.
Root.Etl.Datatypes.115.Active
TRUE
Setting this to true loads data type 115 in the SQL and OLAP databases.
Root.Etl.Datatypes.117.Active
TRUE
Setting this to true loads data type 117 in the SQL and OLAP databases.
Root.Etl.Datatypes.118.Active
TRUE
Setting this to true loads data type 118 in the SQL and OLAP databases.
Root.Etl.Datatypes.119.Active
TRUE
Setting this to true loads data type 119 in the SQL and OLAP databases.
Root.Etl.Datatypes.120.Active
TRUE
Setting this to true loads data type 120 in the SQL and OLAP databases.
Root.Etl.Datatypes.121.Active
TRUE
Setting this to true loads data type 121 in the SQL and OLAP databases.
Root.Etl.Datatypes.122.Active
TRUE
Setting this to true loads data type 122 in the SQL and OLAP databases.
Root.Etl.Datatypes.123.Active
TRUE
Setting this to true loads data type 123 in the SQL and OLAP databases.
Root.Etl.Datatypes.124.Active
TRUE
Setting this to true loads data type 124 in the SQL and OLAP databases.
Root.Etl.Datatypes.125.Active
TRUE
Setting this to true loads data type 125 in the SQL and OLAP databases.
Root.Etl.Datatypes.126.Active
TRUE
Setting this to true loads data type 126 in the SQL and OLAP databases.
Root.Etl.Datatypes.127.Active
TRUE
Setting this to true loads data type 127 in the SQL and OLAP databases.
Root.Etl.Datatypes.128.Active
TRUE
Setting this to true loads data type 128 in the SQL and OLAP databases.
Root.Etl.Datatypes.129.Active
FALSE
Setting this to true loads data type 129 in the SQL and OLAP databases.
Root.Etl.Datatypes.130.Active
FALSE
Setting this to true loads data type 130 in the SQL and OLAP databases.
Root.Etl.Datatypes.131.Active
FALSE
Setting this to true loads data type 131 in the SQL and OLAP databases.
Root.Etl.Datatypes.132.Active
FALSE
Setting this to true loads data type 132 in the SQL and OLAP databases.
Root.Etl.Datatypes.133.Active
FALSE
Setting this to true loads data type 133 in the SQL and OLAP databases.
Root.Etl.Datatypes.134.Active
FALSE
Setting this to true loads data type 134 in the SQL and OLAP databases.
Root.Etl.Datatypes.135.Active
FALSE
Setting this to true loads data type 135 in the SQL and OLAP databases.
Root.Etl.Datatypes.136.Active
FALSE
Setting this to true loads data type 136 in the SQL and OLAP databases.
Root.Etl.Datatypes.137.Active
TRUE
Setting this to true loads data type 137 in the SQL and OLAP databases.
Root.Etl.Datatypes.138.Active
TRUE
Setting this to true loads data type 138 in the SQL and OLAP databases.
Root.Etl.Datatypes.139.Active
TRUE
Setting this to true loads data type 139 in the SQL and OLAP databases.
Root.Etl.Datatypes.140.Active
TRUE
Setting this to true loads data type 140 in the SQL and OLAP databases.
Root.Etl.Datatypes.143.Active
TRUE
Setting this to true loads data type 143 in the SQL and OLAP databases. Used for ServiceNow integration.
Root.Etl.Datatypes.144.Active
TRUE
Setting this to true loads data type 144 in the SQL and OLAP databases. Used for ServiceNow integration.
Root.Etl.Datatypes.145.Active
TRUE
Setting this to true loads data type 145 in the SQL and OLAP databases. Used for ServiceNow integration.
Root.Etl.Datatypes.1003.Active
TRUE
Setting this to true loads data type 1003 in the SQL and OLAP databases.
Data Types Configuration Keys
Click Save.
Activating Data Types
Click the Reset Session button at the bottom of the configuration table.
Navigating to the Configuration Page
Activating Data Types