Course announcements

  • Availability as of January 2017
  • This course enables experienced SAP BW Query Designer users to create BW Queries with BW Query Designer in SAP HANA Studio in an SAP BW powered by SAP HANA system environment. This course is targeted at experienced users of BEx Query Designer who are migrating to a SAP Business Warehouse powered by SAP HANA system.

Goals

  • This course will prepare you to:
    • Understand and get an overview of SAP BW powered by SAP HANA from a Reporting perspective
    • Learn the process of creating BW Queries with the new BW Query Designer in SAP HANA Studio

Audience

  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User
  • Data Consultant / Manager
  • Technology Consultant

Prerequisites

Essential

  • Profound Knowledge of BEx Query Designer (BW305, TBI10)

Recommended

  • None

Course based on software release

  • SAP BW 7.5 on SAP HANA

Content

  • Introduction to SAP HANA
  • Comparison of SAP Business Warehouse on any database with SAP Business Warehouse running on SAP HANA database with focus on the reporting and analysis
  • Overview of SAP HANA Studio and BW Modelling Tools
  • Creation of BW Queries with BW Query Designer in SAP HANA Studio
  • Differences of BW Query Designer in SAP HANA Studio to BEx Query Designer relating to Queries, reusable query elements and where-used- list
  • Basic concepts of query performance optimization
  • Overview of Business Intelligence (BI) products based on SAP BW Queries (BI Platform server, Analysis for Office, Design Studio, Lumira, Web Intelligence, Crystal Reports)