SAP BW on HANA course content

SAP BW :

SAP Business Warehouse (BW) integrates data from different sources, transforms and consolidates the data, does data cleansing, and storing of data as well. It also includes data modeling, administration and staging area.

SAP Business Intelligence (BI) means analyzing and reporting of data from different heterogeneous data sources. It allows you to acquire data from multiple data sources, data staging, which can be further distributed to different BI systems. A SAP Business Intelligence system can work as a target system for data transfer or source system for distribution of data to different BI targets.

This is a simple tutorial that covers the basics of SAP Business Intelligence and how to handle its various other components.

WHAT IS SAP HANA:

Deployable on premise or in the cloud, SAP HANA is an in-memory data platform that lets you accelerate business processes, deliver more business intelligence, and simplify your IT environment. By providing the foundation for all your data needs, SAP HANA removes the burden of maintaining separate legacy systems and siloed data, so you can run live and make better business decisions in the new digital economy.

Audience.

This tutorial is prepared for those readers who wish to learn the essentials as well as the enhancements of SAP BI and bring it in practice. This tutorial is intended to make you comfortable in getting started with SAP BI and its various other modules.

SAP BW on HANA Online Training, Best SAP BW on HANA Online Course in Hyderabad, Free Demo on SAP BW on HANA, SAP Online Training

Prerequisites.

This is a simple tutorial and the concepts explained here can be easily understood. The readers should have a good understanding of data warehousing concepts as it is very important. Also, it will certainly help, if you have ample business knowledge on various application areas and a little experience of ABAP Language.

Overview of the SAP BW in Hana  :       

SAP Business Warehouse (BW) powered by SAP HANA refers to using BW software suite on top of HANA database. This functionality explores all the key features of HANA database technologies and uses BW as a modeling tool for data modelling and analytical reporting. BW software supports various databases like Oracle, Microsoft, IBM DB2, Teradata, and many more. BW on HANA suggests that you are using HANA as database for BW data modeling capabilities and no other database is required.

BI BUSINESS INTELLIGENCE:

Business intelligence combines a broad set of data analysis applications, including ad hoc analytics and querying, enterprise reporting, online analytical processing (OLAP), mobile BI, real-time BI, operational BI, cloud and software-as-a-service BI, open source BI, collaborative BI, and location intelligence..

CRM stands for Customer Relationship Management, CMS stands for Content Management System and ERP stands for Enterprise Resource Planner. 

BW on HANA: Important Transactions:

Following are the key transaction codes to be used in BW on HANA system.
RSA1 − To open BW workbench
RSMIGRHANADB − To convert in-memory optimized BW
SM59 − To configure RFC connection for SLT
Ltr − To configure Trusted RFC
RSPCM − To monitor periodic process chains
RSPC − To view the log for runs of a process chain
RSLIMO − BW Lean Modeler Test UI

Benefits of bw on hana:

Using BW powered by SAP HANA, you can find the following benefits −

• Excellent performance in analytical reporting and data loading using HANA in memory database capabilities. All BW functions performed in SAP HANA benefits from in-memory database and calculation engines for faster data processing.
• With HANA optimized objects, you can perform complex queries, detailed analysis, high data volume, and aggregations efficiently.
• All existing BI tools such as BEx, Business Objects BI reporting tools, and Microsoft Excel are directly supported by SAP BW on HANA.
• SAP HANA provides high level of data compression. Column storage of tables requires less storage type and hence provides lower Total Cost of Ownership (TCO).
• Business Warehouse Accelerator (BWA) is not required while using HANA underneath BW.
• You don’t need aggregated tables and HANA supports on-the-fly aggregations.
• It has simplified data modeling by using in-memory-optimized objects. There is no need to load BWA index.
• When you use SAP BW on HANA, the following processes are not required −
• Rolling Up Filled Aggregates
• Filling of New aggregates
• Adjust Time-Dependent Aggregates
• Construct Database Statistics
• Build Index
• Delete Index

    SAP BW on HANA - HANA Basics:

• HANA database takes advantage of in-memory processing to deliver the fastest dataretrieval speed, which is enticing for organizations struggling with high-scale online transactions or timely forecasting and planning.
  Disk-based storage is still the enterprise standard and the price of RAM has been declining steadily. Thus, memory-intensive architectures will eventually replace slow, mechanical spinning disks and will lower the cost of Data storage.
  In-memory column based storage provides data compression up to 11 times, reduces the space to store huge amount of data.
  The speed advantages offered by RAM storage system are further enhanced by the use multi-core CPU’s multiple CPUs per node and multiple nodes per server in the distributed environment.

