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
- 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