Datamart & OBIEE

​​​​​​​​Welcome to your new state of Oregon position! Do you need to access statewide accounting, budget or payroll data? You came to the right place. The Department of Administrative Services' (DAS) Financial Datamart is available to you. It is an electronic warehouse of data, which helps employees develop reports for business information and decision making. 

Datamart Resources Overview

Query Tool

The current query tool supported by this team is 'Oracle Business Intelligence Enterprise Edition' (OBIEE or OB1). Agencies are able to use other query tools, however, the Datamart team focuses on supporting one main tool.

Datamart News:

Announcements

Attn Datamart Users: Please share this notice with employees who may not be included on the Datamart News distribution list.

Sent: Monday, October 19, 2026 2:57 PM

Datamart users,

We are pleased to announce that the Datamart Repository SharePoint Site Recording training is now available in Workday Learning. 

Link: DAS - OSC - Datamart Repository SharePoint Site Recording

This training will introduce users to the Datamart Repository SharePoint site. The site provides a location to download Datamart Repository template files. The training agenda includes background, demo, and reminders.

If you have any questions, please email Datamart.Support@das.oregon.gov.

Thanks,

Sent: Thursday, October 15, 2026 10:36 AM

Power BI users,

Please be aware of a potential version control issue in Power BI. Reports or files created in a newer version of Power BI Desktop may not open in older versions. To ensure you can access all shared and updated files, you may need to upgrade your Power BI Desktop to match or exceed the version used to create the report.

If you encounter this issue, please update Power BI through your agency’s software center, or work with your technical support team to install the latest version.

Thanks, 

Sent: Tuesday, October 6, 2026 1:06 PM

Datamart users,

We are pleased to announce that the SFMA & Payroll Reconciliation training is now available in Workday Learning. Thank you for your patience, and please be sure to share this update with your coworkers.

Link: SFMA & Payroll Reconciliation Reports Recording - Workday

Important Note:
The OBIEE repository reconciliation file (Reconcile – Payroll to SFMS) has been updated. Please make sure you are using the latest version for your reconciliation process.

During training, we observed differences in data at the PCA level. We identified that the payroll query was filtering out OPE data, which contributed to some of these discrepancies. Removing this filter ensures the results align more consistently across PCAs. The OBIEE payroll file has been updated to reflect this change.

If you have any questions, please email Datamart.Support@das.oregon.gov.

Thanks,

​Overview

Oracle Business Intelligence Enterprise Edition (OBIEE or OB1) is the query tool set to provide access to Oregon state government's financial Datamart. It is the replacement for the Hyperion (Brio) application.

The application can be  found on​ the following sites. To fully view the site, a user must be connected to state government's network.

OBIEE Shutdown:

The Oracle Business Intelligence Enterprise Edition (OBIEE) will go off extended support on June 30, 2027. Continuing to use an unsupported product increases the risk of system failure. As a result, the DAS Datamart team will fully retire OBIEE on December 31, 2027. After this date, users will no longer have access to OBIEE files. Please plan accordingly.​

Production​ environment:

https://obi.das.oregon.gov:9503/analytics/

Test environment: 

https://obitest.das.oregon.gov:9503/analytics/​​

Available Date

Currently, the OBIEE application accesses SFMA, Workday, and ORBITS data in the DAS Datamart. (Also refer to the Repository section, below.)

FAQ's

OBIEE Common Questions

​​Passwords

When logging into OBIEE there are two types of agencies, "Sync" and "Non-sync." Learn which type applies to your agency here.

A "sync" agency will use a password that is the same as the user's work computer log on. 

A "non-sync" agency will use the password initially provided by the Agency ARS (Active Roles Server) admin team. This password will be maintained through the OBIEE password manager site. 

Here are instruction to help non-sync users create a profile and management their password: Password Manager User Guide.

Passwords should be updated every 90 days.

Formula Creation

The OBIEE Formulas document provides guidance to employees who will create formulas that access the DAS Datamart using the OBIEE application.

Grouping Field (Bins)

The How to Create a Group ​document detailing how to group fields in OBIEE. This introduces the "bins" function.

Training

Training on the use of OBIEE is required prior to using the application. Please refer to the Training section of this pave for course information.

Repository

The OBIEE repository functions within the OBIEE server environment. All files are created using the OBIEE tool and stored on the OBIEE server. The Datamart team, along with agency users, has built files for this repository similar to the original Datamart Hyperion repository. Thanks to contributors across the state, we continue to receive new reports that support day‑to‑day operations.

