Views Overview

Views are a way to reimagine tables. Here, you will discover how to customize data for specific usage.
March 15, 2024

There are two types of views.

New SQL View

An SQL View lets you rewrite a dataset using SQL to create a new dataset.

This type of view can be created by selecting New SQL View.

SQL can be used to select complex datasets from multiple tables, for example:

A selection of columns with calculated columns

Join data from multiple tables with calculated columns

New Graphical View

A Graphical View allows users to create complex views without using SQL.

Tables and views can be dragged onto the main canvas.

Nodes will be displayed on the graphical canvas to show stages in the transformation.

The end node is always the View.

At each node, different operations can be performed to transform the data.


Filters filter data by values in the data set. For example, this filter will only show columns where the State ID is either TX or CA:

Rename/Exclude Columns

This lets you rename columns or exclude them from the end view.

Calculated Columns

This lets you create columns derived from data from the datasets.

View Properties

The view properties let you name the Business Name and the Technical Name of the view.

  • The Semantic Usage can be changed to reflect how the data in the view will be used. This can include:
    • Relational Dataset
    • Dimension
    • Text
    • Hierarchy
    • Fact
  • Exposure for Consumption: When turned on, will expose this view to external tools.
  • In the Column/Attribute setting, the column properties, like associations and semantic type, can be changed.
  • Data Persistence: Deployed views can persist a copy of the data, so it is stored in Datasphere.
  • Data Access Control: Let you apply row-level security to the data. This excludes data for specific end users.

Save and Deploy

  • Saving the table will add the table to the list in Data Builder.
  • Deploying the table will make it active, so its saved configuration can be used in other applications.
  • Data Viewer: Shows any data that is persistently stored within Datasphere.

Learning Path

Enroll Today!

This learning path would be a great starting place if you want to learn more about the topics covered in this article.

Learning Path Thumbnail


Next Article


Previous Article

See What's New

Featured Articles

Our most recent and proudest works, ready to make your life a little bit easier.

SAP Analytics Cloud

SAC Key Features & Capabilities

Let’s learn about the key features and capabilities of SAP Analytics Cloud.


Creating a Space

Spaces are the areas where all data is retrieved, prepared and modeled. This article will walk you through creating a space in Datasphere.

SAP Analytics Cloud

Adding a Table (Datasphere Dataset)

Learn how to insert a table based on an existing SAP Datasphere dataset.

Curated For You

Article Recommendations

Here are some articles handpicked by our experts to help you continue your learning journey.


Creating a Space

Spaces are the areas where all data is retrieved, prepared and modeled. This article will walk you through creating a space in Datasphere.


Importing Remote Tables

Tables can be directly generated from external data sources by importing a remote table.


Tables Overview

Tables are the lowest level of data configuration in Data Builder. Here we will describe what they are for and when they are used.

Contact Us

Reach out if you have any questions or to see how we can create a custom training solution for your organization!

Contact Form Pop-Up - General Use

Custom Training Solution

Fill out and submit the form below, and we’ll reach out to you to discuss how we can work toward achieving your training goals in a way that works best for you and your team.

Contact Form - Custom Training