analytics/configuration/xqeodp.config.xml-example

<?xml version="1.0" encoding="UTF-8"?>
<!--
	Licensed Materials - Property of IBM
	IBM Cognos Products: XQEODP
	(C) Copyright IBM Corp. 2009, 2020
    US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM corp.
-->
<XQEODPConfiguration version="1.0">
	<!-- Reload flag and polling interval for configuration file -->
	<reload enabled="true" refreshInterval="5000"/>
	<components>
		<!-- SAP BW data provider -->
		<component name="SBWODP">
			<!-- Detect whether Variable Uniqueness is required for models that have multiple variables with the same name.-->
			<detectSAPVariableUniqueness value="true"/>
			<!-- Check or ignore SAP return status - default value is true (check return status) -->
			<checkReturnCode value="true"/>
			<!-- Reset SAP Server-side Cache -->
			<!-- Valid values are: 0 (off), 1 (reset metadata cache) or 2 (reset user cache) -->
			<!-- default value is 0 (do not reset cache) -->
			<serverCacheReset value="0"/>
			<!-- Convert password to upper case before passing to SAP - default value is false (do not change password case) -->
			<uppercasePwd value="false"/>
			<!-- Use alternate RSZ_X_VALUES_GET BAPI to get Member metadata - default value is true (use RSZ_X_VALUES_GET BAPI) -->
			<!-- The element can also contain a comma separated list of Dimension unique names for Dimensions that should use RSZ_X_VALUES_GET to retrieve Member metadata. -->
			<!-- If this list is empty, the RSZ_X_VALUES_GET is used to get Member metadata from all Dimensions. -->
			<useFastGetMembers value="true"/>
			<!-- Name of Property to use as the caption for Member metadata.  Valid values are: Name, Key, LongName, Description or Caption - default value is Caption -->
			<displayProperty value="Caption"/>
			<!-- Use MDX to retrieve Members for specific InfoObjects (Dimensions, Hierarchies or Members). Value is a comma delimited list of InfoObject Names.  Default value is an empty List-->
			<useMDXToRetrieveMembersFor/>
			<!-- if dimension cardinality is less than specified number and it is default hierarchy, use MDX to retrieve the members.  Default value is 10,000 -->
			<useMDXToRetrieveMembersLimit value="500"/>
			<!-- Turn RFC Trace logging on or off - default value is false (RFC Trace logging off) -->
			<!-- Note that this is low-level tracing for the SAP RFC library - NOT the BAPI Trace! -->
			<traceRFC value="false"/>
			<!-- Maximum number of rows to include in an SAP Table dump - default value is 50 -->
			<maxTableDumpRows value="50"/>
			<!-- List of dims that use replacement variables.Value is a comma delimited list of I[cube].[DUN].  Default value is an empty List-->
			<useReplacementVariablesFor/>
			<!-- Maximum number of loaded time ranges of a hierarchy structure. -->
			<maxTDSRanges value="16"/>
			<!-- Load time ranges for hierarchies with up to this cardinality. -->
			<maxTDSCard value="1000000"/>
			<!-- List of SAP extended languages supported on the BW server.  Default value is an empty List
			 	 E.g. French Canadian is an SAP extended language with a code of 3F in order for IBM Cognos to support this language the following parameter
			 	 must include the 2 digit language code 3F AND the Content Language/Run locale must be French (Canada)/fr-ca.
			 	 NB. This is only supported by the new SNWODP XQEODP provider and has to use code page 4103 UTF16 LE (this is a shared configuration file).     
			 -->
			<extendedLanguages/>
		</component>
		<!-- MSAS 2005 via OLEDB. -->
		<component name="MSAnalysis2005ODP">
			<!-- MSAS Connect Timeout.  Must be between 30 and 180 seconds, inclusive. -->
			<!--connectionTimeout value="30"/-->
			<!-- MSAS Generic Timeout.  Must be at least 0. Value is in seconds. -->
			<!--genericTimeout value="30"/-->
			<!-- MSAS Command Timeout.  0 means no timeout.  -1 means it won't be set and will use the MSAS default.  Value is in seconds.  Default is -1. -->
			<!--commandTimeout value="-1"/-->
			<!-- MSAS Maximum length of string data.  Value is in bytes.  Default and minimum values are 1024. -->
			<!--defaultMaxStringLength value="1024"/-->
			<!-- Name of the application to be used when SQL Server Tracing is used.  By default it is not set. -->
			<applicationName value="IBM XQEODP"/>
		</component>
		<!-- MSAS 2008 via OLEDB. -->
		<component name="MSAnalysis2008ODP">
			<!-- MSAS Connect Timeout.  Must be between 30 and 180 seconds, inclusive. -->
			<!--connectionTimeout value="30"/-->
			<!-- MSAS Generic Timeout.  Must be at least 0. Value is in seconds. -->
			<!--genericTimeout value="30"/-->
			<!-- MSAS Command Timeout.  0 means no timeout.  -1 means it won't be set and will use the MSAS default.  Value is in seconds.  Default is -1. -->
			<!--commandTimeout value="-1"/-->
			<!-- MSAS Maximum length of string data.  Value is in bytes.  Default and minimum values are 1024. -->
			<!--defaultMaxStringLength value="1024"/-->
			<!-- Name of the application to be used when SQL Server Tracing is used.  By default it is not set. -->
			<applicationName value="IBM XQEODP"/>
		</component>
		<component name="MSAnalysis2012ODP">
			<!-- MSAS Connect Timeout.  Must be between 30 and 180 seconds, inclusive. -->
			<!--connectionTimeout value="30"/-->
			<!-- MSAS Generic Timeout.  Must be at least 0. Value is in seconds. -->
			<!--genericTimeout value="30"/-->
			<!-- MSAS Command Timeout.  0 means no timeout.  -1 means it won't be set and will use the MSAS default.  Value is in seconds.  Default is -1. -->
			<!--commandTimeout value="-1"/-->
			<!-- MSAS Maximum length of string data.  Value is in bytes.  Default and minimum values are 1024. -->
			<!--defaultMaxStringLength value="1024"/-->
			<!-- Name of the application to be used when SQL Server Tracing is used.  By default it is not set. -->
			<applicationName value="IBM XQEODP"/>
		</component>
		<component name="MSAnalysis2014ODP">
			<!-- MSAS Connect Timeout.  Must be between 30 and 180 seconds, inclusive. -->
			<!--connectionTimeout value="30"/-->
			<!-- MSAS Generic Timeout.  Must be at least 0. Value is in seconds. -->
			<!--genericTimeout value="30"/-->
			<!-- MSAS Command Timeout.  0 means no timeout.  -1 means it won't be set and will use the MSAS default.  Value is in seconds.  Default is -1. -->
			<!--commandTimeout value="-1"/-->
			<!-- MSAS Maximum length of string data.  Value is in bytes.  Default and minimum values are 1024. -->
			<!--defaultMaxStringLength value="1024"/-->
			<!-- Name of the application to be used when SQL Server Tracing is used.  By default it is not set. -->
			<applicationName value="IBM XQEODP"/>
		</component>
		<component name="MSAnalysis2016ODP">
			<!-- MSAS Connect Timeout.  Must be between 30 and 180 seconds, inclusive. -->
			<!--connectionTimeout value="30"/-->
			<!-- MSAS Generic Timeout.  Must be at least 0. Value is in seconds. -->
			<!--genericTimeout value="30"/-->
			<!-- MSAS Command Timeout.  0 means no timeout.  -1 means it won't be set and will use the MSAS default.  Value is in seconds.  Default is -1. -->
			<!--commandTimeout value="-1"/-->
			<!-- MSAS Maximum length of string data.  Value is in bytes.  Default and minimum values are 1024. -->
			<!--defaultMaxStringLength value="1024"/-->
			<!-- Name of the application to be used when SQL Server Tracing is used.  By default it is not set. -->
			<applicationName value="IBM XQEODP"/>
		</component>
		<component name="MSAnalysis2017ODP">
			<!-- MSAS Connect Timeout.  Must be between 30 and 180 seconds, inclusive. -->
			<!--connectionTimeout value="30"/-->
			<!-- MSAS Generic Timeout.  Must be at least 0. Value is in seconds. -->
			<!--genericTimeout value="30"/-->
			<!-- MSAS Command Timeout.  0 means no timeout.  -1 means it won't be set and will use the MSAS default.  Value is in seconds.  Default is -1. -->
			<!--commandTimeout value="-1"/-->
			<!-- MSAS Maximum length of string data.  Value is in bytes.  Default and minimum values are 1024. -->
			<!--defaultMaxStringLength value="1024"/-->
			<!-- Name of the application to be used when SQL Server Tracing is used.  By default it is not set. -->
			<applicationName value="IBM XQEODP"/>
		</component>
		<component name="MSAnalysis2019ODP">
			<!-- MSAS Connect Timeout.  Must be between 30 and 180 seconds, inclusive. -->
			<!--connectionTimeout value="30"/-->
			<!-- MSAS Generic Timeout.  Must be at least 0. Value is in seconds. -->
			<!--genericTimeout value="30"/-->
			<!-- MSAS Command Timeout.  0 means no timeout.  -1 means it won't be set and will use the MSAS default.  Value is in seconds.  Default is -1. -->
			<!--commandTimeout value="-1"/-->
			<!-- MSAS Maximum length of string data.  Value is in bytes.  Default and minimum values are 1024. -->
			<!--defaultMaxStringLength value="1024"/-->
			<!-- Name of the application to be used when SQL Server Tracing is used.  By default it is not set. -->
			<applicationName value="IBM XQEODP"/>
		</component>
		<component name="MSAzureODP">
			<!-- MSAS Connect Timeout.  Must be between 30 and 180 seconds, inclusive. -->
			<!--connectionTimeout value="30"/-->
			<!-- MSAS Generic Timeout.  Must be at least 0. Value is in seconds. -->
			<!--genericTimeout value="30"/-->
			<!-- MSAS Command Timeout.  0 means no timeout.  -1 means it won't be set and will use the MSAS default.  Value is in seconds.  Default is -1. -->
			<!--commandTimeout value="-1"/-->
			<!-- MSAS Maximum length of string data.  Value is in bytes.  Default and minimum values are 1024. -->
			<!--defaultMaxStringLength value="1024"/-->
			<!-- Name of the application to be used when SQL Server Tracing is used.  By default it is not set. -->
			<applicationName value="IBM XQEODP"/>
		</component>
		<!-- Cubing Services via XMLA. -->
		<component name="DB2CSXMLA">
		</component>
		<!-- Configuration for PowerCubeODP -->
		<component name="PowerCubeODPXQE">
			<!-- enableNamespaceFiltering. Set to true to filter namespace based on data source connection configuration. Default is false. -->
			<enableNamespaceFiltering value="false"/>
		</component>
		<!-- Configuration for NGTM1ODP -->
		<component name="NGTM1ODP">
		</component>
		<!-- Configuration for TM1REST provider -->
		<component name="TM1REST">
		</component>
		<!-- Essbase data provider -->
		<component name="EssbaseODP">
			<!-- enableMemberRollupDetecting. Set to true to detect member rollup. Default is false. -->
			<enableMemberRollupDetecting value="false"/>
		</component>
	</components>
</XQEODPConfiguration>