In April 2026, two OBIEE queries were created to support the reconciliation of accounting and payroll data. These queries provide accountants and payroll contacts across the enterprise with the resources and guidance needed to reconcile RSTARS payroll transactions to Workday Payroll reports using the DAS Financial Datamart.

To access these queries, log in to OBIEE and navigate to: /Shared Folders/Repository/Final/Reconciliation/​

To suggest that one of your reports be added to the repository, send a sample and detailed description to datamart.support@das.oregon.gov 

​​​​​​​​​​​​​Overview:

Microsoft's Power BI Desktop is a query tool application that allows users to connect to multiple data sources, transform data, and create visually appealing reports and dashboards. In 2025, the DAS Datamart team announced it would be supporting this product for State of Oregon, DAS Financial Datamart users.

Available Data:

Currently, the Power BI Desktop application can access the DAS Financial Datamart which contains accounting (SFMS), payroll (Workday), and budget (ORBITS) data.

FAQ:

License:

The State of Oregon has a license to use Power BI Desktop through the Office365 agreement.

Passwords/Security:

To access the DAS Financial Datamart with Power BI Desktop the State of Oregon uses an ODBC connection (Help: Guide to ODBCs​). To obtain security access to the standard SFMSP ODBC, users will contact their Agency Security Officer (ASO).

Training:

Power BI - Getting Started​: This is a basic training that will review the 'getting started' documents sent over the Datamart news list in July 2025.

• Timeline
• What is needed to start using Power BI Desktop
• Recap of 'Guide to ODBCs'
• Recap of 'Power BI - Connect to the Datamart'
• Recap of 'Power BI - Stored User ID​'
  

Power BI - Datamart Joins Training:​ This training will focus on a detailed review of the Power BI – Datamart Joins Guide. This guide was developed to provide comprehensive information on how to effectively use table joins within Microsoft Power BI Desktop when working with the DAS Financial Datamart. Power BI Datamart Joins Training Slide Presentation​.

Participants will gain a clearer understanding of:

• What types of joins are in the Datamart
• How joins function in Power BI
• Best practices for joining tables in the DAS Financial Datamart

• Common pitfalls and how to avoid them
  

​​​​​Overview:

Microsoft Excel is an approved secondary query tool for DAS Financial Datamart users. It allows users to connect to multiple data sources, transform data, and create tables, PivotTables, dashboards, and reports.

As of 2026, OBIEE remains the primary supported query tool; however, the DAS Datamart team will fully transition to Power BI Desktop in 2028. Excel is an approved alternative query tool and is particularly useful in scenarios that involve large row‑level datasets or when users need flexible, file‑based reporting options.

FAQ:

Excel query creation (pdf)​: This document provides instructions for creating queries in Excel that connect to and retrieve data from multiple DAS Datamart SFMS tables.

​

​​​​​​​​​​​​​​​​​Securi​ty Access Forms​​​

SF​MA and Workday Standard View Access  

The agency security officer completes and submits the Datamart Standard View Access Request Form found in the Security Access Request section at: Systems Security. 

OBIEE Security Access Process    ​

Note: Please use the ​OBIEE security request form on the SARS System Security​​ website. Authorized ASOs use this form to request OBIEE access.

Password Resets

OBIEE passwords: visit the OBIEE tab of this accordion and review the section regarding passwords. 

Datamart RACF passwords: visit the Datamart User Maintenance site. 

All Datamart passwords are valid for 90-days. You must update your password before the end of the 90-days or be required to obtain a reset.

Once you receive Datamart security access and an initial temporary password, you have 48 hours to change the password. 

The site is compatible with Internet Explorer, Firefox and Chrome.

Your password also is used when accessing programs that use the RACF ID password structure.   ​​

​​​​​​​Overview:

When an employee begins working with the State of Oregon, they are assigned a RACF ID. Some employees will require access to the Department of Administrative Services (DAS) Financial Datamart. Access to the DAS Financial Datamart is provided through two types of security:

1. OBIEE Program Security: This is a web-based system that uses Shared Active Directory for authentication.

2. RACF Security via ODBC/DB2: This method allows users to connect using any query tool that supports DB2, such as Excel, Access, Power BI, Tableau, TOAD, and others.

To access the Datamart using RACF security, users must obtain the appropriate RACF access, configure the ODBC connection, and then use their preferred query tool to retrieve accounting, payroll, and budget data.

