The Master File commands in the Stratum.Server application create, load, and maintain Master File tables in the Stratum storage database for use with Stratum.Connector for Viewer.
Master File information is not required for all dimension values in the Stratum.Planner product. That means in Stratum.Planner there may be instances when there is no corresponding Master File information for the dimension values in Stratum warehouse tables. On the other hand, Master File information is required for all dimension values for the sake of the Stratum.Connector for Viewer product. Master File information is needed to process data into the Analysis Services format. Running the Master File commands ensures that Master File information exists for all dimension values by creating a set of tables to be used by Stratum.Connector for Viewer with this information
The tasks for running Master File commands only need to be performed once and they need to be run prior to the first use of Stratum.Connector for Viewer. See Run Master File Commands for instructions.
Note: You must be on the version of Stratum.Server recommended in the Stratum.Viewer and Stratum.Connector for Viewer Requirements.
Running the Master File commands creates a set of MASTERxx and MASTxx tables for all dimension values in the Stratum Structure Codes. The xx in the MASTxx and MASTERxx table names represents the dimension number. For example, tables for Dimension 1 would be named MAST1 and MASTER1, and tables for Dimension 10 would be MAST10 and MASTER10.
For each dimension, the MASTERxx tables store the dimension value information that exists for all years of data in all Structure Code tables of the Stratum storage database.
The MASTxx tables are a result of joining information in the MASTERxx table with the Stratum Master Files tables (STCSMF10, STCSMF11, STCSMF35, and STCSMP12). The Stratum Master File tables contain any Master File information that exists, such as value, short description, long description, Previous Levels, and Pickup Fields information. If a dimension value in a MASTERxx table does not have a description in the Stratum Master File tables, then the value itself is used as the short and long descriptions in the MASTxx tables. If PickUp Field or Previous Levels are defined for a dimension but Master File information does not exist for a particular dimension value, then the default dimension value will be used in the MASTxx tables for the PickUp Field and Previous Level Values.
For example, a Region dimension may exist in a storage database, and the Stratum Master Files tables for it contain Region 1 through Region 4. If actual data exists only for Region 1, Region 2, and Region 3, then the MASTERxx tables will contain only Region 1, Region 2, and Region 3. The MASTxx tables will contain the short description, long description, Pickup Field (if defined for Region), and Previous Level information for Region 1, Region 2, and Region 3 as defined in the Stratum Master Files. By default, the command that sets up the MASTxx tables will not populate the tables with descriptions, Pickup Fields, and Previous Level information for Region 4 because actual data does not exist for that Region. However, the command can be set up to populate MASTxx tables with information for such Regions if the information is needed in a particular Stratum.Viewer and Stratum.Connector for Viewer implementation.
Enabling an OLAP parameter (for IBM i) or switch (for Windows) is required to maintain the MASTERxx tables during any nightly Stratum load or change set processes for the Stratum storage database. This parameter/switch maintains the MASTERxx tables during any nightly Stratum load, Net Change, or Change Sets processes for the Stratum storage database. If new or changed dimension value combinations exist in the Stratum storage database,
then MASTERxx tables will be created and populated or updated for those combinations accordingly.
In an IBM i environment, set the Maintain OLAP Master parameter to 1 for the DALOAD (Load Process), DACHGSET (Apply Change Set), and DAGRPCHG (Apply Group Change Set) commands.
In a Windows environment, set the /OLAP switch to 1 for the GISLSDRV (Load Process), GIACSDRV (Apply Change Set), and GIGRPCHG (Apply Group Change Set) commands.
See also Maintain OLAP Parameter for IBM i and Maintain OLAP Switch for Windows.