Dataphin:Step 5: Build a data model

Background information

Data modeling abstractly represents business processes through visualization, organizing objects and activities to enhance understanding and improvement of business operations. It also addresses information silos and data discrepancies from a data perspective. In Dataphin, the OneModel methodology categorizes the data modeling process into four distinct layers:

• Subject area modeling: Within the data mid-end, a subject represents a macro analysis domain, such as "sales" for sales analysis. A subject area is a collection of related subjects, with each industry comprising multiple subject areas (typically around 10).

• Conceptual modeling: This layer adds entities and their relationships within each subject area.

• Logical modeling: Attributes and constraints are defined for each entity based on the conceptual model.

• Business analysis modeling: This involves identifying key analysis methods and perspectives within the industry. Derived metrics and business filters are refined from the logical model to address specific business analysis challenges in Dataphin.

Step 1: Create a subject area

1. On the Dataphin home page, single click Planning in the top menu bar.

2. Follow the operation guide below, select the dataphin_tutorial data unit, and navigate to the Create Subject Area page.

   

3. On the Create Subject Area page, enter the required parameters.

   Parameter	Description
   Subject Area Name	Enter Transaction Domain.
   Code	Enter trade.
   Abbreviation	Enter trade.
   Parent Subject Area	Leave as empty.
   Description	Provide a brief description, such as Transaction Domain.

4. Click OK to confirm.

Step 2: Create a business object

1. On the Data Architecture page, use the operation guide below to access the Create Business Entity dialog box.

2. In the Create Business Entity dialog box, set the parameters as follows.

   Here's an example of creating a product business entity:

   Parameter	Description
   Entity Name	Enter Product.
   Code	Enter products.
   Entity Type	Set to Business Object/General Object by default.
   Data Domain	Select the Transaction Domain created earlier.
   Owner	Choose the owner from the list of Dataphin members.
   Description	Provide a brief description, such as Product Entity Business Object.
   Inherit from Entity	Leave as Empty by default.
   Associate Entity	Leave as Empty by default.

3. Once the business object information is configured, click OK.

   Note

   Note: After saving, the business object will be in the Unpublished status and cannot be referenced by logical dimension tables until published.

4. To publish the entity object, click the online button next to the entity, and then click OK.

Step 3: Create a business activity

1. On the Data Architecture page, use the operation guide below to access the Create Business Entity dialog box.

2. In the Create Business Entity dialog box, enter the following parameters.

   Parameter	Description
   Entity Name	Enter Order Purchase.
   Code	Enter order_buy.
   Entity Type	Select Business Activity/Business Event.
   Data Domain	Choose the Transaction Domain previously created.
   Owner	Select the Dataphin member who will own the business activity.
   Description	Provide a brief description, for instance, Order Purchase Business Activity.
   Associate Entity	Link the Product and Customer business entities created earlier.

3. Click OK to finalize the business activity creation.

4. Navigate to the Business Unit page, select the new business event, click the icon, and in the dialog box that appears, click OK to publish the event.

View the entity relationship diagram

After the creation of entity objects, including business objects and activities, click the icon next to the entity name to view its entity relationship diagram.