| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "HANA"
| Line 1: | Line 1: | ||
| − | + | With the release of [[Version 8]] in September 14, XLCubed can connect to SAP HANA databases using MDX. This feature is licence dependant. | |
==Connecting== | ==Connecting== | ||
| Line 5: | Line 5: | ||
==Limitations== | ==Limitations== | ||
| − | Due to limitations in 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=== | ===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. | Instead XLCubed supports a number of pivot table like operations, accessed by right-clicking a grid member and choosing the "Apply" menu option. | ||
| Line 20: | Line 20: | ||
===Exclude from Display=== | ===Exclude from Display=== | ||
| − | This is not currently supported | + | This is not currently supported for HANA connections. |
| − | ===Mdx In Cell Charts=== | + | ===Mdx In-Cell Charts=== |
| − | These are not currently supported | + | These are not currently supported for HANA connections due to restrictions in the supported MDX. |
| − | Grids | + | 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=== | ===Session Calculations=== | ||
| − | These are not currently supported | + | These are not currently supported for HANA connections. |
Features disabled by this limitation are: | Features disabled by this limitation are: | ||
| Line 36: | Line 36: | ||
===Mdx Tables=== | ===Mdx Tables=== | ||
| − | + | The option to create a table based on HANA connections is currently disabled as HANA does not support the Mdx generated. | |
| − | |||
| − | The option to create a table based on HANA connections is currently disabled as HANA | ||
===Flex Reports=== | ===Flex Reports=== | ||
| − | These are not currently supported | + | These are not currently supported for HANA connections as HANA does not support the Mdx generated. |
| − | |||
| − | |||
===Drillthrough=== | ===Drillthrough=== | ||
| − | This is not currently supported | + | This is not currently supported for HANA connections. |
===Writeback=== | ===Writeback=== | ||
| − | This is not currently supported | + | This is not currently supported for HANA connections. |
Revision as of 16:27, 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.
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.
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.
