Create a Dimension in the Business Builder

1. In SAP Datasphere, click on the Business Builder icon.

2. Then, click on New Dimension.

3. Select the data entity you wish to use in this dataset. Either click on the entity you want to use, or search for it by using the search field on top of the pop-up window.

   

4. The Business Name and Technical Name fields will be automatically filled-out for you, but you can make changes if needed.

5. Click on Create.

6. Finally, a pop-up will ask you if you want to copy the properties of the data entity or not.

   

7. After you make your selection, click on Create.

Now it’s time to add attributes to your dimension.

1. Click on Attributes on the top menu.

2. To add existing measures, click on the Add Source Attributes button.

   

3. A pop-up will open to show you the attributes available in the source data. Check all the attributes you wish to include. Then click on Apply.

Your existing attributes are now available in the dimension.

1. To add a new attribute, click on the New Attribute button.

2. Now you can enter the details of the new measure, including:

   • Business Name

   • Technical Name

   • Attribute Type

   • Source Attribute

   • Use Identifier

   • Auxiliary attribute

   Please note that the technical name of your new attribute must be unique, even though new attributes can be based on existing attributes available on the source data.

3. Click on Save to save your new attribute.

Your new attribute is now available in the dimension.

You are almost done creating a dimension. Before you move on to another task, it’s important to preview your data and make sure you have the right dataset.

Just click on the Data Preview link on the top right-hand corner of the screen.

Now you can see the preview, as well as adjust it by using the sidebar on the left of the screen. You can add measures and attributes to the perspective or remove them. You can also hide fields that are in the perspective according to your needs.

Well done!

You have completed the second tutorial of this group! Now you know how to create a dimension in the Business Builder of SAP Datasphere.

Learn in the next tutorial how to create a fact model in the Business Builder .