SAP HANA Connector – HANA view design to improve performance

No comments

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 this…

HANAview

When Power BI connects to these HANA views, especially in Direct Query mode, every click becomes expensive. And if there are multiple visuals on the page, multiple queries are executed against this view, hence impacting performance.

When creating HANA views, keep joins to a minimum and materialize the view where possible. This greatly improves Power BI performance.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s