The table REPORTMART_AGGREGATION_CONFIG controls how reportmart data should be aggregated when loading to LASR. More...
Go to the source code of this file.
The table REPORTMART_AGGREGATION_CONFIG controls how reportmart data should be aggregated when loading to LASR.
PK | Variable | Type | Required? | Label | Description |
---|---|---|---|---|---|
![]() | REPORTMART_GROUP_ID | VARCHAR(32) | Y | Reportmart Group Identifier | Reportmart Group Identifier |
![]() | SCHEMA_NAME | VARCHAR(100) | Y | Schema Name | Schema Name |
![]() | SCHEMA_VERSION | VARCHAR(50) | Y | Schema Version | Schema Version |
![]() | MART_TABLE_NAME | VARCHAR(100) | Y | Mart Table Name | Name of the target Report Mart table |
![]() | VAR_NAME | VARCHAR(32) | Y | Variable Name | Name of the variable involved in the aggregation |
![]() | VAR_SCOPE | VARCHAR(32) | Y | Variable Role | The role of the variable in the aggregation: - GROUP_BY: Group-by variable - COUNT: Row Count - DISTINCT: Distinct Count - MIN: Minimum - MEAN: Average - MAX: Maximum - SUM: Simple Sum - WSUM: Weighted Sum |
![]() | ALIAS | VARCHAR(32) | Y | Aggregated Variable Name | Name given to the aggregated variable |
WEIGHT_VAR | VARCHAR(32) | N | Weight Variable | Name of the weight variable. Relevant when VAR_SCOPE = "WSUM" |
See irmc_node_load_reportmart.sas for details.
Definition in file reportmart_aggregation_config.sas.