HANA

As of Version 8 XLCubed can connect to SAP HANA databases using MDX. This feature is licence dependant.

Connecting

Select the SAP HANA connection type in the new connection form. You must then fill in the server name or IP address and instance number. Usually you will need to enter a name and password, if so tick the "Requires Logon" box.

Limitations

Due to limitations in the HANA database engine some XLCubed features are not currently available.

Ranking, Filtering and Sorting

These are not currently supported by HANA.

Instead XLCubed supports a number of pivot table like operations, accessed by right-clicking a grid member and choosing the "Apply" menu option.

Features disabled by this limitation are:

• Advanced member selections
• Standard grid "Apply" menu
• Breakout - grid and formula
• Insert formula - Ranking
• Small multiples - Bump chart

Exclude from Display

These are not currently supported by HANA.

Mdx In Cell Charts

These are not currently supported by HANA.

Grids against these connections can not have incell charts in them, although you can still create normal incell charts from the data they retrieve.

Session Calculations

These are not currently supported by HANA.

Features disabled by this limitation are:

• Custom Calculations
• Member Selector options to "Group members", "Create Set" and "Calculated value"
• Grid options to "Keep and Group members" and "Keep and Create Set"

Mdx Tables

These are not currently supported by XLCubed.

The option to create a table based on HANA connections is currently disabled as HANA doesn't support the Mdx generated.

Flex Reporting

These are not currently supported by XLCubed.

The option to create a table based on HANA connections is currently disabled as HANA doesn't support the Mdx generated.

Drillthrough

These are not currently supported by HANA.

Writeback

These are not currently supported by HANA.