|
|
|
 |
| Datamart Enterprise Query Tool Software - "IR Studio" |
|
Effective June 1, 2010, Department of Administrative Services (DAS), State Controller's Division (SCD), Statewide Accounting and Reporting Services (SARS) purchased an enterprise license for the State of Oregon that entitles all state agency personnel to install IR Studio for accessing the Datamart.
Information to complete a full user setup, including 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:
http://www.oregon.gov/DAS/SCD/SARS/systems_security.shtml
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 security.systems@das.state.or.us, 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 HR Systems Forms:
http://www.oregon.gov/DAS/HR/forms.shtml
Contact PPDB Security at group.ppdb@das.state.or.us 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:
http://www.oregon.gov/DAS/BAM/forms.html
Contact orbits.help@das.state.or.us for assistance.
|
|
|
| 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 SCD 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 tables and fields, includes data descriptions.
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).
|
|
|
| Reports Repository |
|
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.
|
|
|
| Datamart Training |
|
State of Oregon employees are encouraged to take the "Datamart & Hyperion: Back to Basics" class offered by the Datamart team. This class helps 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.
Current Scheduled Datamart Trainings:
--None Scheduled at this time--
Current Datamart Training Manuals:
Datamart & Hyperion: Back to Basics Manual (pdf)
Learn the basics about the 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.
Hyperion Intermediate Intelligence Manual (pdf)
(Note: This training will be updated in the near future to include 'Hyperion Interactive Reporting Studio'.) Learn advanced topics including pivot reports, free-form reports, computed fields, dashboards and how to access the repository reports.
|
|
|
| Datamart User Group |
|
Datamart User Group
Come join your peers as we explore the Datamart and work progressively as a team to enhance our knowledge through discussions, trainings, focus groups, and many more forums. You are the Datamart customer and your opinion matters! See you there!
Upcoming Datamart User Group Meeting Dates
Due to limited resources, user group meetings have been postponed until further notice.
Archived Datamart User Group PowerPoint Presentations
October 31, 2007 Additional Materials (pdf)
July 26, 2007
April 24, 2007
January 31, 2007
|
|
|
| Datamart Connection Newsletter Archive |
|
Due to limited resources, newsletters will be posted on a varying basis.
Newsletters are posted as pdf files.
|
|
|
| Contact Information |
|
Aaron Wallace, Senior Datamart Business Analyst
155 Cottage Street NE, U50
Salem, OR 97301-3969
Phone: 503-373-0269
E-mail: Datamart Support
|
|
| |
|
|
