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 DAS Datamart OBIEE application went live on Aug. 1, 2020 (state agencies were provided access to the OBIEE production environment between 8/1/20 and 11/1/20).
The application can be found on the following sites. To fully view the site, a user must be connected to state government's network.
Production environment:
https://obi.das.oregon.gov:9503/analytics/
Test environment (used for Admin only):
https://obitest.das.oregon.gov:9503/analytics/
Available data
Currently, the OBIEE application accesses SFMS, OSPS and ORBITS data in the DAS Datamart. (Also refer to the Repository section, below.)
FAQ
OBIEE Common Questions
OBIEE Admin Facts - why an agency would need an OBIEE user with 'admin view' rights
Passwords
When logging in to 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. When the user updates their work computer password, then OBIEE automatically syncs and changes.
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 instructions to help non-sync users create a profile and manage their password: Password Manager User Guide.
Passwords should be updated every 90 days.
Formula creation
The following document provides guidance to employees who will create formulas that access the DAS Datamart using the OBIEE application. OBIEE Formulas
Grouping fields (Bins)
Here is a document detailing how to group fields in OBIEE. This introduces the "Bins" function. How to Create a Group
Training
Training on the use of OBIEE is required prior to using the application. Please refer to the Training section of this page for course information.
Repository
The OBIEE repository functions within the OBIEE server environment. All files are created with the OBIEE tool and saved to the OBIEE server. The Datamart team as well as agency users are working on building files for this repository similar to the original Datamart Hyperion repository. Thanks to users throughout the state, we continually obtain new reports to help in day-to-day operations.
To suggest that one of your reports be added to the repository, send a sample and detailed description to datamart.support@das.oregon.gov.