Modeling Data
Users with a modeler role can add semantic information to their entities and combine, refine, and enrich them in tightly-focused analytic models for consumption in SAP Analytics Cloud, Microsoft Excel, and other clients, apps, and tools.
Model Facts, Dimensions, Texts, and Hierarchies
-
Select a Semantic Usage of Fact to indicate that your entity contains numerical measures that can be analyzed.
In our example, Acme Sales View is a fact containing sales data.
-
Select a Semantic Usage of Dimension to indicate that your entity contains attributes that can be used to analyze and categorize measures defined in other entities.
In our example, four dimensions surround the fact, allowing us to analyze it by Salespeople, Time, Product, and Geo attributes.
-
Select a Semantic Usage of Text to indicate that your entity contains strings with language identifiers to translate text attributes in other entities.
In our example, there are four translation entities to translate time and product dimension attributes.
-
Select a Semantic Usage of Hierarchy to indicate that your entity contains parent-child relationships for members in a dimension.
In our example, the Acme Salespeople Hierarchy provides a hierarchy for the Salespeople dimension.
Identify Measures to Analyze in a Fact
-
To get started: Select a Semantic Usage of Fact to indicate that your entity contains numerical measures that can be analyzed.
-
You must identify at least one measure (see Specify Measures to Analyze).
-
You can create associations to dimensions and text entities (see Create an Association to Define a Semantic Relationship Between Entities).
-
To expose your data for consumption in SAP Analytics Cloud, add it to an analytic model (see Creating an Analytic Model).
Prepare Master Data for Grouping in a Dimension
-
To get started: Select a Semantic Usage of Dimension to indicate that your entity contains attributes that can be used to analyze and categorize measures defined in other entities.
-
You must set at least one key column (see Set Key Columns to Uniquely Identify Records).
-
You can create associations to other dimensions, text entities, and hierarchies (see Create an Association to Define a Semantic Relationship Between Entities).
-
You can add parent-child or level-based hierarchies to support drill-down (see Add a Hierarchy to a Dimension).
-
You can make your dimension time-dependent, so that its members can change over time (see Enable Time-Dependency for a Dimension or Text Entity).
Support Translations of Attributes with a Text Entity
-
To get started: Select a Semantic Usage of Text to indicate that your entity contains strings with language identifiers to translate text attributes in other entities.
-
You must specify attributes and keys to uniquely identify a master data member and a language.
-
You can make your text entity time-dependent, so that the texts it contains can change over time (see Enable Time-Dependency for a Dimension or Text Entity).
Enable Drill-Down with a Hierarchy
-
To get started: Select a Semantic Usage of Hierarchy to indicate that your entity contains parent-child relationships for members in a dimension.
-
You must specify the parent and child attributes and set the child attribute as a key.
Create Heterogeneous Hierarchies with a Hierarchy with Directory
A hierarchy with directory is an entity that contains one or more parent-child hierarchies and has an association to a directory dimension containing a list of the hierarchies. These types of hierarchy entities can include nodes from multiple dimensions (for example, country, cost center group, and cost center) and are commonly imported from SAP S/4HANA Cloud and SAP BW systems (see Create a Hierarchy with Directory).
Combine Entities for Consumption in an Analytic Model
-
To get started: In the side navigation area, select (Data Builder), select a space if necessary, and select New Analytic Model to open the editor.
-
You must add a fact as a source and can choose to copy all its measures, attributes and associated dimensions to the analytic model (see Add a Fact to an Analytic Model).
-
You can deselect measures and attributes to leave only those that are relevant to answer your particular analytic question.
-
You can create additional calculated and restricted measures (see Create a Measure in an Analytic Model).
-
You can create multiple tightly-focused analytic models from a single fact, each providing only the data needed for a particular BI context, and enriched with appropriate variables, filters, and additional measures as necessary.
Expose Data Outside SAP Datasphere
|
Object |
SAP Analytics Cloud |
Microsoft Excel |
Other Clients, Tools, and Apps |
|---|---|---|---|
|
Analytic models (see Creating an Analytic Model) Exposed: Automatically |
Live Connection |
Live Connection (via an SAP Add-In) |
OData |
|
Perspectives (see Define Perspectives) Exposed: Automatically |
Live Connection |
Live Connection (via an SAP Add-In) |
- |
|
Views* (see Exposing Data For Consumption) Exposed: When the Expose for Consumption switch is enabled |
OData** |
- |
OData ODBC/JDBC |
|
For more information, see: |
* The workflow of consuming views with a semantic usage of Analytical Dataset in SAP Analytics Cloud and Microsoft Excel via live connection is now deprecated. We recommend that you migrate your analytical datasets to the new Fact semantic usage and expose your view data via analytic models (see Analytical Datasets (Deprecated)).
** SAP Analytics Cloud primarily uses the consumption of view data via OData for planning (see Integrate with SAP Analytics Cloud for Planning).
Create Objects and Act On Existing Objects
-
Click one of the tabs to filter the list by object type.
-
Click a tile to create a new object
-
Click to filter the list on collections and search by criteria. Click Show More to open a dialog with additional filter options.
-
Enter one or more characters in the Search field and press Enter (or click Search).
-
If you've searched for objects before, clicking in the search field shows a list of recently entered searches. As you type, the field will begin proposing objects and search strings. Select an object to open it directly. Click on a string to start a search on it.
-
The search is case-insensitive and automatically applies wildcards so that, for example, the string "lend" will find objects containing both "lender" and "calendar".
-
If natural language search is enabled on your tenant (and you have the appropriate role), the search field will propose example natural language strings that are appropriate to your current filter context. Select an example string or enter your own and SAP Datasphere will interpret it and filter your results accordingly. See Natural Language Search.
-
-
Click a column header to sort or filter the list by values in the column.
-
Select one or more objects and use any of the following tools:
Tool
Description
New
Create Data Builder objects (independent of any selection).
Import
Import objects from files and connections:
-
Import CSV File - Import data from a CSV file to create a local table (see Creating a Local Table from a CSV File.
-
Import Objects from CSN/JSON File - Import table, view, and other object definitions from a CSN/JSON file (see Importing Objects from a CSN/JSON File).
-
Import Remote Tables - Import remote tables from a connection (see Import Remote Tables).
-
Import Permissions - Import analysis authorizations from SAP BW and and SAP BW∕4HANA systems to create data access controls (see Import SAP BW and SAP BW∕4HANA Analysis Authorizations).
Edit
Open the selected object in the appropriate editor. Alternatively, click the object directly in the list.
Deploy
Select one or more objects and deploy them together.
Choose from the following entity types:-
Local tables (see Creating a Local Table)
-
Graphical views (see Creating a Graphical View)
-
SQL views (see Creating an SQL View)
-
Data access controls (see Securing Data with Data Access Controls)
-
Analytic models (see Creating an Analytic Model)
-
Task chains (see Creating a Task Chain)
If one or more objects that you have selected cannot be deployed, the Deploy dialog opens, allowing you to review your selection. Click Deploy to deploy those objects listed on the Deployable tab, or Cancel to go back and alter your selection.
Share
Share the selected tables and views to other spaces (see Sharing Entities and Task Chains to Other Spaces).
Impact and Lineage Analysis
View the objects that depend on the selected object, and those objects on which it depends (see Impact and Lineage Analysis).
Delete
Delete the selected objects (see Deleting Objects).
-