SAP HANA Connector – HANA view design to improve performance

As we know SAP HANA Connector is used to connect to SAP analytical and calc views. Sometimes HANA view might get complex and deep - it might have numerous joins, aggregations and the join might be between two fact tables (e.g. a join between Inventory and Sales tables). View might end up looking something like … Continue reading SAP HANA Connector – HANA view design to improve performance

SAP HANA Connector – Effects of creating measures in Direct Query mode

As we know SAP HANA Connector can be used in both Direct Query and Import mode. When using Direct Query mode, we do get the option to create measures in Power BI. Not all DAX functions are supported. Aggregations like SUM, MIN, MAX, COUNT, DISTINCTCOUNT are the only ones supported. We need to be careful … Continue reading SAP HANA Connector – Effects of creating measures in Direct Query mode