analytics/configuration/ppds_cfg.xml.sample

<?xml version="1.0" encoding="UTF-8"?>
<!--
 Licensed Materials - Property of IBM

 IBM Cognos Products: ppds

 (C) Copyright IBM Corp. 2005, 2017

 US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
-->
<!-- -->
<PPDSConfiguration>
<!-- -->
<!-- =========================== -->
<!-- PPDS Cache Related Settings -->
<!-- =========================== -->
<!-- -->
<!-- Note: Cache settings are defined in kilobytes -->
<!-- -->
<!-- The PPDS Read Cache contains PowerCube records that are evaluated at query time. 
     ReadCacheSize specifies a default value used if not specified on the connection string.
-->
		<ReadCacheSize value="80000"/>
<!-- -->
<!-- WriteCacheSize specifies cache size used during cube builds.
-->
		<WriteCacheSize	value="32768"/>
<!-- -->
<!-- Flush percentage is the percentage of cache memory that is released whenever the cache is full.  
     The value is supplied in 0.01% scale (e.g. 530 is interpreted as 5.30%) 
-->
		<flushPercentage value="500"/>
<!-- -->
<!-- Temporary Cube Write Cache specifies cache size used when creating temporary cubes via DMB at runtime.
-->
		<TemporaryCubeWriteCacheSize value="4096"/>
<!-- -->
<!-- The Object Cache is used by PowerPlay when opening a remote cube, to cache metadata objects on the client side of the network connection.
-->
		<ObjectCacheSize value="1024"/>
<!-- -->
<!-- PowerCube bitmap operations can be performed on either compressed or uncompressed bitmsps.
     To enable uncompressed mode of bitmap operations, set UseUnpackedBitmaps to 1 (the new recommended default).
     To enable compressed mode, set UseUnpackedBitmaps to 0 
-->
		<UseUnpackedBitmaps value="1"/>
<!-- -->

<!-- -->
<!-- ================================ -->
<!-- PPDS PowerPlay Specific Settings -->
<!-- ================================ -->
<!-- -->
<!-- The following PPDS level settings apply only to PowerPlay. These settings are NOT applicable to the other Cognos 8 Studios.
-->
<!-- To disable PowerCube zero suppression, set DisableZeroCheck to 1 
-->
		<DisableZeroCheck value="0"/>
<!-- -->
<!-- To disable PowerCube suppression of zero value as a result of expression evaluation, set DisableMaxZeroSuppress to 1 
-->
		<DisableMaxZeroSuppress	value="0"/>
<!-- -->
<!-- In some rare PowerCubes, the normal, optimized zero suppression processing can remove rows/columns incorrectly. 
     Setting DisableZeroSuppressionPreProcessing to 1 will use the slower processing for zero suppression but will 
     result in correct zero suppression behavior.
     Customers should not change this value without contacting Cognos Customer Support 
-->
		<DisableZeroSuppressionPreProcessing value="0"/>
<!-- -->
<!-- In some rare PowerCubes, forcing the query decomposition for all special members is required in order to guarantee correct query results.  
     For most situations this is not required, hence the default setting of 0.
     Customers should not change this value without contacting Cognos Customer Support.
-->
		<DecomposePartitionedSpecials value="0"/>
<!-- -->
<!-- Enabling PPDS logging when using PowerPlay Client or PowerPlay Studio.
     queryLogFile is the full path and name of the log file and when specified will turn on logging. 
     There is no default log file name. To turn off logging, leave this parameter as an empty string. 
     LogFunctionNames controls whether PPDS logs the PPDS function name or internal code.
     Default value is 1, which logs functions by name.  When set to 0, the numerical internal function code will be logged.
-->
		<Section value="PowerPlay DataServer">
			<queryLogFile value=""/>
			<LogFunctionNames value="1"/>
		</Section>
<!-- -->
<!-- Restricting the communication port for the PPDS Remote Driver
     Set Port value to a non-zero value for network communication to be restricted to the port specified, rather than use an OS-assigned port.
     A NATTimeout value of:
	     -1 indicates don't support Network Address Translation (NAT)
	      0 assumes Network Address Translation
	      greater than 0 will test for Network Address Translation for the specified number of seconds.
-->
		<Section value="PPDSRemote">
			<Port value="0"/>
			<NATTimeout value="-1"/>
		</Section>
<!-- -->
<!-- ================================ -->
<!-- PowerCube Driver Logging Support -->
<!-- ================================ -->
<!-- -->
<!-- pcQueryLogFile is the full path and name of the log file and when specified will turn on logging. 
     There is no default log file name. To turn off logging, leave this parameter as an empty string. 
     Use this when you want to enable PPDS logging and you use a Cognos 8 Studio.
-->
		<pcQueryLogFile	value=""/>
<!-- -->
<!-- pcLogTiming controls the logging of time durations of a function call. Default value is 0, which means no output is generated.
-->
		<pcLogTiming value="0"/>
<!-- -->
<!-- pcLogDisplayDepth is the number of levels of API calls in stack to log. 
     The minimum and default value is 1, which logs only the top level calls. The max value is 15
-->
		<pcLogDisplayDepth value="1"/>
<!-- -->
<!-- pcLogFunctionNames controls whether PPDS logs the PPDS function name or internal code.
     Default value is 1, which logs functions by name.  When set to 0, the numerical internal function code will be logged.
-->
		<pcLogFunctionNames value="1"/>
<!-- -->
<!-- pcMaxLogFileSize is the max number of bytes to be written to the log file. 
     Default value is 0, which means no limitation.
-->
		<pcMaxLogFileSize value="0"/>
<!-- -->
<!-- pcMaxLogFileCount is the maximum count of log files to be kept before overwriting. Default is 101.
-->
		<pcMaxLogFileCount value="101"/>
<!-- -->
<!-- ========================================= -->
<!-- Miscellaneous PPDS Configuration Settings -->
<!-- ========================================= -->
<!-- -->
<!-- VersionedCubeTimeout is the number of seconds that the PowerCube engine will attempt to find a version file before giving up. 
     Longer times may be necessary if the version update phase takes longer during a cube swap.
-->
		<VersionedCubeTimeout value="30"/>
<!-- -->
<!-- Set Of Tupple (SOT) PowerCube Engine Processing.
     When an SOT is defined, the validation of the SOT can be very expensive.  
     This occurs in cases when tuples in the SOT contain members from one or more dimensions that are from more than one level.
     In such cases, if the number of tuples in the SOT is greater than tupleSetSizeLimit, then an error is returned, instead of processing the SOT.
     Properly validating the tuples in such cases becomes very expensive, especially for SOTs where each tuple has a tupleSize of greater than 2.
     Too avoid validations that could potentially take many minutes or even hours, this config value was introduced.
     Changing this limit should not be done without guidance from Cognos Customer Support.
-->
		<TupleSetSizeLimit value="50000"/>
<!-- -->
</PPDSConfiguration>