Introducing Data Modeling in the Data Builder

SAP Datasphere offers multiple modeling capabilities that address different user groups – from Business Analysts with deep business understanding to tech-savvy Developers and Power users. In a typical end-to-end scenario, two closely related components of SAP Datasphere are applied:

• The SAP Datasphere Data Layer contains the basic modeling of the underlying data sources and tables. The related set of tools is available in the SAP Datasphere Data Builder. Here, developers and modelers use tables, views and intelligent lookups to combine, clean, and prepare data. Views can be exposed directly to SAP Analytics Cloud and other analytics clients.
• The SAP Datasphere Business Layer allows users to create their own business models on top based on business terms. The related set of tools is provided by the SAP Datasphere Business Builder. Data Builder objects can be consumed by the Business Builder for further modeling and consumption. Business users use the Business Builder editors to create their models using a more semantic approach. They combine, refine, and enrich the SAP Datasphere Data Builder artifacts with further semantic information before exposing lightweight, tightly-focused objects for consumption by SAP Analytics Cloud and other analytic clients.

SAP Datasphere provides an editor to model Data Builder artifacts in an intuitive graphical interface. You can drag and drop sources from the Source Browser, join them as appropriate, add other operators to remove or create columns and filter or aggregate data, and specify measures and other aspects of your output structure in the output node.

It is possible to preview the data contained in your tables and views and, when working in the graphical view editor, the data output by each of the nodes in the diagram.

SAP Datasphere provides various methods for importing tables or database views into your space:

• Data Builder start page - Use the import wizard to import remote tables from any connection.
• E/R Model - Import tables into the space and add them to the E/R model diagram.
• Graphical or SQL view - Import tables into the space and use them directly as sources in the view.

Enable the "Expose for Consumption" switch (Reporting Layer) to make a view available for consumption in SAP Analytics Cloud and other analytic clients and in ETL and other tools. Only views that have the "Expose for Consumption" switch enabled can be accessed outside the space. SAP Analytics Cloud can access dimensions and other entities to which your analytical dataset points via associations, even if they have not themselves been exposed. Other analytics clients can consume views of any type that have the "Expose for Consumption" switch enabled.