Application tables are used to aggregate statistical data that is collected based on multiple atomic metrics, derived metrics, or statistic granularities within the same periods in specific business scenarios. The statistical data can be used for subsequent business queries, online analytical processing (OLAP), and data distribution. This topic describes how to create an application table.

Prerequisites

  • A data layer is created. You can store tables that are used for the same purpose at the same data layer. This helps you easily find and use tables. In most cases, an application table is stored at the application data service (ADS) layer and aggregates statistical data collected based on multiple atomic metrics, derived metrics, or statistic granularities. A statistic granularity is a dimension or a set of dimensions. The statistical data can be used for subsequent business queries and data distribution. You can also store application tables at other data layers based on your business requirements.
  • A data mart or a subject area is created to determine the business scenario based on which you want to aggregate statistical data. For more information about how to create a data mart or a subject area, see Data mart and Subject area.
  • A period is created to determine the time range of which you want to aggregate statistical data. For more information, see Period.

Background information

An application table aggregates statistical data that is collected based on multiple atomic metrics or derived metrics in a data mart or a subject area by period and associated dimensions that you specified. The associated dimensions, periods, atomic metrics, and derived metrics are used to generate statistical fields in the application table to help you analyze and display data in reports. You can use an application table to display the status of your business based on the statistical data that is collected based on multiple atomic or derived metrics within the same periods and from the same dimensions.

Procedure

  1. Go to the Data Modeling page.
  2. Create an application table.
    1. On the Dimension Modeling page, move the pointer over the Plus sign icon and click Create Application Table.
    2. In the Basic Information section of the configuration tab that appears, configure basic information for the application table.
      Basic Information
      Parameter Description
      Data Layer The data layer at which the application table is stored. By default, the value of this parameter is set to ADS of the application layer category. You can also store the application table at another data layer based on your business requirements.
      Mart/Subject The data mart or subject area to which the application table belongs. For more information about data marts and subject areas, see Data mart and Subject area .
      Granularity The dimensions associated with the application table. For more information about dimensions, see Dimension management.
      Period The time range of statistical data that you want to aggregate. Examples: last day and last week.

      You can select a period from existing periods. If the existing periods do not meet your business requirements, you can create a period.

      Modifier The business scope of the statistical data that you want to aggregate.

      You can select one or more modifiers from the existing modifiers. If the existing modifiers do not meet your business requirements, you can create a modifier. For more information about how to create a modifier, see Modifier.

      Naming Rule The checker that is used to check whether the name of the application table conforms to the configured naming conventions. You can select the checker that you created for each data layer during data warehouse planning.
      Table Name The name of the application table.

      The name can contain lowercase letters, digits, and underscores (_), and must start with a lowercase letter.

      Display Name The display name of the application table.

      The display name can contain letters, digits, underscores (_), ampersands (&), and parentheses (). It must start with a letter or a digit. The display name can be a maximum of 256 characters in length.

      Lifecycle The lifecycle of the application table. Unit: day. The maximum value of this parameter is 36000.
      Description The description of the application table.
      Table Type The type of the application table. Valid values:
      • Common Application Table: This type of application table can be used to aggregate data only at a single granularity.
      • Light application table: This type of application table can be used to collect data at multiple granularities and aggregate data at different granularities.
  3. Click Save in the upper part of the configuration tab to save the basic information of the application table.

What to do next

After the application table is created, you must configure fields, associations, and partitions for the table, and publish the table to the required environment.