SAP Analytics: Integration is the keySAP develops outstanding software for handling all of a company’s business processes such as accounting, controlling, sales, purchasing, production, warehousing and human resources. The hallmark of the self-developed software is the high degree of adaptation to customer requirements via parameters in tables. This makes a lot of things possible, the price for this is a high complexity compared to competitors. SAP Analytics is characterized by a very high level of integration between the individual applications.
SAP HANA – the technological basis for SAP AnalyticsSAP HANA provides the technological basis for all future solutions. This is supplemented by other databases such as SAP IQ. SAP HANA is derived from “High Performance Analytic Appliance”. The basis is in-memory technology. Characteristic features of SAP HANA are:
SAP HANA: R IntegrationThe requirements for advanced analytics algorithms are difficult to map with the standard procedures implemented in SAP HANA. SAP HANA therefore offers an integration of the R server. This makes it easy to call R code in SQL procedures. I like to access solutions in R for the recognition of patterns in data or for questions around the topic of time series analysis. Well-known examples of time series are stock prices, unemployment statistics, weather data, etc.
SAP BW – the classic data warehouse from SAPSAP BW was first released in 1998 as the Business Warehouse Information System (BIW). Since then, BW has gone through many iterations. For big data, it was and still is useful to have a separate data model optimized for analysis. SAP BW is a full-featured data warehouse application that enables the integration, transformation and consolidation of relevant business information from production SAP applications and external data sources. The data warehousing process includes data modelling, extraction, transformation and loading (ETL) as well as data warehouse process management. SAP BW comes with various tools and services to support the development of SAP BW objects and processes, the provision of data to the system landscape, the execution of tests and traces, and the monitoring of the system landscape. SAP BW is also a full-featured business intelligence application that provides reporting and analysis tools and capabilities that enable organizations to make well-formed tactical and strategic decisions. Its online analytics processor provides OLAP capabilities and services, as well as services for BW-integrated design of planning and analysis processes. SAP BW uses only database functionality based on Open SQL: the lowest common denominator of all databases supported by SAP applications. Deep integration while supporting a wide variety of databases was only possible to a limited extent. Convergence of application and database can only succeed when focusing on one database technology. The result is BW/4HANA. In the webinar, I will show how easy it is for you to switch to the modern product version. Benefit from our experience!
BW/4HANA the central data warehouseAs a database, BW/4HANA only uses SAP HANA. Technically and functionally, BW/4HANA is still very similar to SAP BW on HANA 7.5 in the first version. BW/4HANA is now focused as a data warehouse tool. Other products are needed for reporting and planning. SAP’s architecture diagram nicely shows the interaction of SAP HANA, BW/4HANA and the front end tools (reporting and planning).
BW/4HANA vs. SQL-Data Warehouse
- Modelling templates for the different objects of the data warehouse
- Load requests (load requests can be easily cancelled, transparency in data creation à internal control system for revision and auditors)
- Analysis authorizations
- SAP DataSources (data extraction consistent with business transactions; enriched with metadata (labels, attributes, hierarchies, texts)
- Consistency with SAP systems can be easily established (fiscal year variants, currencies and currency conversion, unit conversion, etc.)
- Business Content (data model templates)
Pro SQL Data Warehouse
- Full modeling flexibility
- Knowledge is widely used by non-SAP developers