Set Up SAP Web IDE for SAP HANA for SAP HANA Modeling

Objective

After completing this lesson, you will be able to set Up SAP Web IDE for SAP HANA for SAP HANA modeling

Introduction

In this unit, we focus on modeling in SAP HANA. Before we see how SAP HANA Calculation Views can be created in SAP HANA, we have to set up SAP Web IDE for SAP HANA.

Let's see how SAP HANA Calculation Views can be created in SAP HANA to report real time sales data of ItelO, including the use of hierarchies and currency conversion.

Then we see how calculation views can be generated from SAP BW/4HANA objects and can be used in native SAP HANA modeling.

So, finally we have learned about modeling in SAP BW/4HANA and SAP HANA and show an overview to see what mixed scenarios can offer.

Introduction of SAP Web IDE for SAP HANA

Tools for SAP HANA Modeling

In this course, we use the following tools related to SAP HANA Modeling:

  1. SAP HANA Studio is a client-side installation based on Eclipse. This is the same interface for modeling in SAP BW/4HANA where we use the special Eclipse add-in called SAP BW Modeling Tools, (BWMT). Calculation View modeling in SAP HANA Studio is still possible, but the interface only supports the weaker (XS Classic) version of the calculation views. However, it is used to explore the generated HANA Views from SAP BW/4HANA objects.
  2. SAP Web IDE for SAP HANA is a browser-based, integrated development environment (IDE) and is the recommended tool for native SAP HANA Modeling and database administration. It works with the replacement of XS Classic which is called SAP HANA Extended Application Services Advanced (XS Advanced or simply XSA). SAP Web IDE supports the development of the more powerful version of the calculation views in SAP HANA Modeling.

Development Modules

SAP HANA 2.0 Deployment Infrastructure (HDI).

When you create or modify a calculation view with the SAP Web IDE for SAP HANA, you work on a Design Time object. The Design Time object is a file located in a HANA database (HDB) module of the current project. The project can contain several modules. A module contains files from the developer's workspace. Each file typically contains the definition of one database artifact, such as a calculation view.

To consume a calculation view, you must build (deploy) the design time file of the calculation view to generate a runtime object.

You choose "build" for one or several design time objects or for the entire module. Then, dependencies between these objects are checked, syntax checks are performed, and runtime objects are created. A calculation view is deployed as a column view. For each module, the system creates a dedicated HDI container, which is basically an isolated database schema.

To get started with modeling, you must first create a Project. Within your project, you then create a Module. There are a number of modules provided by SAP for each type of development object. Modelers usually only work with HDB (HANA Database) modules. Within a module, you develop source files of the type associated with the module. For example, in an HDB module, you create database artifacts.

When your module is built, you can add extra folders and subfolders to provide better organization of your content.

To create the various development artifacts and source files, you right-click a folder in your project and choose the type of file you want to create from the context menu.

As an example, if you were a modeler, you would work in an HDB module and create the following database artifacts:

  • Procedure

  • Function

  • Calculation View

  • Flowgraph

  • Analytic Privilege

  • CDS Artifact

  • Text Analysis dictionaries and rule sets.

You can also import individual artifacts into your project folders using the Import menu option. You can even import a complete project into your workspace.

Note

As projects are usually worked on by multiple developers, we recommend using Git to document and manage the source code versions. This tool is fully supported and integrated into SAP Web IDE for SAP HANA. A developer clones the current project from the shared Git repository into their SAP Web IDE for SAP HANA workspace. When they are done with development, they commit their source objects back to the shared Git repository with notes to describe what they changed.

Development in SAP Web IDE for SAP HANA is file-based, which means that each source artifact is a simple file (identified with an extension). The file is easy to export and import within, and also across SAP HANA.

Each file you create has its own extension, such as .hdbfunction or .hdbcalculationview, which makes it easy to identify its type. This is also how SAP Web IDE for SAP HANA knows which editor to open for each type of artifact. Certain file types can be opened in only a text editor or a graphical editor. Some files type can be opened in both.

To deploy a runtime object from the source object, we must execute a build. The generated built objects can be viewed in the Database Explorer View.

SAP Web IDE for SAP HANA

Modeling in SAP HANA is supported by a graphical browser-based interface with the name SAP Web IDE for SAP HANA.

You must obtain the URL from your administrator to be able to launch the SAP Web IDE for SAP HANA (For example, https://wdflbmt7211.wdf.sap.corp:53075). The URL includes the host and port where the SAP HANA database and the SAP Web IDE for SAP HANA is installed. Google Chrome is recommended as the browser. You need an SAP HANA logon with some privileges to get started. This is technically a different user from SAP BW/4HANA.

The Development view and the Database Explorer view are the main work environments in the SAP Web IDE for SAP HANA. You can toggle between these views using the buttons on the left of the interface.

SAP Web IDE for SAP HANA: Development View.

The Development view is used to develop and maintain customer objects like data models using either graphical or text-based editors. Here, you create the SAP HANA XSA artifacts such as calculation views or functions. You can identify the type of object from its file extension. Source artifacts are organized using folders.

To get started with modeling, you must first create a Project in the Development view of SAP Web IDE for SAP HANA. To support the isolation of the development environment, SAP Web IDE for SAP HANA allows developers to use dedicated spaces in XS Advanced for building and running their projects. A project must be assigned to a Space. Within your project you then create a Module to subdivide the development artifacts. There are several different types of modules provided by SAP to organize your development objects. Modelers usually only work with HDB (HANA Database) module type. Within a module, you develop source files that are allowed for the type of module. For example, in a HDB module you create database artifacts such as calculation views, procedures and functions.

Note

As projects are usually worked on by multiple developers, the use of Git to document and manage the source code versions is recommended. This tool is fully supported and integrated into SAP Web IDE for SAP HANA. A developer clones the current project from the shared Git repository into their SAP Web IDE for SAP HANA workspace. When the development is finished, they commit their source objects back to the shared Git repository with notes to describe what they changed.

Development in SAP Web IDE for SAP HANA is file-based, which means that each source artifact is a simple file (identified with an extension). The file is easy to export and import within, and also across SAP HANA.

Each file you create has its own extension, such as .hdbfunction or .hdbcalculationview, which makes it easy to identify its type. This is also how the SAP Web IDE for SAP HANA knows which editor to open for each type of artifact. Certain file types can be opened in only a text editor or a graphical editor. Some files type can be opened in both.

To generate a run-time object from the source file, we must execute a build. In SAP BW/4HANA, this is the equivalent of an Activation.

SAP Web IDE for SAP HANA: Database Explorer View.

The Database Explorer view of SAP Web IDE for SAP HANA is used to explore all types of catalog objects such as tables, views, procedures, and functions. The runtime objects that were created with the Development view can also be displayed here.

How To Add a Connection to the SAP HANA Database in SAP Web IDE for SAP HANA

To learn how to add a connection to the SAP HANA database in SAP Web IDE for SAP HANA, watch the following demo.

How to Import a Project to a Workspace in SAP Web IDE for SAP HANA and Check a Calculation View

To learn how to import a project to a workspace in SAP Web IDE for SAP HANA and check a calculation view, watch the following demo.

How To Assign a Project to a Space, Build the HDB Module and Grant External Access to it

To learn how to assign a project to a space, build the HDB Module and grant external access to it, watch the following demo.

Log in to track your progress & complete quizzes