SAP BW 7.4 on SAP HANA / The In-Memory Data Fabric
With this blog Thomas Zurek sheds some light into the direction that SAP is taking towards a unified offering for building a data warehouse on top of HANA. The unofficial working title is the HANA DW. The blog is divided into 3 sections, each addressing the most pressing questions from customers who have already seen flavours of this.
Read about SAP’s overall Data Warehouse strategy.
Since SAP BW 7.4 powered by SAP HANA, we introduced a new modelling experience for BW using eclipse. This toolset provides a common user experience via a central, unified, modeling environment. Learn more about this with the new Video Learning Series on the SAP BW powered by SAP HANA – Modeling Tools in Eclipse page
SAP BW 7.4 SP8/SP9 powered by SAP HANA is the next milestone for enterprise data warehousing with BW on HANA and provides major enhancements in the area of running SAP BW on HANA as the Virtual Data Warehouse with the next level of Open ODS Views and additional CompositeProvider scenarios. In order to provide further simplification the Advanced DataStore object will consolidate DataStore Objects and InfoCubes. Data modeling as well as query design will be supported via a common user experience. Big Data scenarios will be supported by SAP HANA dynamic tiering and performance enhancements will be provided for data staging as well as for OLAP analysis. Customers focusing on the planning capabilities will benefit from the enhanced Planning application Kit and FOX usability.
The advanced DataStore object is available since SAP BW 7.4, SP8.
You are eager to use it for new data models and also for existing data flows?
Read this document from Tanja Wingerter about the conversion of existing DataStore objects and InfoCubes into advanced DataStore objects
In his blog Thomas Zurek resolves the confusion around the terminology of extended storage and dynamic tiering within HANA. Further details can be found in the presentation attached to SAP Note 1983178.(SMP Login required)
Read this blog from Marc Bernard to find out about the changes with a new SAP BW release or what features were introduced with certain support packages.
SAP NetWeaver Business Warehouse (not only on SAP HANA) continues to be the cornerstone of SAP’s strategic vision for enterprise data warehousing providing organizations a solid data foundation to capture, store, transform and manage data in a scalable, enterprise-ready data warehouse. See this presentation to understand the mayor steps for a successful upgrade to SAP Business Warehouse 7.40 SP06 and higher
This presentation mainly lists the removed limitations of the PAK by revision, explains the FOX enhancements for IP, shows how the support of the CompositeProvider in addition to the MultiProvider works, and describes the new master data maintenance UI based on WebDynpro.
SAP BW 7.4 ABAP Support Packages Schedule and Implications
For details on restrictions of the BEx tools please investigate the SAP Business Explorer Space