Initial Steps of Modeling in SAP Datasphere
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 apply:
- 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. You can expose views directly to SAP Analytics Cloud and other analytics clients.
- The SAP Datasphere Business Layer enables users to create their own business models on top based on business terms. The SAP Datasphere Business Builder provides the related set of tools. The Business Builder can consume Data Builder objects for further modeling and consumption. As a more semantic approach, business users create their models using the Business Builder editors. They combine, refine, and enrich the SAP Datasphere Data Builder artifacts with further semantic information before exposing lightweight, tightly-focused objects. SAP Analytics Cloud and other analytic clients consume these objects.
Data Builder Artifact Types
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 and join them as appropriate. You can add other operators to remove or create columns and filter or aggregate data. You can also specify measures and other aspects of your output structure in the output node.
You can preview the data contained in your tables and views. When working in the graphical view editor, you can also preview 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, other analytic clients, and in ETL and other tools. You can only access views that have the Expose for Consumption switch enabled outside the space. SAP Analytics Cloud can access dimensions and other entities to which your Analytical Dataset points through associations, even if they have not been exposed. Other analytics clients can consume views of any type that have the Expose for Consumption switch enabled.