You can use the State Analytical Reporting System (STARS) to find important data to use in your financial management role with the State of Connecticut. Explore this page to find important resources and information to help you use STARS.
Helpful information by topic
Accounts payable
- Accounts payable dimensions and facts (PDF): Learn dimensional data modeling and how to use dimensions and facts to build analyses within the Accounts Payable Subject Areas.
Accounts receivable
- Accounts receivable dimensions and facts (PDF): Learn dimensional data modeling and how to use dimensions and facts to build analyses within the Accounts Receivable Subject Areas.
Commitment control/budget
- Add an effective date variable to the department tree filter (DOCX): Learn how to add and modify effective dates in the Department Tree filter.
- GL/KK fact and dmension modeling (PDF): Learn dimensional data modeling and how to use dimensions and facts to build analyses within the GL/KK Subject Areas.
Fixed assets
- Fixed assets dimensions and facts (PDF): Learn dimensional data modeling and how to use dimensions and facts to build analyses within the Fixed Assets Subject Areas.
General ledger
- Add an effective date variable to the department tree filter (DOCX): Learn how to add and modify effective dates in the Department Tree filter.
- Cash flow summary (PDF): Learn how to use GL Cash Flow Dashboard Reports.
- Financial chartfields (PDF): Learn how to better understand the dimensions that are common to the financial subject areas in STARS.
- GL/KK fact and dimension modeling (PDF): Learn dimensional data modeling amd how to use dimensions and facts to build analyses within the GL/KK Subject Areas.
Procure and spend
- Procurement and spend dimensions and facts (PDF): Learn dimensional data modeling and how to use dimensions and facts to build analyses within the Procurement and Spend Subject Areas.
Project costing
- Project costing dimensions and facts (PDF): Learn dimensional data modeling and how to use dimensions and facts to build analyses within the Project Costing Subject Areas.
About dashboards and analytics
- General ledger/commitment control dashboard (PDF): Read the user guide from the STARS Financials Dashboard and Report Workshop. It provides an overview of Oracle Financial Analytics Dashboard, explaining how you can analyze and investigate business issues through pre-built dashboards.
- Accounts payable (PDF): Read the user guide from the STARS Financials Accounts Payable Dashboard and Report Workshop. It provides an overview of Oracle Financial Analytics Dashboard, explaining how you can analyze and investigate business issues through pre-built dashboards.
- AdHoc analysis (PDF): Oracle Financial Analytics provides organizations with better visibility into the factors that drive revenues, costs, and agency value. Through intelligent dashboards, Oracle Financial Analytics provides hundreds of powerful (pre-built) financial metrics, alerts, reports, and dashboards to financial professionals and line of business managers, enabling them to gain insight and take appropriate actions.
- Financial chartfields (PDF): Terms that are used in the OBIEE area. See also the linked glossary for terms related to Core-CT.
- General ledger/commitment control fact and dimension modeling (PDF): OBIEE data model is based on Dimensional Modeling. The underlying database tables are separated as Fact Tables and Dimension Tables. The dimension tables are joined to fact tables with specific keys. This is usually called Star Schema.