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

# === Capabilities for MSAS via XMLA (version independent, 2005+) ===

#
# XMLA
#

# Indicates if the provider supports XMLA Sessions.
# MSAS requires session support for canceling queries.
xmla.supportSessions=true

# Indicates if we should include the CAM passport in the SOAP request by default.
# This can be over-ridden in the xqeodp.config.xml file via <usePassport value="true"/>
xmla.supportCAMPassports=false

#
# OLAP Metadata
# 

# Indicates if we should be faking member keys. This is required for when we have no knowledge of the keys.
olap.metadata.fakeMemberKey=false

# Indicates if we should be skipping any property that ends in ".MEMBER_KEY". This is needed for Cubing Services,  
# since we get two MEMBER_KEY properties returned when the customer has modeled it, and we only need one! :)
olap.metadata.skipDotMemberKey=false

# Indicates if we should be forcing parent-child hierarchies to be treated as unbalanced.
olap.metadata.forceParentChildToUnbalanced=true

# Indicates if we should be forcing ragged hierarchies to be treated as unbalanced.
olap.metadata.forceRaggedToUnbalanced=true

# Indicates if we should be returning hierarchies as dimensions.
olap.metadata.returnHierarchiesAsDimensions=false

# Indicates if we should be using the level names to determine if a hierarchy is parent-child. For MSAS 2000 and
# Cubing Services, if all the level names for a hierarchy start with "Level " and a number, then we consider it to 
# be a parent-child hierarchy.
olap.metadata.determineParentChildByLevelNames=false

# Indicates if we can use Member Unique Names for the Actions restrictions.
# For MSAS 2005+, this is fine.  For 2000, when retrieving the Dimension Actions, the
# co-ordinate must be a HUN :).  For Level Actions, it must be a LUN (not a MUN).
olap.metadata.useMUNsForActionRestrictions=true

# MDDS doesn't worry about sorting hierarchies for MS2005+.
# In order to remain consistent the ODBO provider shouldn't either. 
olap.metadata.applyNewRankToHierarchies=false

# Do we sort hierarchies and dimensions by ordinal?
olap.metadata.sortHierarchiesByOrdinal=true

# Indicates if we can set the style that is used to generate Unique Names.  Meant for MSAS providers.
olap.metadata.supportUniqueNameStyle=true

# Indicates if we can set a flag to disable the prefetching of facts.  Meant for MSAS 2005+ providers.
olap.metadata.supportDisablePrefetchFacts=false

# Indicates if this provider supports the Timeout parameter for data and metadata queries.
olap.metadata.supportTimeout=true

# Indicates if this provider supports setting the Application Name which will be used in Server logs.
olap.metadata.supportApplicationName=false

# Indicates if this provider supports the setting of "MEMBER_KEY" in a property restriction.
olap.metadata.canUseMEMBERKEYRestriction=false

# Indicates if we should expect to be getting non-null LAST_SCHEMA_UPDATE and LAST_DATA_UPDATE Cube values.
olap.metadata.supportLastSchemaUpdate=true

# Indicates if the catalog name is case insensitive or not.
olap.metadata.caseInsensitiveCatalog=true

#
# OLAP Data
# 

# Indicates if this provider supports returning the ClusterFormat from data queries.
olap.data.supportClusterFormat=true

# Indicates if this provider supports the currency units.
olap.data.supportCurrencyUnits=true

# Indicates if this provider supports the setting of MDXMissingMemberMode for data queries.
olap.data.supportMDXMissingMemberMode=false