|Datamart Enterprise Query Tool Software - "IR Studio"|
|Effective June 1, 2010, Department of Administrative Services (DAS), purchased an enterprise license for the State of Oregon that entitles all state agency personnel to install the 'Hyperion Interactive Reporting Studio' (a.k.a. IR Studio) application for accessing the Datamart. |
Information to complete a full user setup, including IR Studio application download, ODBC configuration, IBM DB2 driver install, and Open Catalog Extension (OCE) updates are available at: http://dasapp.oregon.gov/datamart/
|Datamart User Maintenance Site|
|Datamart User Maintenance Site - Go here to change your password, request your account be reset, view your current query connections or stop a query. |
Note: In the event that you receive an alert questioning the Security Certificate of this website, please follow the instructions that allow you to Proceed. The website is secure.
Note: Once you receive Datamart security access and you receive the initial temporary password, you have 48 hours to change your password on the Datamart User Maintenance site.
Report Datamart outages and/or connectivity issues to the DAS, Technology Support Center at 503-378-2135 or by e-mail.
|Datamart Security Access Forms|
|SFMA and OSPA Standard View Access: The agency security officer completes and submits the Datamart Standard View Access SFMA and OSPA Tables Request Form found in the Security Access Request section at: |
SFMA Special View Access: Security level 3 (restricted) and level 4 (critical) data are not included in the standard Datamart view. The agency security officer must work with the agency's senior fiscal officer to ensure that each request to view sensitive data is consistent with the user's position and assigned job duties. For special view access, please e-mail the Systems Security unit at email@example.com, attention Datamart Business Analyst.
PPDB Standard View Access: The Department of Adminstrative Services (DAS), Human Resource Services Division, HR Systems Section manages access to the PPDB system and the related tables in Datamart. The PPDB Security Access Request Form appears at the following link under PPDB Resources & Information:
HR Operations & Systems
Contact PPDB Security at firstname.lastname@example.org for assistance.
ORBITS/PICS Standard View Access: The DAS, Budget and Management, Statewide Audit and Budget Reporting Section (SABRS) manages access to ORBITS and PICS and the related tables in the Datamart. The ORBITS/PICS Security Form appears at the following link under SABRS Operations:
Contact email@example.com for assistance.
|Datamart Processing Information|
|Datamart_Calendar_2014.pdf - Dates are subject to change|
Datamart System Load Information - Detailed listing of statewide systems and their load schedules.
|Important Dates during Month 13:|
Datamart Update Schedule:
'YE GL Detail’ and ‘YE GL Summary’ tables: Data is only within these tables during Month 13. The
rest of the year these tables are blank.
Data is loaded the evening of the following dates and is viewable the next day: 07/22/14, 07/24/14, 07/26/14, 07/29/14, 07/31/14, 08/02/14, 08/05/14, 08/07/14, 08/09/14, 08/12/14, and 08/14/14.
'YE Active Accounting Event' table: Data is only within this table during Month 13. The rest of the
year the table is blank.
Data is loaded the evening of the following dates and is viewable the next day: 07/30/14, 08/06/14, and 08/13/14.
SFMA Financial Table Year Reference:
The following is a list of the SFMA ‘Accounting Event’ tables and the range of time they currently contain.
Note: These tables are archived once a biennium. The Datamart News List will provide users with an alert when the next archive will take place. (Last archive: April 2014). In addition, Capital Construction data is the exception to the rule and is not archived.
Active Accounting Event: Most current three months of SFMA system data.
All Accounting Event: Contains SFMA data from FY 2011 to current.
Archive Accounting Event: Contains SFMA data from FY 2009 to current.
|Datamart Work Request Form|
|Datamart Work Request Form - Use this form to request improvements and/or changes to the Datamart, for example, new fields, tables, joins, etc. |
This form is to be completed and submitted electronically by using the 'Submit by E-mail' button.
|Datamart E-News List|
|Hear the latest news about the EGS/FBS Accounting and OSPA Datamart. This list reports outages, updates, newsletters, training dates and user information. |
Datamart-News - How to join the Oregon Datamart Users E-News List
|SFMA Datamart Tables|
SFMA Datamart Tables (pdf) - Listing of Financial and Profile tables. Contains data warehouse fields, field length, source, and descriptions.
Note: To obtain additional detailed information about the SFMA tables, please refer to the 'Datamart and Hyperion: Back to Basics Manual' (page 2-16 through 2-22), in pdf form, shown in the 'Datamart Training' section of this website.
Join-Diagram2013.pdf - This file displays the 'All Acct Event' table joined to the various 'Profile' tables within the SFMA Datamart.
GL Compare (pdf) - 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).
|OSPA Datamart Tables|
|The DAS Datamart contains data processed through the Oregon Statewide Payroll Application (OSPA). To learn more about this data, please visit the following website (maintained by statewide payroll): |
OSPS Datamart information
|The ‘Repository’ is a great tool to help share standard reports with users on a statewide level. The Repository continues to grow and currently contains 34 files, which access data from SFMA, ORBITS, OSPA, etc. To learn more about how to access the repository and what each file includes: |
Thanks to users throughout the state, we continually obtain new reports to help in day-to-day operations. If you have any reports which you believe would be a good fit to join this group, please send them, along with a detailed description, to Datamart.Support@state.or.us.
State of Oregon employees are encouraged to take the classes offered by the Datamart team. These classes help to gain the necessary knowledge to work in Brio/Hyperion, as well as, access the Datamart. |
Datamart training courses can be found by visiting the Department of Administrative Service iLearn website. In addition, updated class scheduling information will be sent over the Datamart News List.
Datamart trainings are Free of charge; however, agency's will be accessed a $50 fee if the user does not show for the scheduled training course. Agency's do have the option to send a substitute user, if the original user is unable to attend.
Training Times and Locations:
(SALEM Location: Classes are 8:00 am - 4:30 pm and will be held at the General Services Building in the DAS East Training Lab, located in the Mt Hood room at 1225 Ferry St SE, Salem, OR 97301.)
(TIGARD Location: Classes are 8:15 am - 4:30 pm and will be held at the PERS Building in the Training Lab, located at 11410 SW 68th St, Tigard, OR 97223.)
PERS overflow parking: PERS-Overflow-Parking.pdf (Close to Chang's Mongolian Grill) **Note: Must include the PERS parking sign on dashboard of vehicle.
Scheduled Datamart Trainings:
Datamart & Hyperion: Back to Basics
None at this time
Datamart & Hyperion: Payroll
None at this time
Datamart & Hyperion: A Cut Above
Sept 30, 2014 at Salem location
Datamart Training Manuals:
Datamart & Hyperion: Back to Basics - Manual (pdf)
Learn the basics about the SFMA Datamart, table information, the Repository, and how to set up an OCE. Learn about Hyperion, how to build and run queries, manipulate queries and results. In addition, learn about Hyperion tables, joins, filters, formatting, and sorting.
If you would like to use the file (GL Detail 12.bqy) that is associated with Chapter 4B exercise in the 'Back to Basics' manual, please contact 'Datamart.Support@oregon.gov'.
Datamart & Hyperion: Payroll - Manual (pdf) - Learn the basics about the OSPA Datamart, the Repository, and how to set up an OCE. Also, learn about the Hyperion application, how to build and run queries, manipulate queries and results, and how to append queries. In addition, learn about Hyperion tables, joins, filters, formatting, and sorting.
Datamart & Hyperion: A Cut Above - Manual (pdf)
Learn advanced topics including: complex query building, pivots, free-form reports, computed fields, and dashboards.
OSFA Training 2014: Chart Design and Tips:
This document is a summary of the 2014 OSFA training: OSFA 2014_Presentation_Summary.pdf
Datamart/Hyperion Tips and Tricks:
This document is a helpful tool that will provide users with valuable tips and tricks for the Datamart and Hyperion application. Tips_and_Tricks_2013.pdf
|Aaron Wallace, Senior Datamart Business Analyst |
155 Cottage Street NE, U50
Salem, OR 97301-3969
E-mail: Datamart Support
Vacant, Senior Systems Administrator
155 Cottage Street NE, U50
Salem, OR 97301-3969
E-mail: Datamart Support