SAP BW 7.4 on SAP HANA / The In-Memory Data Fabric
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.
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