SAP HANA BI Development - Design Studio


SAP Design Studio provides predefined templates that can be used to create new Analysis applications. These predefined templates are suitable to open in Web browsers or mobile platforms.

How to Create a New Analysis Application?

To create a new analysis application, navigate to Application → New.

New Analysis Application

In the next window, enter the Name of the application and Description. You can select the Template category.

Template Category

SAP Design Studio also provides you the brief description of each template with the template name. Select the template and click the Finish button.

SAP Design Studio

To create a dashboard, navigate to the Components view tab. Select any component from the list of available objects, and drag the component of your choice into the editor area.

Editor Area

The properties of this component are available for editing under the Properties view. In the Properties view, click the property you want to change. A field can have different values as per the following types −

To add data to your chart, navigate to Data Binding and select a data source from the list.

Data Binding

Similarly, you can define other properties of your chart. Following properties can be defined −

Once you assign a data source and manage chart properties, you can save the application by clicking the Save button at the top.

Connecting to a Universe Based on HANA

You can also connect to a Universe in Design Studio, which is based on SAP HANA views and tables. To connect to a Universe Data Source (UDS), go to the Data Source folder under Outline in a new analysis application → Right click → Add Data Source.

UDS

Let us see how to add a Universe as a data source. Click the Browse tab against Connection in the Add Data Source window.

Data Source Window

Once you select a Universe, edit the query panel. Click the Edit Query specification. Add the dimensions and measures to result objects. You can expand each of these folders in the left pane and add objects to dimensions and measures.

Query

You can add this data source to chart components or you can also go to Edit Initial View of data source and select Create Crosstab.

Create Crosstab

A Crosstab has been added to the editor area and this is how you can connect to the Universe based on SAP HANA views or tables.