| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "HANA"
(→Limitations) |
|||
| Line 7: | Line 7: | ||
Due to limitations in the MDX support of the HANA database engine some XLCubed features are not currently available. | Due to limitations in the MDX support of the HANA database engine some XLCubed features are not currently available. | ||
| − | ===Ranking, Filtering and Sorting=== | + | ===Advanced Ranking, Filtering and Sorting=== |
'Advanced' Ranking Filtering and Sorting within a hierarhcy are not currently supported for HANA connections. | 'Advanced' Ranking Filtering and Sorting within a hierarhcy are not currently supported for HANA connections. | ||
Revision as of 16:28, 31 July 2014
With the release of Version 8 in September 14, XLCubed can connect to SAP HANA databases using MDX. This feature is licence dependant and requires the HANA connector.
Contents
[hide]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 MDX support of the HANA database engine some XLCubed features are not currently available.
Advanced Ranking, Filtering and Sorting
'Advanced' Ranking Filtering and Sorting within a hierarhcy are not currently supported for HANA connections.
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
This is not currently supported for HANA connections.
Mdx In-Cell Charts
These are not currently supported for HANA connections due to restrictions in the supported MDX.
Grids connecting to HANA can not have in-cell charts defined as an interactive part of the grid. Standard formula based incell charts can still be used on data retrieved from Hana through a grid or XLCubed formulae.
Session Calculations
These are not currently supported for HANA connections.
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
The option to create a table based on HANA connections is currently disabled as HANA does not support the Mdx generated.
Flex Reports
These are not currently supported for HANA connections as HANA does not support the Mdx generated.
Drillthrough
This is not currently supported for HANA connections.
Writeback
This is not currently supported for HANA connections.
