analytics/configuration/xqe/bw.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.

#
# V5 Summary - Header, footer and within detail/aggregate.
#
v5.summary.remote=true
v5.summary.local=true 
# remote  - process remotely
# local	  - process locally
# balance - In balanced mode the summary expression will attempt to use local processing
# for simple case only.
v5.summary.location=balance

#
# V5 Sort 
#
v5.sort.remote=false
v5.sort.local=true 
# remote  - process remotely
# local	  - process locally
# balance - In balanced mode the order expression will attempt to use local processing
# for simple case only.
v5.sort.location=local

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

#
# Use Local OLAP (LOLAP) for Set Alias
#
v5.useLOLAPForSetAlias=true

#
# Use Local OLAP (LOLAP) when different hierarchies from same dimension are in the query. 
#
v5.useLOLAPForDiffHierarchiesFromSameDimension=true

#
# Use Local OLAP (LOLAP) for functions
#
v5.useLOLAPForFunctions=true

#
# Use Local OLAP (LOLAP) for set expressions containing a value expression operand that is context dependent
# on something in the query other than itself.
#
v5.useLOLAPForContextDependentSet=true

#
# Use Local OLAP (LOLAP) for MDX with SAP unsupported CurrentMember.
#
v5.useLocalOLAPForUnsupportedCurrentmember=true

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

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

#
# For LOLAP, this threshhold is used to decide to cache tuples or not.
#
lolap.tupleStorageThreshold=150000


#
# 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). The heuristic is as follows:
#	if (selCount > maxAxisSelections && selCount > dim.getCardinality() * maxAxisSelectionsRatio)
# 		// Use a "dim/hier.MEMBERS" clause in the MDX produced.
#
lolap.maxAxisSelections=200
lolap.maxAxisSelectionsRatio=0.5


#
# MDX Optimizations
# This configuration flags says whether the provider supports replacing the aggregate of child members with the parent
# when XQE believes this will be true.  This is not guaranteed to work for all providers, so this setting must default
# to false.
#

mdx.optimize.parentmember=true

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

#
# Force suppression before evaluating calculated members. 
# When true, the mdx engine can handle very large queries because this suppression
# could reduce the size of the queries significantly.
#
# The threshold determines the minimum size of the query for which this suppression 
# is applied. Set the default to Integer.MAX_VALUE.
#
mdx.suppression.beforeEvaluatingExpressions=true
mdx.suppression.beforeEvaluatingExpressions.threshold=2147483647

#
# Push query context for data fetching.
#
mdx.pushQueryContextForDataFetching=true


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

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

# 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

#
# Force MDX operators like FilterSet to be processed by the Database/Native MDX engine even when Local processing LOLAP is turned on
#
v5.enableFilterSetOptimization=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=10000

#
# When set to true, BAPI is used to execute and fetch the member filter.
#
v5.useBAPIForMemberFilterOptimization=true

# If the dataset size exceeds the configurable threshold then use BAPI to evalute the member filter set.
v5.memberFilterOptimization.datasetSize=10000

# 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=500

# some datasources like BW get the cardinality of the level at high cost, use the dimension cardinality unstead 
#
datasource.levelBasedDatasetCardinality=false

# Defer the evaluation of named set when Topcount/Filterset optimization is on for Local processing LOLAP
#
v5.deferNamedSetEvaluation=true

#
# 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=null

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

#
# 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=null
null.minus.operator=null
null.multiply.operator=null
null.divide.numerator=null
null.divide.denominator=zero
null.modulo.dividend=null
null.modulo.divisor=null

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

#
# 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=always

#
# Configuration to use either Valid_From or Valid_To as the key date for SAP time dependent hierarchy. 
# By default, use.valid.from=true, and the old code logic will apply. 
# When use.valid.from=false, the behaviour is:
# 1. There is only Valid_From -> the current date is used as key date.
# 2. There is only Valid_To -> Valid_To is used as key date.
# 3. There are Valid_From and Valid_To -> Valid_To is used as key date.
#
use.valid.from=true

#
# Allow an index in ancestor or descendants function to be converted to a level, regardless of ragged/unbalanced hierarchy condition.
#
convertIndexToLevelInAncDescFunc=true

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

#
# An SAP member might have one unique name but more than one parent.
# If this property is set to true, the caching engine will throw an error when it finds this member.
# If false, the caching engine will accept this member but with only one parent.
#
md.throwInvalidMemberUniqueName.multipleParents=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


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