28CREATE TABLE &LIBREF..REPORTMART_AGGREGATION_CONFIG (
29 REPORTMART_GROUP_ID VARCHAR(32) label =
'Reportmart Group Identifier',
30 SCHEMA_NAME VARCHAR(100) label =
'Schema Name',
31 SCHEMA_VERSION VARCHAR(50) label =
'Schema Version',
32 MART_TABLE_NAME VARCHAR(100) label =
'Mart Table Name',
33 VAR_NAME VARCHAR(32) label =
'Variable Name',
34 VAR_SCOPE VARCHAR(32) label =
'Variable Role',
35 ALIAS VARCHAR(32) label =
'Aggregated Variable Name',
36 WEIGHT_VAR VARCHAR(32) label =
'Weight Variable',
37 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTMART_GROUP_ID, SCHEMA_NAME, SCHEMA_VERSION, MART_TABLE_NAME, VAR_NAME, VAR_SCOPE, ALIAS)