analytics/configuration/xqe.securecache.config.xml-example

<?xml version="1.0" encoding="UTF-8"?>
<!--
	Licensed Materials - Property of IBM
	IBM Cognos Products: XQEODP
	(C) Copyright IBM Corp. 2010, 2017
    US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM corp.
-->
<XQESecureCacheConfiguration version="1.0">
	<!-- Reload flag and polling interval for configuration file -->
	<datasources>
		<!--  SAP BW -->
		<datasource type="BW">
			<!-- Control the items used to provide the security context for metadata cache reuse and lolap cube reuse: -->
			<!-- 1: Always use UserIds 2: Always use Profiles 3: Use Profiles for metadata cache reuse and UserIds for lolap cube reuse -->
			<securityContextMode value="1"/>
			<!-- Cache-clearing interval in minutes. The value -1 is interpreted as meaning "no configured cache clearing". -->
			<clearCacheEveryXminutes X="1440"/>
			<!-- Controls the storage type for secure member cache -->
			<!-- 1: Static Cache. All the objects will be stored in memory (The other two parameters maxObjects and replaceExistingFiles need not be set.)-->
			<!-- 2: Dynamic Cache. Creates a disk backed cache. Hold maxObjects in memory, the rest will be cached on disk.-->
				<!--maxObjects: maximum number of metadata cache objects kept in memory. -->
				<!--replaceExistingFiles: Reuse the existing disk cache files available on disk-->
			<!-- 3: Disk Cache. Everything on disk.-->
				<!--replaceExistingFiles: Reuse the existing disk cache files available on disk-->
			<metadataStorageType value="1" maxObjects="-1" replaceExistingFiles="true"/>
			<!-- Enter one of these cubeSpecificOverride elements for each cube for which you wish to override the above datasource defaults -->
			<cubeSpecificOverride dataSourceName="*" catalogName="*"  cubeName="*">
					<securityContextMode value="1"/>
					<clearCacheEveryXminutes X="1440"/>
			</cubeSpecificOverride>
		</datasource>
		<!--  Essbase -->
		<datasource type="EB">
			<!-- Control the items used to provide the security context for metadata cache reuse and lolap cube reuse: -->
			<!-- 1: Always use UserIds;  other values for this option are not currently supported for Essbase. -->
			<securityContextMode value="1"/>
			<!-- Cache-clearing interval in minutes. The value -1 is interpreted as meaning "no configured cache clearing". -->
			<clearCacheEveryXminutes X="1440"/>
			<!-- Controls the storage type for secure member cache -->
			<!-- 1: Static Cache. All the objects will be stored in memory (The other two parameters maxObjects and replaceExistingFiles need not be set.)-->
			<!-- 2: Dynamic Cache. Creates a disk backed cache. Hold maxObjects in memory, the rest will be cached on disk.-->
				<!--maxObjects: maximum number of metadata cache objects kept in memory. -->
				<!--replaceExistingFiles: Reuse the existing disk cache files available on disk-->
			<!-- 3: Disk Cache. Everything on disk.-->
				<!--replaceExistingFiles: Reuse the existing disk cache files available on disk-->
			<metadataStorageType value="1" maxObjects="-1" replaceExistingFiles="true"/>
			<cubeSpecificOverride dataSourceName="*" catalogName="*"  cubeName="*">
					<securityContextMode value="1"/>
					<clearCacheEveryXminutes X="1440"/>
			</cubeSpecificOverride>
		</datasource>
		<!--  Dimensionally Modeled Relational -->
		<datasource type="DMR">
			<!-- Control the items used to provide the security context for dmr cube reuse: -->
			<!-- 1: Always use UserIds 2: Always use Profiles  -->
			<securityContextMode value="1"/>
			<!-- Cache-clearing interval in minutes. The value -1 is interpreted as meaning "no configured cache clearing". -->			
			<clearCacheEveryXminutes X="1440"/>
			<!-- For DMR, enter the properties of the first datasource in the model. -->
			<cubeSpecificOverride dataSourceName="*" catalogName="*"  cubeName="*">
					<securityContextMode value="1"/>
					<clearCacheEveryXminutes X="1440"/>
			</cubeSpecificOverride>
		</datasource>
		<!-- TM1 -->
		<datasource type="TM">
			<!-- Control the items used to provide the security context for metadata cache reuse and lolap cube reuse: -->
			<!-- 1: Always use UserIds 2: Always use Profiles 3: Use Profiles for metadata cache reuse and UserIds for lolap cube reuse -->
			<securityContextMode value="2"/>
			<!-- Cache-clearing interval in minutes. The value -1 is interpreted as meaning "no configured cache clearing". -->
			<clearCacheEveryXminutes X="1440"/>
			<!-- Controls the storage type for secure member cache -->
			<!-- 1: Static Cache. All the objects will be stored in memory (The other two parameters maxObjects and replaceExistingFiles need not be set.)-->
			<!-- 2: Dynamic Cache. Creates a disk backed cache. Hold maxObjects in memory, the rest will be cached on disk.-->
				<!--maxObjects: maximum number of metadata cache objects kept in memory. -->
				<!--replaceExistingFiles: Reuse the existing disk cache files available on disk-->
			<!-- 3: Disk Cache. Everything on disk.-->
				<!--replaceExistingFiles: Reuse the existing disk cache files available on disk-->
			<metadataStorageType value="1" maxObjects="-1" replaceExistingFiles="true"/>
			<!-- Enter one of these cubeSpecificOverride elements for each cube for which you wish to override the above datasource defaults -->
			<cubeSpecificOverride dataSourceName="*" catalogName="*"  cubeName="*">
					<securityContextMode value="2"/>
					<clearCacheEveryXminutes X="1440"/>
			</cubeSpecificOverride>
		</datasource>
		<!-- TM1 REST -->
		<datasource type="TMR">
			<!-- Control the items used to provide the security context for metadata cache reuse and lolap cube reuse: -->
			<!-- 1: Always use UserIds 2: Always use Profiles 3: Use Profiles for metadata cache reuse and UserIds for lolap cube reuse -->
			<securityContextMode value="2"/>
			<!-- Cache-clearing interval in minutes. The value -1 is interpreted as meaning "no configured cache clearing". -->
			<clearCacheEveryXminutes X="1440"/>
			<!-- Controls the storage type for secure member cache -->
			<!-- 1: Static Cache. All the objects will be stored in memory (The other two parameters maxObjects and replaceExistingFiles need not be set.)-->
			<!-- 2: Dynamic Cache. Creates a disk backed cache. Hold maxObjects in memory, the rest will be cached on disk.-->
				<!--maxObjects: maximum number of metadata cache objects kept in memory. -->
				<!--replaceExistingFiles: Reuse the existing disk cache files available on disk-->
			<!-- 3: Disk Cache. Everything on disk.-->
				<!--replaceExistingFiles: Reuse the existing disk cache files available on disk-->
			<metadataStorageType value="1" maxObjects="-1" replaceExistingFiles="true"/>
			<!-- Enter one of these cubeSpecificOverride elements for each cube for which you wish to override the above datasource defaults -->
			<cubeSpecificOverride dataSourceName="*" catalogName="*"  cubeName="*">
					<securityContextMode value="2"/>
					<clearCacheEveryXminutes X="1440"/>
			</cubeSpecificOverride>
		</datasource>
	</datasources>
</XQESecureCacheConfiguration>