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
- Go to the Data Modeling page.
- Create an application table.
- Click Save in the upper part of the configuration tab to save the basic information of the application table.