Skip to Main Content

About

The acronym "CIW" over a background field of binary numbers

Essential information for Commonwealth of Massachusetts departments on MMARS Information Delivery, and the Commonwealth Information Warehouse (CIW).

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. The pages linked below are available inside state government only.

VISIT THE CIW

Statewide Learning

The 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.

Introduction to MMARS Warehouse

Class Presentation

VIEW ON POWERDMS

CIW Navigation Guide Access 2010 – MMARS Data

VIEW ON POWERDMS

CIW Navigation Guide Access 2016 – MMARS Data

VIEW ON POWERDMS
Introduction to LCM Warehouse

Class Presentation

VIEW ON POWERDMS

Navigation Guide - Access 2010

VIEW ON POWERDMS

Navigation Guide - Access 2016

VIEW ON POWERDMS
Introduction to HR/CMS Payroll Warehouse

Class Presentation

VIEW ON POWERDMS
Intermediate MMARS Warehouse

Report Building Navigation Guide - Access 2010

VIEW ON POWERDMS

Report Building Navigation Guide – Access 2016

VIEW ON POWERDMS
CIW Report Building with Excel

Navigation Guide - CIW Report Building with Excel 2010

VIEW ON POWERDMS

Navigation Guide - CIW Report Building with Excel 2016

VIEW ON POWERDMS
CIW Report Building with Access

Report Building Navigation Guide - Access 2010

VIEW ON POWERDMS

Report Building Navigation Guide – Access 2016

VIEW ON POWERDMS
How to Run a Warehouse Starter Query

Class Presentation

VIEW ON POWERDMS

Reports and Document Resources

Departmental Reports

Reports for MMARS/LCM Listings

VIEW EXCEL

Document Profiles

Document 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 INTRANET

MobiusView

The EOTSS online viewing system user interface

VISIT MOBIUSVIEW

Information Delivery Job Aids

Pull 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).

Job Aid - Information Delivery: Accounts Payable
VIEW ON POWERDMS
Job Aid - Information Delivery: Accounts Receivable
VIEW ON POWERDMS
Job Aid - Information Delivery: Budgets
VIEW ON POWERDMS
Job Aid - Information Delivery: Capital (Fixed) Assets
VIEW PowerDMS
Job Aid - Information Delivery: Contracts and Procurement
VIEW ON POWERDMS
Job Aid - Information Delivery: Federal Grants and ARRA
VIEW ON POWERDMS
Job Aid - Information Delivery: Labor Cost Management (LCM)
VIEW ON POWERDMS
Job Aid - Information Delivery: Interdepartmental Business
VIEW ON POWERDMS
Job Aid - Information Delivery: Vendor/Customer
VIEW ON POWERDMS