SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
reportmart_config.sas
Go to the documentation of this file.
1/* Copyright (C) 2018 SAS Institute Inc. Cary, NC, USA */
2
3/*!
4\file
5\anchor reportmart_config
6\brief The table REPORTMART_CONFIG contains details for storing data to the Report Mart.
7
8 | PK | Variable | Type | Required? | Label | Description |
9 |--------------|----------------------------|----------------|------------|--------------------------------|------------------------------------------------------------------------------------------------------------------------------------------|
10 | ![ ](pk.jpg) | <b>REPORTMART_GROUP_ID</b> | VARCHAR(32) | Y | Reportmart Group Identifier | Reportmart Group Identifier |
11 | ![ ](pk.jpg) | <b>SCHEMA_NAME</b> | VARCHAR(100) | Y | Schema Name | Schema Name |
12 | ![ ](pk.jpg) | <b>SCHEMA_VERSION</b> | VARCHAR(50) | Y | Schema Version | Schema Version |
13 | | WHERE_CLAUSE | VARCHAR(10000) | | Where Clause | Optional where condition applied when extracting the data from the Analysis Data Repository |
14 | | 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. |
15 | | RLS_TABLE_NAME | VARCHAR(100) | Y | Row-Level Security Table Name | Name of the table that controls row-level security |
16 | ![ ](pk.jpg) | <b>MART_TABLE_NAME</b> | VARCHAR(100) | Y | Mart Table Name | Name of the target Report Mart table |
17 | | AGGREGATION_FLG | VARCHAR(1) | N | Aggregation Flag | Flag (Y/N). Controls whether reportmart data should be aggregated |
18 | | AGGREGATION_FILTER | VARCHAR(32000) | N | Aggregation Filter | Optional condition used to control which records should be aggregated |
19
20\details
21
22 See \link irmc_node_load_reportmart.sas \endlink for details.
23
24\ingroup ddlStaticAnalytics
25\author SAS Institute Inc.
26\date 2018
27*/
28
29CREATE TABLE &LIBREF..REPORTMART_CONFIG (
30 REPORTMART_GROUP_ID VARCHAR(32) label = 'Reportmart Group Identifier',
31 SCHEMA_NAME VARCHAR(100) label = 'Schema Name',
32 SCHEMA_VERSION VARCHAR(50) label = 'Schema Version',
33 WHERE_CLAUSE VARCHAR(10000) label = 'Where Clause',
34 CUSTOM_CODE VARCHAR(10000) label = 'Custom Code',
35 RLS_TABLE_NAME VARCHAR(100) label = 'Visibility Table Name',
36 MART_TABLE_NAME VARCHAR(100) label = 'Mart Table Name',
37 AGGREGATION_FLG VARCHAR(1) label = 'Aggregation Flag',
38 AGGREGATION_FILTER VARCHAR(32000) label = 'Aggregation Filter',
39 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTMART_GROUP_ID, SCHEMA_NAME, SCHEMA_VERSION, MART_TABLE_NAME)
40);