analytics/configuration/xqe/tm10.1.1.properties

# Licensed Materials - Property of IBM
# IBM Cognos Products: OQP
# (C) Copyright IBM Corp. 2005, 2020
# US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM corp.


#
#
#
# LOLAP TM1 settings.  Settings override tm.properties, plus new settings for LOLAP only.
#
#
#

#
# Use Local OLAP (LOLAP) for these queries
#
v5.useLocalOLAP=true


#
# MDX Function Support
#
mdx.support.setalias=true


#
# MDX Support for OLYMPIC rank with implicit sort
#
mdx.support.olympicRankSort=false

#
# This property tells the MDDS provider whether to use MDX or metadata calls to retrieve members
#
useMDXToFetchMembers=true


#
# This property controls how to handle the projection of nested levels of the same hierarchy.
# Specifically the use of the technique involving nested level decoration rules.
# In that case the planner queries only the lowest level members, later the post-processing queries the outer levels if required.
# - always: always use this technique
# - never: never use this technique
# - automatic: allow the planner to decide whether to use or not this technique.
#
applyNestedLevelDecorationRules=always


#
# This property tells whether the provider may filter the data before applying the MDX.
# It may take one of this values:
# - always: the provider always filter the data before applying the MDX,
# - never: the provider never filter the data before applying the MDX,
# - forNonEmpty: Only in the presence of MDX edge NON EMPTY the provider filters the data before applying the MDX.
#
datasource.appliesFilterBeforeMDX=never


#
#
#
# Start LOLAP TM1 settings (they do not affect queries going to bluenose)
#
#
#

#
# Use hierarchy to resolve ambiguity
#
mdx.level.hierarchy.ambiguity.resolution=hierarchy

#
# Replace addition operator over base members from a single hierarchy with a SUM function
#
mdx.replaceAdditionOperatorWithSUM=true

#
# Force operators such as Cousin, ClosingPeriod, OpeningPeriod, ParallelPeriod, LastPeriod and PeriodsToDate 
# to apply on Ragged Hierarchies
#
engine.forceOperationsOnRaggedTimeHierarchies=true

#
# Turn on sub Query planning for Local OLAP (LOLAP) Query Cache generation
#
v5.planSubQueryForLocalOLAP=false

#
# Use Single Axis Query for LOLAP provider queries
#
lolap.singleAxis=true

#
# For LOLAP providers to decide if producing MDX that selects individual members
# on an axis is worthwhile (vs. using a "dim/hier.MEMBERS" clause in the MDX produced
# to retrieve measure values).
# maxAxisSelectionsIgnoreRatio is a hard upper bound on the number of individual members 
# that can be selected. If it is set to -1, there is no upper bound.
# The heuristic is as follows:
# if (maxAxisSelectionsIgnoreRatio > -1 && selCount > maxAxisSelectionsIgnoreRatio ||
#		(selCount > maxAxisSelections && selCount > dim.getCardinality() * maxAxisSelectionsRatio))
# 		// Use a "dim/hier.MEMBERS" clause in the MDX produced.
#lolap.maxAxisSelections=200 # set in olap.properties
#lolap.maxAxisSelectionsRatio=0.5 # set in olap.properties
lolap.maxAxisSelectionsIgnoreRatio=20000
# 
# For LOLAP providers to decide if splitting a symmetric query for a requested set of tuples into
# multiple more precise queries is worthwhile.
# The heuristic for determining whether to split a requested set into multiple queries is:
# if (symmetricTuples - requiredTuples > minExcessTuplesForSplitQuery 
#		&& symmetricTuples / requiredTuples > excessTuplesRatioForSplitQuery)
# When either threshold is set to -1, a requested set of tuples is never split into multiple queries.
#
lolap.minExcessTuplesForSplitQuery=100000
lolap.excessTuplesRatioForSplitQuery=2

#
# Null behavior of comparison operators (=, !=, <, <=, >, >=) in the MDX engine. 
# This should be set to "null" or "zero".
# When set to null, expressions such as "null < number" and "number < null" will evaluate to null.
# When set to zero, null is treated as zero.
#
null.comparison.operator=zero

#
# Null behavior of boolean operators (and, or, xor) in the MDX engine. 
# This should be set to "null" or "false".
#
null.boolean.operator=false

#
# Null behaviour in the MDX engine for the arithmetic operators: +, -. *, /, %
# When null.divide.denominator is set to zero, a number divided by null will return /0.
# When null.divide.denominator is set to null, a number divided by null will return null.
#
null.plus.operator=zero
null.minus.operator=zero
null.multiply.operator=null
null.divide.numerator=null
null.divide.denominator=zero
null.modulo.dividend=null
null.modulo.divisor=zero

#
# Null behaviour in the MDX engine vb functions (Abs, Int, Round).
#
null.vb.math.function=null

#
# Property to set the maximum size(M) of LOLAP ResultSet cache.
# Default value is 50M. 
# 0 or negative value disables LOLAP ResultSet cache.
#
lolapResultSetCacheSize=50

# Force MDX operators like TopCount to be processed by the Database/Native MDX engine even when Local processing LOLAP is turned on
#
v5.enableTopCountFunctionsOptimization=true

# If the dataset size exceeds the configurable threshold then allow the MDX operator to be processed by the 
# Database/Native MDX engine even when Local processing LOLAP is turned on
v5.topCountFunctionsOptimization.datasetSize=100000

# If the projected dataset size is less the configurable threshold then allow the MDX operator to be processed by the 
# Database/Native MDX engine even when Local processing LOLAP is turned on
v5.topCountFunctionsOptimization.projectedSetSize=1000


#
# Optimize the descendants function to fetch descendants of a member directly.
#
OptimizeDescendantsFunctionInSAL=limited

#
# Move simple sets to named sets when possible.
#
mdx.optimize.set=true

#
# Specify whether or not the provider requires the DefaultMember to be transformed into a NoMember.
#
mdx.useNoMemberDefaultMember=true


#
#
#
# End LOLAP TM1 settings (they do not affect queries going to bluenose)
#
#
#