Hana Database behind ECC (on Premise) {Hana 1.0}; Hana studio; No BW; Have Data services
Have created Hana graphical calculation views over several of these voluminous SAP tables and combined them with other data sets to answer a variety of reports and questions( eg: connect Material Master tables with CDPOS/CDHDR, MSEG, Internal Order tables with Order user or system Status: JCDS,JEST, JSTO.. etc).
Now , Whats the best / preferred way to expose these calculation views. viz:
1. aCreate ABAP report on calculation views as external views (by creating dictionary objects)
1.b Create ABAP CDS views over above external views
2.Use Excel to pull data through Hana views
3. Power BI or WebI to pull through Hana views
4. Expose as oData and into Fiori app (doesn't suit big tabulated report with a million rows)
5. Instead of making calculation views, make ABAP CDS Views (am not sure if its ok to have a ABAP CDS view carry out the different levels of joins and aggregations to give the final output. Currently, layers of Calc views handle the complexity in reusable sub calc views)
Thx
Rash