If not otherwise stated these topics are relevant for BWonHANA and BW/4HANA.
SAP Online Documentation
Performing OLAP Operations in SAP HANA
OLAP features where a Pushdown is possible:
- Exception Aggregation in SAP HANA
- Formulas with Exception Aggr. calculated in SAP HANA
- Unit Conversion in SAP HANA
- Currency Conversion in SAP HANA
- Pushdown of non-cumulative handling on SAP HANA(NOT recommended)
- 2161698 Non-cumulatives: Pushdown of non-cumulative handling on SAP HANA
- only in BW/4Hana and as of BW753: Conditions calculated in SAP HANA
See also SAP notes 2063449 and 2400004, Online Documentation Operations in SAP HANA/BWA and F1 help of Query Property 'Operations in BWA/HANA' in transaction RSRT. In particular when you are interested in prerequisites on InfoProvder level check
| 2400004 Checking 'Hana Pushdown' of OLAP features like Exception Aggregation |
Other Topics
- SQL / HANA Analytics-API
- Calculation Scenarios used by BW Queries
- BWonHANA: InfoProvider Column Views / report RSDDB_LOGINDEX_CREATE
- PlanViz Trace generated in RSRT
- Query Property Operations in BWA/HANA
- How to check if a pushdown is done: RSRT: Execute and Explain (OLAP Decryption)
- BWonHANA: Which Queries benefit from a 'Push Down' of OLAP Features
SAP Consulting Notes
- 2267049 Exception Aggregation Defined in a HANA Model is Ignored in a BW Query
- 2156123 Switch for first/last value exception aggregation in SAP HANA
- 2094114 BW service for setting system wide or user specific switches
- 2001947 Switch for operations in SAP HANA
- 2063449 Push down of BW OLAP functionalities to SAP HANA (Note: here the ones listed as 'available as new operation' means new feature implemented but no push down yet)
- 2176246 OLAP Functions cannot be Pushed Down to HANA when using HCPR Built on Calculation Views
- 2104915 How to determine if a BW on HANA query performance problem is HANA database related
- 2019973 BW on HANA - Handling BIG data tables
- 1858333 Query Execution Mode "2/3" reads more data than "0"
- 2036430 Open ODS View: Calculation Scenario for HANA Optimized Query Execution
- 1557321 Numeric Overflow during standard BW processes
1949273 Important SAP Notes for SAP BW 7.40, powered by SAP HANA
1787489 SAP HANA Database: Performance Trace
2690982 TrexViaDbsl Analysis Tool in ABAP