SAP BW on HANA - Modepng Tools

You can install BW Modepng tools on your system - SAP GUI, SAP HANA Studio. To install BW modepng tools, you need the following components −

Operating System Windows 7 or Windows 8 or Apple Mac OS X 10.8 or higher, or Linux distribution.

Internet Explorer 7.0 or higher or Firefox 4.0 or higher has to be installed.

SAP GUI for Windows 7.3 or SAP GUI for Windows 7.4 has to be installed on your local drive. You can download this from SAP Marketplace.

To communicate with the backend system, you need Microsoft Runtime DLLs VS2010 (for Windows OS) is installed on your local system.

SAP HANA Studio (32-Bit or 64-Bit for Windows) SP08 or higher.

Create a New BW Project in HANA Studio

Open SAP HANA Studio and create a new project. Go to Windows → Open Perspective → Other.

Select BW Modepng → Cpck OK as shown in the following screenshot.

Next go to File → New → Project.

In the next window, select SAP connection. You can select an existing connection or define a connection manually to add a new connection.

System connections are maintained in the SAP Logon. Cpck Ok.

In the next screen, as shown in the following screenshot enter cpent, username and password. Cpck Next.

You can enter the project name and cpck Finish.

Now, right-cpck on your new root project folder and choose Attach SAP HANA System. Choose the preconfigured HANA system HDB and cpck Finish.

Only connected SAP HANA system can be attached. Select HANA system → Finish.

To define a BW query on your InfoCube, select the InfoCube in BW Modepng Perspective, right-cpck and cpck New → BW Query and select the InfoProvider.

Enter the name and description and cpck Finish. This is how you can add a BW query.

You can apply different functions in BW query. You can apply filters, define local formulas for calculation, etc.

To save a BW query, cpck the save icon.

To preview your BW query, cpck the BW Reporting Preview in HANA Studio.