| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "HANA"
(Created page with "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 conn...") |
(→Flex Reporting) |
||
| Line 40: | Line 40: | ||
The option to create a table based on HANA connections is currently disabled as HANA doesn't support the Mdx generated. | The option to create a table based on HANA connections is currently disabled as HANA doesn't support the Mdx generated. | ||
| − | ===Flex | + | ===Flex Reports=== |
These are not currently supported by XLCubed. | These are not currently supported by XLCubed. | ||
| − | The option to create a | + | The option to create a flex report on HANA connections is currently disabled as HANA doesn't support the Mdx generated. |
===Drillthrough=== | ===Drillthrough=== | ||
Revision as of 13:44, 31 July 2014
As of Version 8 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 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 Reports
These are not currently supported by XLCubed.
The option to create a flex report 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.
