SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
reportmart_config.sas File Reference

The table REPORTMART_CONFIG contains details for storing data to the Report Mart. More...

Go to the source code of this file.

Detailed Description

The table REPORTMART_CONFIG contains details for storing data to the Report Mart.

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
WHERE_CLAUSE VARCHAR(10000) Where Clause Optional where condition applied when extracting the data from the Analysis Data Repository
CUSTOM_CODE VARCHAR(10000) Custom Code Optional custom code applied when extracting the data from the Analysis Data Repository. This code is executed within a data step.
RLS_TABLE_NAME VARCHAR(100) Y Row-Level Security Table Name Name of the table that controls row-level security
MART_TABLE_NAME VARCHAR(100) Y Mart Table Name Name of the target Report Mart table
AGGREGATION_FLG VARCHAR(1) N Aggregation Flag Flag (Y/N). Controls whether reportmart data should be aggregated
AGGREGATION_FILTER VARCHAR(32000) N Aggregation Filter Optional condition used to control which records should be aggregated

See irmc_node_load_reportmart.sas for details.

Author
SAS Institute Inc.
Date
2018

Definition in file reportmart_config.sas.