I would like to know what will be the best way to model below scenario.
System - SAP HANA (native HANA modeling) and BW 7.4 on HANA
Reportimg - Either on HANA side or on BW side both options are available
Case is to shift the reporting from MSSQL Server side to HANA either using Native HANA or using mixed approach i.e involving BW system also. Both these options are available for modeling and reporting.
Source is MSSQL Server , there are views on top of datatabase tables and some stored procedures to implement the business logic on SQL Server side reporting. Thought is to bring this data to HANA via SDI by using these views.
So, considering this what is the best way to model the data flow and implement the business logic on SAP side which was implemented on MSSQL side in stored procedures.
Basic Idea so far - Store data in HANA tables via views and build calculation view on top of them and implement logic on BW side in transformation by using these Calc Views via open ods in ADSO and report on Composite provider on BW side -( in this case planning to store data in ADSO only , use replicated SQL views to build calc views and use this calc view in ADSO )
Or there is other way to model this scenario and implement the custom logic .