An official website of the Commonwealth of Massachusetts
Essential information for Commonwealth of Massachusetts departments on MMARS Information Delivery, and the Commonwealth Information Warehouse (CIW). Please contact the Solution Desk for information on running a Warehouse Starter Query in Access 2010.
The Commonwealth Information Warehouse (CIW) brings together a subset of the financial, budgetary, human resources, payroll, and time reporting information maintained in dedicated and separate systems by individual agencies. CIW provides access to integrated, common data that supports timely, well-informed business decisions to authorized users through a centralized and integrated repository. For any CIW problems, please contact the Executive Office of Technology Services and Security (EOTSS) End User Support at 844-435-7629 or [email protected].
VISIT THE CIWThe Office of the Comptroller offers CIW resources and training for state employees. The links to the CTR Intranet below are available inside state government only.
Class Presentation
CIW Navigation Guide Access 2016 – MMARS Data
Class Presentation
Navigation Guide - Access 2016
Class Presentation
Report Building Navigation Guide – Access 2016
Navigation Guide - CIW Report Building with Excel 2016
Report Building Navigation Guide – Access 2016
Class Presentation
Reports for MMARS/LCM Listings
VIEW EXCELDocument profiles provide an overview of MMARS documents, including the document name, and code, function, workflow and supporting documentation. The profiles include a definition of each document section and field description. [MAGNet access or VPN required].
VIEW ON CTR INTRANETThe EOTSS online viewing system user interface
VISIT MOBIUSVIEWPull link tables from the Commonwealth Information Warehouse by running queries, or which reports to look up in MobiusView to identify any type of entry in MMARS. (PowerDMS login required).
