HANA for SCM / Snapshot reporting / Transformations

[Former Member]

Hi All,

reading the information about HANA my mind comes up with bellow questions.

Would be great if somebody (from SAP?) can clarify.

1.HANA SCM Usage

How can HANA be used for SCM? Is it that SBO data services would be used to extract the data and put it into HANA or is the plan that BW will be always between SCM and HANA (SCM->BW->HANA 1.0).

2.SNAPSHOT REPORTING

HANA usage for ERP is from my perspective u201Creal timeu201D data availability in HANA. But how about snapshot reporting? E.g. if you want to see inventory level developments over last 12 months how would that be realized with HANA in place? Would you need to deploy data services to u201Ctake a snapshotu201D to HANA or can you u201Cconfigureu201D the replication between ERP and HANA in the way that it can u201Ctake snapshotsu201D. Same question is how Snapshot reporting for SCM will work (forecast plan this month vs. forecast plan previous month) ... or is HANA no option for snapshot reporting?

3 TRANSFORMATIONS

What is the scenario if there are any transformations required for reporting? E.g. to harmonize ERP data with other systems? How would this work with HANA? Would that mean that you would need to use a BW for this (load data into HANA later or later have the BW completly on HANA)?

Thanks in advance,

Axel

[Vitaliy-R]

Hi Axel,

2. For historical reporting IMCE (HANA's db engine) is offering the concept of temporal tables, which will store timestamps and be used to calculate historical state.

3. If your HANA 1.0 use case assumes extensive data transformations, like harmonization of data from different source systems, then you better use SBO DS 4.0, where you can transform data either on their way from source system to HANA or load data into HANA and then have staging layers in IMCE and use DS to transform data as you move them from one layer to another.

Cheers,

-Vitaliy

[Former Member]

Hi Axel,

Let me throw some ideas here, and see if SAP can confirm

For SCM and any non-sap data sources you can either use data services or Sybase Data Replication server/agent. If you want to use the latter there are some prerequisites such as going to ECC 6.0, unicode etc. If you want to wait for HANA 1.5 for BW, then you will have to go to BW 7.3 first, and I assume you need to use BW 7 authorizations as well. I think there will be a HANA deep dive webinar(ASUG) on the March 8th by Ty Miller who can answer all these.

For the snapshot(time based report) and transformations you have to build the apps accordingly. Think about today you have an ERP report that you can enter time/date, if you can do that you should be able to the same with HANA. If you don't keep the status changes, then there is no way - unless building a report over CDPOS/CDHDR or sending data to BW etc.

Cheers

Tansu