I made an example where we can see the cooperation among frontend analytical tool (Microsoft Power BI Desktop) with the backend system (SAP HANA Cloud Platform Trial).
Data refresh time (Refresh button) is about 1 second for a whole year data !!!
HANA Analytic view:
HANA Calculated view:
Power BI Query:
Power BI Visualization: