Using SAP BW bridge for SAP Datasphere (Part 1: Creating Simple Objects – Demo)
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 SAP Datasphere. The purpose of this series is for you to have a walkthrough of how SAP BW bridge, SAP Datasphere, 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 Datasphere
- If I was using the Shell Conversion for SAP BW Bridge for SAP Datasphere 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 Datasphere and now have future enhancements or requirements to be built
Introduction to SAP BW bridge for SAP Datasphere
SAP BW bridge is the latest feature to be released for SAP Datasphere. 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 Datasphere. For a detailed breakdown, please head over to the Overview and Technical Deep Dive blog post.
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
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 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.
In the demo, we will be taking you through the steps for simple object creation in SAP BW bridge for SAP Datasphere.
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 SAP Datasphere (Demo)
Part 2: Combining Data from SAP BW bridge and SAP Datasphere (Demo)
Part 3: Using SAP Analytics Cloud on top of SAP BW bridge and SAP Datasphere (Demo)
Part 4: Using the Transfer Tool to migrate objects to SAP BW bridge and SAP Datasphere
Do have a look at our additional articles for more information:
Introducing SAP BW bridge for SAP Datasphere
SAP Datasphere, SAP BW bridge: Overview and Technical Deep Dive
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.
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!