Create a logical aggregate table

Prerequisites

Before performing this operation, ensure you have created a logical table for the business object. For more information, see Logical dimension table.

Procedure

1. In the top menu bar of the Dataphin homepage, select Development > Data Development.

2. In the top menu bar, select a project (in Dev-Prod mode, you need to select an environment).

3. In the navigation pane on the left, select Standardized Modeling > Logical Summary Table.

4. In the logical aggregate table list, click the icon to open the Create Logical Aggregate Table dialog box.

5. In the Create Logical Aggregate Table dialog box, configure the parameters.

   Parameter	Description
   Statistic Timeliness	Supports Day (T+1), Hour (T+h), or Minute (T+m), with Day as the default.
   Statistic Granularity	You can select business objects corresponding to all Published logical tables in the current module. Note If a logical aggregate table already exists for the selected statistic granularity, you cannot create another one.
   Table Name	By default, the system uses an underscore (_) to connect the selected business object's object encoding and timeliness (_dd/_hh/_mm) as the table name. You can edit and modify this name. Supports letters, numbers, or underscores (_), up to 110 characters.
   Description	Enter a basic description of the logical table.

6. Click OK.

What to do next

After creating the logical aggregate table, you can add derived metrics, derived indicators, or attach registered metrics to it. For more information, see

• Create derived metrics.

• Create registered attached metrics.