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

​​​​​​​​​​​​​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

The DAS Datamart can be accessed by various programs. Currently, the state agencies have two types of security access. One is web based and used with OBIEE. The other is RACF based and used with any program that accesses DB2.  ​​

Troublesh​ooting Non-OBIEE Program Queries

If your query returns unpredicted results, check the following table for a solution. 

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

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

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

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

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

Available Data

​​​​​​​​​The OSPA Datamart contains data processed through the Oregon Statewide Payroll Application. 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

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