These tasks must be performed before you access Stratum.Connector for Viewer for the first time and process its Analysis Services cube and database.
1. Run the LOADOLAP Master File command to create a MASTERxx table for all dimension values.
For IBM i storage servers, run the DALOADOLAPcommand.
For Windows storage servers, run the GILOADOLAP command.
2. Run the CRTOMAST Master File command to create and populate the MASTxx tables.
For IBM i storage servers, run the DACRTOMAST command.
For Windows storage servers, run the GICRTOMAST command.
3. Add the CRTOMAST Master File command to the end of the nightly load program for Stratum to maintain the MASTxx tables.
4. Turn on the OLAP parameter/switch to maintain the MASTERxx tables during any nightly Stratum database load or change set process.
For IBM i storage servers, set the Maintain OLAP Master parameter for the DALOAD, DACHGSET, and DAGRPCHG commands to 1.
For Windows storage servers, set the /OLAP switch for the GISLSDRV, GIACSDRV, and GIGRPCHG commands to 1.
Once you have completed these steps, you can proceed with the set up of Stratum.Connector for Viewer and processing its Analysis Services database. See Initial Setup of Application and Data.