![SAP BW on HANA Tutorial](/sap_bw_on_hana/images/sap-bw-on-hana-mini-logo.jpg)
- SAP BW on HANA Tutorial
- SAP BW on HANA - Home
- SAP BW on HANA - Overview
- SAP BW Basics
- SAP HANA Basics
- SAP BW on HANA - Architecture
- SAP BW on HANA - Benefits
- Native HANA Modeling
- BW Data Warehousing
- BW Database Version
- SAP BW on HANA - Modeling Tools
- SAP BW on HANA - Migration
- SAP BW on HANA - Migration Tools
- SAP BW on HANA - Data Mngmt
- HANA Optimized InfoCubes
- Composite Providers
- Composite Providers in HANA
- SAP BW on HANA - Advanced DSOs
- SAP BW on HANA - Hybrid Modeling
- HANA Views for BW InfoProviders
- SAP BW on HANA - HANA Live
- Data Provisioning
- SLT Replication HANA
- SLT Replication BW
- DB Connect
- HANA View for InfoCube
- SAP BW on HANA - Process Chain
- HANA vs BWA
- SAP BW on HANA - Authorization
- Consultant Responsibilities
- SAP BW on HANA Useful Resources
- SAP BW on HANA - Quick Guide
- SAP BW on HANA - Useful Resources
- SAP BW on HANA - Discussion
SAP BW on HANA - Modeling Tools
You can install BW Modeling tools on your system - SAP GUI, SAP HANA Studio. To install BW modeling 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.
![Create new BW Project](/sap_bw_on_hana/images/create_new_bw_project.jpg)
Select BW Modeling → Click OK as shown in the following screenshot.
![Select BW Modeling](/sap_bw_on_hana/images/select_bw_modeling.jpg)
Next go to File → New → Project.
![Go to File](/sap_bw_on_hana/images/go_to_file.jpg)
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. Click Ok.
![SAP Logon](/sap_bw_on_hana/images/sap_logon.jpg)
In the next screen, as shown in the following screenshot enter client, username and password. Click Next.
![Enter Authentications](/sap_bw_on_hana/images/enter_authentications.jpg)
You can enter the project name and click Finish.
![Enter Project Name](/sap_bw_on_hana/images/enter_project_name.jpg)
Now, right-click on your new root project folder and choose Attach SAP HANA System. Choose the preconfigured HANA system HDB and click Finish.
![Click Finish](/sap_bw_on_hana/images/click_finish.jpg)
Only connected SAP HANA system can be attached. Select HANA system → Finish.
![Select HANA System](/sap_bw_on_hana/images/select_hana_system.jpg)
To define a BW query on your InfoCube, select the InfoCube in BW Modeling Perspective, right-click and click New → BW Query and select the InfoProvider.
![Define BW Query](/sap_bw_on_hana/images/define_bw_query.jpg)
Enter the name and description and click Finish. This is how you can add a BW query.
![Enter Name and Description](/sap_bw_on_hana/images/enter_name_and_description.jpg)
You can apply different functions in BW query. You can apply filters, define local formulas for calculation, etc.
![Apply Different Functions](/sap_bw_on_hana/images/apply_different_functions.jpg)
To save a BW query, click the save icon.
![Save BW Query](/sap_bw_on_hana/images/save_bw_query.jpg)
To preview your BW query, click the BW Reporting Preview in HANA Studio.
![Preview BW Query](/sap_bw_on_hana/images/preview_bw_query.jpg)
To Continue Learning Please Login