7.2 Configuring STSA tables for Reports

After installing the application some STSA tables are created. To view the reports in BI, ensure that you fill the following tables:
  1. EST_RESULTS_DIM_MAP
  2. EST_RESULTS_DIM_VIEW_DETAILS

Note:

You can add maximum of ten dimensions to view the stress reports in BI.
  1. Fill the details in the EST_RESULTS_DIM_MAP table.

    Table 7-3 Details about EST_RESULTS_DIM_MAP table

    Column Name Description Example Comments
    V_EST_RESULTS_DIM_KEY List the dimensions that you want to view in the reports. N_DIM1_SKEY You can list a maximum of 10 dimensions in this column.

    Ensure that the first five dimensions are simple dimensions and their format is: N_DIM1_SKEY, N_DIM2_SKEY to N_DIM5_SKEY.

    The next five dimensions are level-based dimensions. And their format is: N_DIM6_SKEY, N_DIM2_SKEY to N_DIM10_SKEY.

    V_DIM_TABLE_NAME List the dimension table names that are required for viewing in reports. DIM_INDUSTRY  
    V_DIM_COLUMN_NAME List the specific column names of the dimension table for viewing in reports. N_D_CUST_INDUSTRY_SKEY  
    V_LOGICAL_NAME List the logical name of the dimension that will be displayed as a dimension filter in the BI. Industry  
  2. Fill various details of each dimension in the EST_RESULTS_DIM_VIEW_DETAILS table.

    Table 7-4 Details about EST_RESULTS_DIM_VIEW_DETAILS table

    Column Name Column Description Example Value Comments
    V_EST_RESULTS_DIM_COLUMN This is the dimension column name. N_DIM4_SKEY  
    V_VIEW_NAME This is a parameter for reports. DIM_BI_PH_04  
    V_VIEW_COLUMN_NAME Each value represents an unique identifier for the dimension. For report generation, the skey, description, name, code and LRI is required. Hence the table is populated by defining these parameters for each dimension. DIM_BI_PH_04_SKEY Provide these values: DIM_BI_PLC_09_DIM_HCY_LEVEL_NAME_1, DIM_BI_PLC_09_DIM_HCY_LEVEL_CD_1, and DIM_BI_PLC_09_DIM_HCY_LEVEL_DISPLAY_ORDER_1
    V_VIEW_COLUMN_VALUES Provide the unique value for each dimension. N_PROD_TYPE_SKEY  
    V_LOGICAL_COLUMN_NAMES Provide the logical name for the column. (null)  
  3. To initiate the table view creation after this configuration or any change in the configuration, run the following command:
    EXECUTE VIEW_CREATION_PROCEDURE;