SAP BW on HANA Training really stands for high performance analytical appliance so, analytical solution is a tool that lets you analyze your data or information but let’s look at each of these terms we will get to that but let’s examine what is the need of a high performance analytical appliance and let’s examine the drawbacks of existing systems or analytical solutions. Now the basic type of system that we have available today is open TP system which is a transactional system its built to be able to handle transactions you know such as sales recording sales etc…easily and that’s what it does, It has some basic reporting functions but it doesn't support any detailed analysis examples of such in system include SAP ERP or Oracle ERP on the other hand we have OLAP systems the analytical processing systems which are purpose- built analytics to work on the shortcomings of an old TP system.
We have SAP HANA as a Database on top of that we have SAP BW/BI, and HANA studio to design the views. In HANA studio we have Attribute view, Analytical view and Calculation view. And in the SAP BW BI we create cubes and DSO's then the system will automatically generate views in SAP HANA. SAP HANA started with 2.0 earlier 19 years ago, and it started SAP BW 3.5 and SAP BW or BI 7.0/ 7.1/7.2/7.3 SAP BW 7.4 and now we have SAP BW 7.5 when we have the SAP BW 7.4 or SAP BW 7.5 no need to create DSO cubes, it will automatically generate views in HANA system. They support a variety of analysis and data warehousing examples of these systems includes SAP BW or Oracle BI but when you look at the OLAP systems as the data of the corporation grows in size every day as it keeps increasing these OLAP solutions unable to perform properly.
SAP BW 7.50 is the following foundation on the rearrangements street towards the S/4 HANA. Additionally the Business Planning and Consolidation (BPC) is presently completely incorporated in the SAP BW programming layer for the standard and installed utilize case.With the full help of Advanced DSO (aDSO) objects for SAP-NLS and DT (dynamic tiering) and further upgrades for the BW displaying condition in Eclipse (inquiry originator) and the new HANA source framework to remain good with S/4 HANA. Most of the Data warehouses or reporting solutions store the data in the tables which are just logical representations of Data but actual storage is in hard drive.