Build a Data Mart and Create Analytical Extensions on SAP Cloud Platform for SAP S/4HANA

Data replication as a crucial step to increase employee productivity, resulting in better throughput


When we think about digital transformation, data warehousing often makes the list of top priorities. The challenge with traditional on-premise data warehousing and its traits like slow processing, lengthy and tedious modification processes, adding new data sets, difficulty scaling up/down as needed, results in excessive cost. Ever changing needs of the market span across most industries, for example, retail, field service domain like construction, healthcare, and the IT industry.

data mart with business intelligence on the cloud has been a sought-after remedy for the aforementioned scenario, complete with an omnichannel order execution and fulfillment tool based on real-time inventory data. With the data warehouse available on SAP Cloud Platform, you can decouple your data, providing rapid lifecycle to innovation, a better user experience (UX) to your end users, flexibility to perform analysis to your analysts, faster computational speed for the applications to your engineers, all with the option to scale up/down based on incoming requests.

SAP Cloud Platform Extension package together with SAP Landscape Transformation Replication Server (SLT) provide customers the tools needed to build extensions from their back-end systems on the cloud. Doing this helps businesses navigate towards becoming an intelligent enterprise. In addition to specific templates for application development, targeting the most commonly used business functions, customers receive the necessary tools to prototype and develop their own applications tailored for their own business needs.

To solve the business challenge of maintaining and streamlining inventory, a business would develop their own custom analytical application to help process precise stock assessments, immediate sales order creation, rollback for faulty devices and other crucial tasks, resulting in an overall increase in productivity.

The solution diagram above illustrates a combined architectural pattern of the runtime and design time environments for building a data mart and creating analytic extensions on SAP Cloud Platform for SAP S/4HANA.

Download the blueprint 

Bill of Material - SAP Cloud Platform components for licensing considerations

Please note that the following Bill of Material is for reference purposes only. The following table is only an example of the SAP Cloud Platform services and components required for this use case. Please consult your SAP Account Executive regarding your specific licensing needs.  

Sales Item


Licensing metrics


SAP HANA Service

The most advanced in-memory database fully managed across multiple clouds.

Instance per month

3 instances


Data transfer rate to a subscribed user.

Blocks of 10 GB bandwidth/month

10 GB


SAP Fiori Cloud

Revamp your user experience with SAP Fiori on SAP Cloud Platform. A license for Fiori Cloud includes a number of SAP Cloud Platform services

Per 100 named users/month

100 users

SAP Cloud Platform Identity Authentication

Secure authentication and single sign-on for users in the cloud.

Logons in blocks of 100

1 block

Customers can use the SAP Cloud Platform pricing estimator to calculate the required investment for a particular project. Scale up or down on services as required.

Members and partners of SAP PartnerEdge* can evaluate the development of an application for this use case – most development licensing is covered by the packs offered by SAP’s partner licensing services. Click here for details.

*excluding open ecosystem basic.