Benefits of SAP NetWeaver BW 7.3:

Wizard based system configuration – supports coping data flows, process chains, etc…Accelerated data loads - SAP has rewritten underlying code for data loads for optimized performance.Performance improvement for BW AcceleratorTighter integration with SAP Business Objects Data ServicesEnhanced Integration with SAP Business Objects Metadata ManagementAutomated creation of Semantic Partitioned ObjectsGraphical Data flow modeling and best practice data modeling patternsAdmin Cockpit integrated into SAP Solution ManagerPerformance optimizations for MDX StatementsSQL access via SAP Business Objects Data FederatorXcelsius to leverage SAP NetWeaver BW BICS (BI Consumer Service Interface) for a direct and lean access to data of SAP NetWeaver BW

• 
  
• Getting Started with SAP HANA Studio:
• 
  
• SAP HANA studio is an Eclipse-based tool that runs on development environment and administration tool for working on HANA.
  SAP HANA studio is both the central development environment and the main administration tool for HANA system. It is a client tool which can be used to access local or remote HANA system.
  It provides an environment for HANA Administration, HANA Information Modeling and Data Provisioning in HANA database.
  SAP HANA Studio can be used on the following platforms −
  • Microsoft Windows 32 and 64 bit versions of: Windows XP, Windows Vista, Windows 7
  • SUSE Linux Enterprise Server SLES11: x86 64 bit
  However, in Mac OS, HANA studio client is not available.
  Depending on HANA Studio installation, all features may not be available. At the time of Studio installation, specify the features you want to install as per the role. To work on the most recent version of HANA studio, Software Life Cycle Manager can be used for client update.

  SAP HANA Studio − AFeatures

  SAP HANA Studio provides a perspective to work on the following HANA features. You can choose the Perspective in HANA Studio using the following path, HANA Studio → Window → Open Perspective → Other
  

• KEYWORDS FOR SAP BW ON HANA:

• SAP BW on HANA Online Training, Best SAP BW on HANA Online Course in       Hyderabad, Free Demo on SAP BW on HANA, SAP Online Training.










• 
  

SAP Business Warehouse 7.5

With this latest SAP BW release customers  benefit from phantastic performance  and simplified data modeling within in a new, modern UI that is unique across all modeling tools

• 
  

Introduction to Data Warehousing :

• Architecture of Data Warehousing

• OLTP Vs OLAP

• Multi-Dimensional Modeling/ Star Schema Vs Entity Relationship Modeling

• Enterprise Reporting, Query and Analysis

• ETL and Reporting Tools
• Evolution of SAP BW/BI and HANA Landscape

• Discuss SAP BW  

•   on Hana:

SAP Business Warehouse (BW) powered by SAP HANA refers to using BW software suite on top of HANA database. This functionality explores all the key features of se technologies and HANA databauses BW as a modeling tool for data modeling and analytical reporting. BW software supports various databases like Oracle, Microsoft, IBM DB2, Teradata, and many more. BW on HANA suggests that you are using HANA as database for BW data modeling capabilities and no other database is required.

• SAP HANA Data Warehousing Bw sap hana:

  • BW/4HANA Community
  • Data Warehousing with SAP HANA - BARC Research Note
  • SAP EIM
  • PowerDesigner
  • Information StewardWarehousing      
  • Modeling Tools in Eclipse – Videos
  • Operational Data Provisioning (ODP)
  • SAP BW ALM
  • SAP-NLS Solution for SAP BW              

  
  

• 

• 
  

• 
  

SAP HANA Data Warehousing

SAP HANA Data Warehousing summarizes SAP's offering for flexible and agile Data Warehousing. It’s based on SAP BW/4HANA as our premium Enterprise Data Warehouse product, and a SQL driven approach   consisting of SAP HANA in combination with the SAP Power Designer, SAP EIM, SAP HANA DW Foundation, SAP Information Steward and more.

HANA Optimized Objects:

• HANA-Optimized InfoCube
• Semantically Partitioned Object
• Advanced Data Store Object
• Open ODS Views
• Composite Provider
• HANA Analysis Process

•