Skip to Content
Technical Articles
Author's profile photo Jonathan Francis

Using SAP BW bridge for Data Warehouse Cloud (Part 1: Creating Simple Objects – Demo)

Overview

This blog post is part of a series where we will be looking at a few simple use cases and basics when using SAP BW bridge for Data Warehouse Cloud. The purpose of this series is for you to have a walkthrough of how SAP BW bridge, SAP Data Warehouse Cloud, and SAP Analytics Cloud can work together.

In Part 1, we will be looking at creating simple objects from scratch in SAP BW bridge. These would be the same steps you would use if you were going for a greenfield implementation and building new models directly in SAP BW bridge.

When would I use this?

  • If I was rolling out a greenfield implementation with SAP BW bridge for SAP Data Warehouse Cloud
  • If I was using the Shell Conversion for SAP BW Bridge for SAP Data Warehouse Cloud but still needed to manually build objects that could not be transferred
  • If I had already used the Shell Conversion for SAP BW Bridge for SAP Data Warehouse Cloud and now have future enhancements or requirements to be built

 

Introduction to SAP BW bridge for Data Warehouse Cloud

SAP BW bridge is the latest feature to be released for SAP Data Warehouse Cloud. The main benefit is being able to leverage existing on-premise designs in SAP BW, while also having access to the latest cloud-based functionality in SAP Data Warehouse Cloud. For a detailed breakdown, please head over to the Overview and Technical Deep Dive blog post.

 


 

Pre-requisites

In the following section, we will be using SAP HANA Studio or Eclipse, with the SAP BW Bridge Project.

For a detailed walkthrough do check out our Getting Started with BW bridge video where we walk you through this setup.

 

As a brief reminder, you add a new project by:

    • Right-clicking on a blank space in your Project Explorer
    • Select New and Project
    • Select BW Bridge Project

SAP%20HANA%20Studio%3A%20BW%20Bridge%20Project

SAP HANA Studio: New Project

SAP%20HANA%20Studio%20%3A%20BW%20Bridge%20Project

SAP HANA Studio: BW Bridge Project

 

Once you have added your BW Bridge Project, let’s move on to creating objects.

 


 

Part 1: Creating Simple Objects in SAP BW bridge

We will run through how to create an InfoArea and an InfoObject.

Those of you who are familiar with modeling in SAP BW/4HANA using either Eclipse or SAP HANA Studio will feel quite at home since there is little to no change as we see below:

SAP%20HANA%20Studio%3A%20BW%20Bridge

SAP HANA Studio

 

A) Creating an InfoArea

Step 1: Creating a New InfoArea

First, you Right-click on your BW Repository and select “New” and “InfoArea

SAP HANA Studio: New InfoArea

 

Step 2: Naming the InfoArea

You then need to name your InfoArea. There are the usual pre-requisites like the BW Project and Package that need to be selected as well.

SAP HANA Studio: Naming InfoArea

 

Step 3: Assigning a Transport Request

Next, you need to either select an existing transport request or create a new transport request for your object.

SAP HANA Studio: Transport Request

 

Step 4: Saving and Activating

And finally, you select “Finish” for the object the be created in the background.

SAP HANA Studio: Saving & Activating

 

And here you see your activated InfoArea

SAP HANA Studio: Active InfoArea

 

InfoArea created! These are the same steps you would follow when modeling in SAP BW/4HANA as well.

 


 

B) Creating an InfoObject

Step 1: Creating a New InfoObject

First, you Right-click on your BW Repository and select “New” and “InfoObject

SAP HANA Studio: New InfoObject

 

Step 2: Naming the InfoObject

You then need to name your InfoObject. There are the usual pre-requisites like the BW Project, Package, and InfoArea that need to be selected as well before you select “Finish

SAP HANA Studio: Naming InfoObject

 

Step 3: Changing Properties

Next, you have the option of changing the properties of your InfoObject. As an example, you could still change the length, add Master Data and attributes, or even add Texts to load or maintain. This is because the object is still in an “Inactive” state as you can see below.

In this example, we will simply leave the standard selections.

SAP HANA Studio: InfoObject Properties

 

Step 4: Activating InfoObject

Finally, you activate your InfoObject by selecting “Activate” as seen below.

SAP HANA Studio: Activating InfoObject

 

Step 5: Active InfoObject

You can now see the InfoObject state has changed to “Active” as seen below

SAP HANA Studio: BW Bridge Project

 

InfoObject created! Again, these are the same steps you would follow when modeling in SAP BW/4HANA as well.

Do check out the demo in the next section where we walk you through the creation of a few more objects.

 


 

Demo

In the demo, we will be taking you through the steps for simple object creation in SAP BW bridge for Data Warehouse Cloud.

Thank you for making it this far. We look forward to bringing you Part 2.

 


As we mentioned in the overview, this blog post is part of a series. You can find the additional parts below:

Part 1: Creating Simple Objects Using SAP BW bridge for Data Warehouse Cloud (Demo)

Part 2: Combining Data from SAP BW bridge and Data Warehouse Cloud (Demo)

Part 3: Using SAP Analytics Cloud on top of SAP BW bridge and Data Warehouse Cloud (Demo)

Part 4: Using the Transfer Tool to migrate objects to SAP BW bridge and Data Warehouse Cloud

 

Do have a look at our additional articles for more information:

Introducing SAP BW bridge for Data Warehouse Cloud

SAP Data Warehouse Cloud, SAP BW bridge: Overview and Technical Deep Dive

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Balaji Vivekanandan
      Balaji Vivekanandan

      hi Jonathan,

      Thanks for this different series, most of the SAP products are moving into cloud, still HANA Studio and Eclipse able to access in cloud? Even Web IDE going to replace with BAS(Business Application Studio), can you please share the future direction of Modeling tools for BW,BW/4HANA and Data warehouse cloud, relevant examples and modeling tools in the new blog post will helpful for us to understand and explore in detail.

      Regards
      Balaji

      Author's profile photo Jonathan Francis
      Jonathan Francis
      Blog Post Author

      Hi Balaji,

      As you mentioned the future direction is definitely the cloud. However, even for something like SAP BW/4HANA hosted on SAP HANA Enterprise Cloud (HEC), we would still do the modeling on either HANA Studio or Eclipse.

      If we compare this to a few years ago we wouldn't be able to roll out entire projects solely with cloud-based modeling using tools like SAP Data Warehouse Cloud and SAP Analytics Cloud which require no software installed on your own machine.

      The point here is the future direction is clearly cloud-based tools and modeling however it is unlikely that local tools like SAP GUI, SAP HANA Studio, and Eclipse would completely disappear anytime soon.

      Hope that helps!