| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "HANA"
(→Flex Reporting) |
|||
| Line 20: | Line 20: | ||
===Exclude from Display=== | ===Exclude from Display=== | ||
| − | + | This is not currently supported by HANA. | |
===Mdx In Cell Charts=== | ===Mdx In Cell Charts=== | ||
| Line 46: | Line 46: | ||
===Drillthrough=== | ===Drillthrough=== | ||
| − | + | This is not currently supported by HANA. | |
===Writeback=== | ===Writeback=== | ||
| − | + | This is not currently supported by HANA. | |
Revision as of 13:46, 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
This is 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
This is not currently supported by HANA.
Writeback
This is not currently supported by HANA.
