analytics/configuration/xqe/eb.properties

# Licensed Materials - Property of IBM
# IBM Cognos Products: OQP
# (C) Copyright IBM Corp. 2005, 2015
# 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 order expression will attempt to use local processing
# for simple case only.
v5.summary.location=balance

#
# V5 Sort 
#
v5.sort.remote=true
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

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


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

# 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

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


#
# 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=null
null.minus.operator=null
null.multiply.operator=null
null.divide.numerator=null
null.divide.denominator=null
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=forNonEmpty



# Force operators such as Cousin, ClosingPeriod, OpeningPeriod, ParallelPeriod, LastPeriod and PeriodsToDate 
# to apply on Ragged Hierarchies
engine.forceOperationsOnRaggedTimeHierarchies=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

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