partition node, prepares the input/configuration tables for aggregation More...
Go to the source code of this file.
partition node, prepares the input/configuration tables for aggregation
[in] | ST_PRM.RUN_OPTION | parameter table |
[in] | %ds_in_bep_summary | = ST_STG.BEP_SUMMARY Input table containing a list of the Business Evolution Plans associated with this Analysis Run |
[in] | %ds_in_bep_details | = ST_STG.BEP_DETAILS Input table containing details of the Business Evolution Plans associated with this Analysis Run |
[in] | %ds_in_agg_rules_config | = ST_CFG.AGGREGATION_RULES_CONFIG Contains the rules for aggregating the credit risk detail results |
[in] | %ds_in_bsp_data_config | = ST_CFG.BSP_DATA_CONFIG Contains information on the source table and scenario name |
[out] | %ds_out_agg_rules_config | = P_ST_STG.AGGREGATION_RULES_CONFIG Output table containing the aggregation rules filtered to include only those with a schema name/version matching the planning data in the BSP summary |
[out] | %ds_out_credit_risk_detail | = P_ST_STG.AGG_SRC_TBL Output table containing the results from the source tbl filtered by scenario and only including variables needed for aggregation |
[out] | %ds_out_bsp_data_config | = P_ST_STG.BSP_DATA_CONFIG Contains information on the source table and scenario name filtered by source. |
This node filters the aggregation rules configuration table based on the planning data schemas found in the BSP summary table. It also retrieves the source data from the provided instance key and filters by scenario, only keeping the variables needed based on the aggregation rules configuration table. The table bsp_data_config is partitioned to include only one source per partition.
In addition the following macro utilities are called:
Macro name | Description | Further information |
---|---|---|
irm_session_prepare | Reads RUN_OPTION table and sets logging options | irm_session_prepare.sas |
irm_session_cleanup | Removes all non-IRM WORK datasets/views and deletes all user-created macro variables from workspace session | irm_session_cleanup.sas |
irmst_fltr_src_agg_tbl | Filters the source table by scenario name | irmst_fltr_src_agg_tbl.sas |
Definition in file irmst_node_prep_agg_tables.sas.