|
|
|
 |
| Datamart Server Upgrade |
|
All Datamart users need to verify that their Datamart connections have been upgraded to use either a version 8 or 9 copy of the IBM DB2 ODBC driver. If you are still using a version 7 copy of the driver you must upgrade prior to the switch over to the upgraded Datamart server. The newer drivers work with both the existing Datamart server as well as the upgraded server.
IBM DB2 Driver Update Instructions (pdf) - Instructions for verifying and upgrading IBM DB2 Runtime Client/ODBC Drivers for the Datamart
v9fp4a_en_US_setup.exe - The actual IBM DB2 Runtime Client version 9. Click on this link and save to your local computer.
|
|
|
| Datamart E-News List |
|
Hear the latest news about the SCD Accounting and OSPA Datamart. This list reports outages, updates, newsletters, and user information.
Datamart-News - How to join the Oregon Datamart Users E-News List
|
|
|
| Datamart Training |
|
We are currently recruiting to fill the Datamart Business Analyst position, which provides the classroom Datamart training. Until this position can be filled and training classes resume we are providing copies of the classroom training manuals here to assist you in learning Hyperion.
Hyperion Basic Intelligence Manual (pdf)
Learn the basics about the Datamart, table information, how to set up an OCE, running queries in Hyperion, how to manipulate your results, limits & sorts, and how to build queries.
Hyperion Intermediate Intelligence Manual (pdf)
Learn advanced topics including pivot reports, free-form reports, computed fields, dashboards and how to access the repository reports.
These trainings take place at the Oregon State Library in a computer lab setting. All classes are hands-on instructor led classes.
Each session lasts 4 hours and training documentation is provided. Classes are limited to 10 participants. Registration is required.
Archived Training Materials
Session 1 - Database and Datamart
Training Materials (doc)
Session 2 - SFMA Datamart
Training Materials (doc)
Sample Files (zip) Session 3 - OSPA Datamart
Training Materials (doc)
Sample Files(zip)
|
|
|
| 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
A new schedule will be posted in the fall.
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 |
|
Newsletters are posted as pdf files.
|
|
|
| New User Setup for SCD Accounting & OSPA Datamart |
|
To access data from the SCD Accounting and OSPA Datamart, you must have an IBM DB2 driver and Hyperion ad-hoc reporting software installed. Also, your agency security officer will need to request a Datamart password for you. After these items are installed and you have your password, you will need to set up an Open Catalog Extension (OCE) through your Hyperion software. Documentation is provided below or you may use the link for easy install. The link to install your IBM DB2 driver is in the ODBC Drivers and IRMD/GGDC link below.
Procedures for Accessing the Datamart (pdf) - Instructions for accessing the SCD Accounting and OSPA Datamarts
SCD Accounting Datamart Open Catalog Extension (pdf) - Instructions for setting up a SCD Accounting Datamart OCE
SCD Accounting Datamart OCE - OCE file set up with custom Datamart joins
Save this file to C:\Program Files\Brio\BrioQuery\Open Catalog Extensions for versions 6 and C:\Program Files\Brio\Client\Program\Open Catalog Extensions for version 8
OSPA Datamart Open Catalog Extension (pdf) - Instructions for setting up an OSPA Datamart OCE
OSPA Datamart OCE - OCE file set up with custom Datamart joins
Save this file to C:\Program Files\Brio\BrioQuery\Open Catalog Extensions for version 6 and C:\Program Files\Brio\Client\Program\Open Catalog Extensions for version 8
|
|
|
| Contact Information |
|
Linda Flicker, Senior Datamart Business Analyst
155 Cottage Street NE, U50
Salem, OR 97301-3969
Phone: 503-373-7277, ext. 281
Email: Linda.Flicker@state.or.us
|
|
|
|
