Best Modeling Scenario in SAP HANA

[former_member190408]

Hello Experts,

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 .

Thanks

[former_member594891]

Hello,

you say that the data source is msSQL (that is, the data source is not an SAP ECC). So, I do not see what advantages you have incorporating SAP BW.

Also, it's likely that you can partially reuse SQL in HANA views

If in the future, your DWH has an SAP source system, then it would make more sense to have a mixed scenario: HANA for non-sap data and BW for SAP data, modeling the upper layer with HANA views

[former_member190408]

Hello Adria,

Thank you for your response. The reason why i thought of involving BW was to implement the custom logic of Stored Procedure ( which is there on MS SQL side) and store the results in ADSO after processing.

If only HANA is considered then I guess only option is to go for script based Calculation views and implement the logic there . The data is volume will be high so thought of storing this data.

Is there any better option?

Thanks

[former_member594891]

If you think that the performance will be bad due to the large amount of data, you always have the option to use a materialized view (or a materialized aggregate to increase performance).

[former_member190408]

Thanks Adria for the reply. Could you please help me understand what is meant by "you always have the option to use a materialized view (or a materialized aggregate to increase performance)." Sorry I didnt get it completely.

Thanks