Configuration Keys
This table lists the Analysis Server configuration keys with its description, visibility status and default value.
Data Processing
All configuration keys related to ETL or database loading and processing.
Configuration Keys
| Keys | Default Value | Description |
|---|---|---|
| Root.Datawarehouse.ProcessConsumption | FALSE | Use this to process consumption data for Consumption Based Licensing Dashboard. |
| Root.Datawarehouse.ProcessCostCatalogLabel | FALSE | Use this to process the Application Cost catalog. |
| Root.Datawarehouse.ProcessStorageCostLabel | FALSE | Use this to process the Storage Cost catalog. |
| Root.Datawarehouse.ProcessUserDays | FALSE | Use this to process distinct users per day pr (User Days measure). |
| Root.Datawarehouse.ProcessWorkBreakEvent | FALSE | Use this to process the Work Break Event. |
| Root.Etl.AsCubePartition.Active | FALSE | Use this to enable the SQL OLAP cube partitioning during processing. |
| Root.Etl.ConcurrencyGroupMappingFile | C:\Program Files\OpeniT\Core\Configuration\user-to-groups.map | Use this to indicate the the location of the user-to-groups.map configuration file. |
| Root.Etl.CoreDatabasePath | C:\ProgramData\OpeniT\Data\database | Use this to indicate the location of the Core Server file database. |
| Root.Etl.DailyResolutionAge | 0 | Use this to indicate the value of the maximum age of the data to load. The default value 0 means all the data will be loaded. |
| Root.Etl.DbCleanUp.Active | FALSE | Use this to process Database Cleanup. |
| Root.Etl.FeatureLabeling | FALSE | Setting this to true adds a page that allows administrators to configure labels for feature field. |
| Root.Etl.FileStatusTable | [FileStatus] | Table that contains information on data that has been loaded. Currently not in use. |
| Root.Etl.FilterDeniedEventsOnly.Active | TRUE | Setting this to true will only display events with type Denied. |
| Root.Etl.LicenseMonitorCube.Active | TRUE | Setting this to true will use an on old version of the License Monitor Portal. |
| Root.Etl.LicenseMonitorCube.RoleBased | FALSE | Setting this to trues displays data on the License Monitor Portal based on the Roles Configuration, and differs from user to user. |
| Root.Etl.MapFileEncoding | UTF8 | Sets the encoding used by the mapping file to handle special characters, formatting and styles. |
| Root.Etl.NumberOfThreads | 0 | The indicated value determines the maximum number of parallel process for data loading during SyncDataType command and of tasks during ProcessOLAP. |
| Root.Etl.ProcessAs | TRUE | Setting this to true runs the ProcessOLAP command during RunETL command. |
| Root.Etl.ProcessSql | TRUE | Setting this to true runs the ProcessSQL command during RunETL command. |
| Root.Etl.SqlCommandTimeout | 600 | Use this to indicate the duration of SQL command query before it times out. |
| Root.Etl.SyncActiveDirectoryInfo | TRUE | Setting this to true includes processing of mapping files during RunETL command. |
| Root.Etl.SyncClientList | FALSE | Setting this to true includes processing of client list from Core Server database. |
| Root.Etl.SyncConcurrencyGroupMappingFile | FALSE | Setting this to true includes creating of user group mapping file based on the SQL database during RunETL. |
| Root.Etl.SyncCoreServerDatabase | TRUE | Setting this to true runs SyncDatabase command during RunETL command. |
| Root.Etl.SyncCostInformation | FALSE | Setting this to true includes processing of cost information from Core Server database. |
| Root.Etl.SyncRawOptionsFile | FALSE | Setting this to true includes processing of raw options file from Core Server database. |
| Root.Etl.UserAnonymization.Source | (blank) | Use this to indicate the value of the field used as the basis of anonymization. |
| Root.Etl.UserAnonymization.SourceValue | (blank) | Use this to indicate the value of the actual field value used as the basis of anonymization. |
| Root.Etl.VendorLicenseLabeling | FALSE | Setting this to true adds a page that allows administrators to configure labels for Vendor License field. |
Data Processing Configuration Keys
Default Number of Threads
We set the default number of threads to the number of utilized cores (CPU) of the SQL Server. 0 = number of utilized cores
If the Configuration Key (NumberOFThreads) is set to an exact number, it will use the provided value.
Datatypes
All configuration keys related to activation of Core Server datatypes.
Configuration Keys
| Keys | Default Value | Description |
|---|---|---|
| Root.Etl.Datatypes.2.Active | TRUE | Use this to load data type 2 in the database, SQL only. |
| Root.Etl.Datatypes.24.Active | TRUE | Use this to load data type 24 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.29.Active | TRUE | Use this to load data type 29 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.49.Active | FALSE | Use this to load data type 49 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.56.Active | FALSE | Use this to load data type 56 in the database, SQL only. |
| Root.Etl.Datatypes.57.Active | FALSE | Use this to load data type 57 in the database, SQL only. |
| Root.Etl.Datatypes.58.Active | FALSE | Use this to load data type 58 in the database, SQL only. |
| Root.Etl.Datatypes.70.Active | TRUE | Use this to load data type 70 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.75.Active | TRUE | Use this to load data type 75 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.78.Active | TRUE | Use this to load data type 78 in the database, SQL only. |
| Root.Etl.Datatypes.87.Active | TRUE | Use this to load data type 87 in the database, SQL only. |
| Root.Etl.Datatypes.89.Active | TRUE | Use this to load data type 89 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.90.Active | TRUE | Use this to load data type 90 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.91.Active | TRUE | Use this to load data type 91 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.92.Active | TRUE | Use this to load data type 92 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.93.Active | TRUE | Use this to load data type 93 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.94.Active | TRUE | Use this to load data type 94 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.95.Active | TRUE | Use this to load data type 95 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.97.Active | TRUE | Use this to load data type 97 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.98.Active | TRUE | Use this to load data type 98 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.99.Active | TRUE | Use this to load data type 99 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.102.Active | TRUE | Use this to load data type 102 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.103.Active | TRUE | Use this to load data type 103 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.104.Active | TRUE | Use this to load data type 104 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.107.Active | TRUE | Use this to load data type 107 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.108.Active | TRUE | Use this to load data type 108 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.109.Active | TRUE | Use this to load data type 109 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.115.Active | TRUE | Use this to load data type 115 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.117.Active | TRUE | Use this to load data type 117 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.118.Active | TRUE | Use this to load data type 118 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.119.Active | TRUE | Use this to load data type 119 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.120.Active | TRUE | Use this to load data type 120 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.121.Active | TRUE | Use this to load data type 120 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.122.Active | TRUE | Use this to load data type 122 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.123.Active | TRUE | Use this to load data type 123 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.124.Active | TRUE | Use this to load data type 124 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.125.Active | TRUE | Use this to load data type 125 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.126.Active | TRUE | Use this to load data type 126 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.127.Active | TRUE | Use this to load data type 127 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.128.Active | TRUE | Use this to load data type 128 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.129.Active | FALSE | Use this to load data type 129 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.130.Active | FALSE | Use this to load data type 130 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.131.Active | FALSE | Use this to load data type 131 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.132.Active | FALSE | Use this to load data type 132 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.133.Active | FALSE | Use this to load data type 133 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.134.Active | FALSE | Use this to load data type 134 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.135.Active | FALSE | Use this to load data type 135 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.136.Active | FALSE | Use this to load data type 136 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.137.Active | TRUE | Use this to load data type 137 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.138.Active | TRUE | Use this to load data type 138 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.139.Active | TRUE | Use this to load data type 139 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.140.Active | TRUE | Use this to load data type 139 in the database, SQL, and OLAP. |
| Root.Etl.Datatypes.1003.Active | TRUE | Use this to load data type 1003 in the database, SQL, and OLAP. |
Datatypes Configuration Keys
Web Components
All related configuration keys to enabling of specific web interface component.
Configuration Keys
| Keys | Default Value | Description |
|---|---|---|
| Root.Etl.AdminPortalUri | (blank) | A valid URL of Open iT Admin Portal used for API connection. |
| Root.Etl.OpeniTLicensePath | C:\Program Files\OpeniT\Core\Configuration\license | Use this to indicate the path where the Open iT license file is found. |
| Root.Level | Level1 | Use this to indicate the level of Open iT used. |
| Root.LicenseMonitor.Restricted | FALSE | Setting this to true limits License Monitor Portal access to users based on their role and how it is configured under the Roles Configuration page. |
| Root.LicenseMonitorTokenInfo.Enabled | FALSE | Setting this to true displays the token info, such as token cost, in the License Monitor Portal. It also entails that the computation for Max available and Max in use values depends on the token info in the license status. |
| Root.SamImport.Active | FALSE | Setting this to true adds a page for SAM Import. |
| Root.SamImport.Administrators | (blank) | Used for SAM Import page. |
| Root.SamImport.UploadDirectory | C:\Program Files\OpeniT\Analysis Server\Uploads | Used for SAM Import page. |
| Root.UsageRight.ExternalSCCMServer | FALSE | Configurations for setting up SCCM as data source if available. |
| Root.UsageRight.SCCMDatabaseName | (blak) | Configurations for setting up SCCM as data source if available. |
| Root.UsageRight.SCCMServer | (blank) | Configurations for setting up SCCM as data source if available. |
| Root.Web.CopyrightBanner | FALSE | Setting this to true adds a security banner. |
| Root.Web.HomePage | (blank) | Use this to indicate the URL of the landing page of the Analysis Server. |
| Root.Web.LicenseExpiration.DisplayTime | FALSE | Setting this to true will display the time part of the License Expiration Expiry date. |
| Root.Web.LicenseExpiration.ExpiredDays | 30 | Default value for expired days in License Expiration page filer. |
| Root.Web.LicenseExpiration.MaxAge | 90 | Default value for the maximum age in License Expiration page filter. |
| Root.Web.LicenseExpiration.View | Valid | Default selected view for the License Expiration page. It selects all Valid licenses. |
| Root.Web.LicenseExpiration.WarningDays | 30 | Default value for warning days in License Expiration page filter. |
| Root.Web.LicenseMetaData | FALSE | Setting this to true adds a page used to add metadata to the license information. |
| Root.Web.LicensePlanner | FALSE | Use this to enable the Contract Management tab. |
| Root.Web.LMP.AutoReload | FALSE | If set to true, the License Monitor Portal Page will utilize auto reload. |
| Root.Web.LMP.FeatureAggregation | Max | Use this to indicate the aggregation used in License Monitor Portal display. |
| Root.Web.LMP.IntervalStartsAt | 20000 | When to start the automatic reload in License Monitor Portal. The value is in milliseconds (ms). (e.g., If set in 20000, the automatic reload will start at 5 minutes and 20 seconds.) |
| Root.Web.LMP.Level2UsagePercentage | TRUE | If set to true, the License Monitor Portal, when in Level 2, will display data in percentage. |
| Root.Web.LMP.ServerSidePagination | FALSE | If set to true, the License Monitor Portal will use server side pagination. |
| Root.Web.LMP.UseFeatureVersion | FALSE | If set to true, Feature Version is shown in License Monitor Portal. |
| Root.Web.OlapHttpAccess | (blank) | Use this to indicate the URL of a configured MSMDPUMP, an alternative to directly accessing the cube. |
| Root.Web.ReportingServerUri | (blank) | Use this to indicate the Reporting Server URL. If not blank, the Reporting Server's License and Status Monitor are displayed on the Dashboard tab. |
| Root.Web.ShowPackage | FALSE | If set to true, Package is shown in Dashboard and License Monitor Portal. |
| Root.Web.SSRS2016ReportBuilderDownloadLink | https://www.microsoft.com/en-us/download/details.aspx?id=53613 | Use this to indicate the URI used to download the SSRS Report Builder. |
Web Components Configuration Keys