Essbase support

XMLA connections to Essbase data sources are supported, with some limitations:

Unsupported functionality
Essbase does not support this functionality:
  • Writeback
  • Session members (calculated elements)
  • Filtering by regular expression or by wildcard
Fully qualified domain names
Functions that depend on hierarchy unique name forming part of the element unique name are not supported. Examples are CELLGET and CELL.GETC
Intrisic element properties
Essbase supports only these intrinsic element properties:
  • LEVEL_NUMBER
  • MEMBER_CAPTION
  • MEMBER_NAME
  • MEMBER_TYPE
  • MEMBER_UNIQUE_NAME
  • MEMBER_ALIAS
  • GEN_NUMBER
Lack of support for other intrinsic element properties, such as CHILDREN_CARDINALITY can adversely affect performance because additional MDX requests are required in order to get the properties.
Other properties
These properties are not supported, which adversely affects the performance of Office Plus ad-hoc reports:
  • MDDISPINFO_DRILLED_DOWN
  • MDDISPINFO_SAME_PARENT_AS_PREV

DISPLAY_INFO returns only the number of children of an element.

Value data types
All values are treated as numbers because Essbase does not specify value data types.
Unique name filtering
Filtering by these criteria does not fail but may produce unexpected results:
  • MEMBER_CAPTION
  • MEMBER_UNIQUE_NAME