Create a logical aggregate table

Prerequisites

Make sure 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 table name is the business object's object encoding joined with the timeliness suffix (_dd/_hh/_mm) by an underscore (_). You can modify this name. Supports letters, numbers, or underscores (_), up to 110 characters.
   Description	Enter a 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.

• Create derived metrics.

• Create registered attached metrics.