Obtaining RACF Access:

Contact your Agency Security Officer (ASO). They will help you through the entire process.

​Passwords:

Coming soon - Datamart RACF Password Guide​: Please follow this guide for information related to Datamart RACF Passwords. (Narrative from upcoming password guide pasted below):

Department of Administrative Services: Datamart Support

Guide: Datamart RACF Password

Background: When an employee begins working for the State of Oregon, they are assigned
a RACF ID. If they need RACF access to the Department of Administrative Services (DAS)
Financial Datamart, they must request it through their Agency Security Officer (ASO). After
access is granted, they receive a welcome email from DAS RACF Admin. The temporary
password provided is valid for only 48 hours and must be updated on the Datamart
Maintenance site (https://datamartapp.dasapp.state.or.us/). Once updated, the password
is valid for 90 days.

Issue: The most common issue for Datamart RACF users occurs when their 90-day
password period expires. Users do not receive alerts before expiration, and once the 90
days have passed, the account is automatically locked. When this happens, the only way
to regain access is to request a password reset from the DAS RACF Admin at DAS.RacfUserAdm@das.oregon.gov.

Recommendation: The system does not send expiration warnings; therefore, the
Datamart team recommends setting up an Outlook reminder to update your password
before the 90-day period ends.

Solution: To fully unlock an account, the user must request a password reset from the DAS
RACF Admin. The steps below outline the proper process. Please ensure the steps are
followed in the correct order, as performing them out of sequence can lead to additional
complications.

1. Request a Datamart RACF password reset: Email the DAS RACF administrator to
request a password reset. This is the only method to unlock your Datamart RACF
account.

2. Change your temporary password: After receiving the reset email from DAS RACF
admin, go to the Datamart maintenance site and update the temporary password to
a new one.

a. The updated password must be exactly 8-characters.

b. You must complete this step within 48 hours, or the account will be locked.

c. The new password will be valid for 90-days.

3. Verify your ODBC connection: This step confirms that your computer can
communicate with the Datamart without other program interference.

a. Open ODBC Data Source Administrator (64-bit) on your computer.

b. Locate the SFMSP entry (typically under System DSN tab).

c. Select SFMSP, click Configure, enter your updated RACF ID and password,
and choose Connect.

d. You must receive a “Connection tested successfully” message before
moving to Step 4.

e. If the test fails, take a screenshot of the error and send it to Datamart
Support.

4. Update credentials in Power BI Desktop: If a user works with Power BI, this step
must be completed each time the DAS Datamart RACF password is changed.
The Power BI application saves ODBC passwords within the program; therefore, if
the password is not changed each time, the program will use the old password and
lock the user out.

a. Open Power BI Desktop → File → Options and settings → Data source
settings.

b. Select SFMSP, choose Edit permissions, then Edit, update your
credentials, and save.

5. Update credentials in Excel: If a user works with Excel, this step must be
completed each time the DAS Datamart RACF password is changed.
Excel saves ODBC passwords within the program, so the Datamart password must
be updated each time or the program will use the old password and it will lock a
user out.

a. Open Excel → Data → Get Data → Data source settings.

b. Select SFMSP, choose Edit permissions, then Edit, update your
credentials, and save.

Problems:

Contact datamart.support@das.oregon.gov with any issues.

​​​​​​​​​​​​​​​​​​​Onlin​e Co​​urses

We are pleased to announce the following trainings now available in Workday Learning:

Link: DAS - OSC - Datamart Repository SharePoint Site Recording

This training will introduce users to the Datamart Repository SharePoint site. The site provides a location to download Datamart Repository template files. The training agenda includes background, demo, and reminders.

Link: SFMA & Payroll Reconciliation Reports Recording - Workday

Important Note:
The OBIEE repository reconciliation file (Reconcile – Payroll to SFMS) has been updated. Please make sure you are using the latest version for your reconciliation process.

During training, we observed differences in data at the PCA level. We identified that the payroll query was filtering out OPE data, which contributed to some of these discrepancies. Removing this filter ensures the results align more consistently across PCAs. The OBIEE payroll file has been updated to reflect this change.

Datamart: ​​​OBIEE

The Oracle The Oracle Business Intelligence Enterprise Edition (OBIEE or OB1) training is a beginner level course. The OBIEE query tool is web-based and is a replacement for the Hyperion (Brio) application. This training provides an overview of the OBIEE structure, details website security, and demonstrates the Homepage and Catalog features. It provides an overview on how to create an analysis, formula and agents. Participants will be able to re-create an existing Hyperion file within the OBIEE application. 

Requirement: OBIEE security access

Datamart: OBIEE Overview

Datamart: OBIEE Workday Link

Fundamentals of​​ the Datamart​

This introductory training cov​ers the following Datamart topics: 

• A description of the Datamart
• The statewide data available in the Datamart
• History of business intelligence applications used with the Datamart
• Tables within the Datamart
• Connecting to the Datamart database 
• The Datamart Repository
  
• Am I ready to work with the Datamart?

Fundamentals of the Datamart Overview

Fundamentals of the Datamart Workday Link

OBIEE-Hy​p​erion Conversion Process Recording

This recording covers the steps to convert three Hyperion file examples into OBIEE analyses. The ‘All Acct event’, ‘GL Detail’, and ‘OSPS-Labor Cost’ tables will be demonstrated in the conversion. Questions regarding the content of the course should be directed to Datamart.support@das.oregon.gov.

OBIEE-Hyperion Conversion Process Recording Workday Link

Datamart/Workday Payroll Information

This recording discusses the Workday tables on the Datamart. In addition, it previews and describes OBIEE Workday reports.

Datamart/Workday Payroll Information Recording Workday Link

Handouts

• Workday Tables in Datamart​
• Datamart Calendar for Payroll Data
  ​
  

​Other Trai​​​ning ​​OSFA Training​ 2​​021

OBIEE introduction and tips (includes discussion on security, analysis, filters, pivot and formula: OBIEE OSFA Training (2021)

Grouping Fields (Bins)​

Here is a document detailing how to group fields in OBIEE. This introduces the "Bins" function: How to Create a Group​​​

​​​​​​​​​​​​​​​​​​​​​​​​​Links to Datamart Calendars​

Datamart Calendar 2027  Coming soon.

Datamart Calenda​​r 2026​  Dates are subject to change.​

​​​​​SFMA Datamart Tables​

Listing of Financial and Profile tables. Contains data warehouse fields, field length, source, and descriptions.​

​​​​​​​Join - Diagram 2013

In OBIEE, joins are completed behind-the-scenes so users do not have to set them manually. In all other programs such as Excel, Access, etc., users may create joins as shown in this document.

GL Compare​

Comparison of fields between the GL Detail and the GL Summary tables. 

R*Stars Actuals at the Budget Level

R*Stars integration established a one-to-one relationship between the ORBITS Cross-Reference number and the R*Stars Program Code; providing a link between budget (ORBITS) and accounting (R*Stars).​

​​​​​​​​​​​The OSPA Datamart contains data processed through the Oregon Statewide Payroll Application. The OSPA Datamart contains data back to July 2011.​ As of November 2022, the OSPS information is no longer being added to the Datamart. The new payroll system of record is Workday. 

The OSPA Datamart contains individual employee payroll information, including:

• Deduct​ions​

• Job Status
  

• Labor Costing

• Leave Accrual

• Gross and Net Pay Detail

• Work Schedules

​​The OSPA Datamart does not contain: 

• Confidential Information, such as Social Security numbers, wage withholding/garnishment info, bank account information or certain insurance surcharges

• Data sourced from other applications such as salary range or employee addresses

• Detailed daily time information if not using Online Daily Time or eTime.​

​​The following lists detail the fields available in each of the OSPA Datamart's six major tables. For a master list of all available fields, see the last portion of this section.​​

Datamart Table Re​ference Lists

​* This table was created for the ACA data to help agencies view all agency ACA info.   

** This table was created for DAS OSPS statewide unit only.

*** This table was created to provide historical data for various OSPS fields not contained on other OSPS Datamart tables, specifically the 'Final Check Issued date', 'Final Check Period End Date', and the 'Retirement Date' from the P010 screen in OSPS. 

​​​​​​​​​​​​​​​​​​Overview

Workday is the State of Oregon’s current payroll, time tracking and HR information system. Workday replaced OSPS in December 2022. Currently, Workday data is loaded to the Datamart twice per month (run1 and run2).

Workday Oregon site:https://www​.oregon.gov/das/hr/pages/workday.aspx​.

Available Data

Datamart Payroll Data

​​​​​​​​​​​Datamart Work Request Form

Use this form to request improvements or changes to the Datamart, such as new fields, tables, joins, etc.​

This form is to be completed and submitted electronically by using the "Submit by Email" button.