Creating a Business Entity

You use business entities to build your consumption model for analysis and reporting.

Prerequisites

To create business entities, you must have a scoped role that grants you access to a space with the following privileges:
  • Data Warehouse General (-R------) - To access SAP Datasphere.

  • Data Warehouse Business Builder (CRUD----) - To create, edit, and delete Business Builder objects.

  • Data Warehouse Business Entity (CRUD----) - To create, edit, and delete Business Builder business entities.

  • Data Warehouse Data Builder (-R------) - To open Data Builder objects for linking to business entities.

  • Space Files (CRUD----) - To create, read, update, and delete objects in your spaces.

The DW Modeler role template, for example, grants these privileges. For more information, see Privileges and Permissions and Standard Roles Delivered with SAP Datasphere.

Views or tables have been created in the Data Builder.

Context

Business entities can define measures or attributes. Measures are quantifiable values that refer to an aggregable field of the underlying model. An attribute is a descriptive element of a business entity and provides meaningful business insights into measures. The underlying model is a view or a table, which has been created in the Data Builder.

In order to model a meaningful consumption model, business entities define associations between each other. All potential association targets can be pre-defined on the data layer in order to provide business users a variety of modeling options to choose from when preparing their use case-specific consumption model.

Business entities can be modeled as a dimension or as a fact. Dimensions are generally used to contain master data and must have a key defined. Facts are generally used to contain transactional data and must have at least one measure defined.

Procedure

  1. In the side navigation area, select (Business Builder), select a space if necessary, and select New Dimension or New Fact to open the editor.
  2. Select a source. You can use views or tables which have been created in the Data Builder as a source.
  3. Select the properties you want to copy from the source. You can copy attributes, measures, input parameters and key definitions.
  4. Enter a descriptive name to help users identify the object. This name can be changed at any time. By default, the name of the source is taken.
  5. A technical name is generated.
    To override the default technical name, enter a new one in the field. Technical names can contain only alphanumeric characters and underscores.
  6. [optional] Select the package to which the object belongs.
    Packages are used to group related objects in order to facilitate their transport between tenants. For more information, see Creating Packages to Export.
  7. Choose Public Data Access if you want to allow unrestricted access for this business entity.

    Keep in mind that in most cases data restrictions need to be applied. To do this, select an appropriate authorization scenario. More information: Authorization Scenario

  8. Define the version of your business entity. More information: Create Versions of an Object
  9. If you feel that you have chosen the wrong type for your purpose, you can still convert your dimension into a fact, or vice versa.
  10. Save your entries.
  11. Define the measures of your business entity. More information: Define Measures
  12. Define the attributes of your business entity. More information: Define Attributes
  13. Define the keys of your business entity. You need to define at least one unique key in order to use the business entity as a dimension later on. More information: Define a Key

    In case you have taken over the key definition from the source, you need to verify the uniqueness of your key. Go to the Key Definitions tab and choose Verify.

  14. Associate the dimensions. More information: Define Associations
  15. You can assign an authorization scenario, if you want to restrict the access to this business entity. More information: Assigning an Authorization Scenario
  16. You can check your business entity in the data preview. A data preview is only possible if the underlying object in the Data Builder is deployed.
  17. Once you are satisfied with the definition of your business entity, you can set the status of your version to Ready to Use. For more information on versions, see Create Versions of an Object.

Results

You can use your business entity in fact models and consumption models.