EPM 11, Enterprise Performance Management

About EPM 11

Oracle Enterprise Performance Management, version 11 (EPM 11) is the upgraded version of Hyperion/Brio, a tool used to gather and organize data for reporting and analysis. This new version offers expanded browser support, improved analytics, full Oracle support, etc. Obtaining security to EPM 11 will give you access to the many dashboards and queries available. See the information below to obtain the necessary security and instructions for downloading the Interactive Reporting Web Client.

Steps to a Successful Start

  1. Complete Operational Data Security form
  2. See Installation Support below.

Security

There are two levels of security for EPM 11:

The first one logs you into the EPM 11 software. This login provides access to the reporting tool and its queries; it does not allow you to pull data from the tables. Once you have been granted the appropriate security, you can change your password within the software. Go to Tools, Change Password, and enter your Password into the Current, New and Confirm fields. Select SAVE. This password does not expire. However, it is recommended that you change your EPM 11 password the same time you change your Operational Data password.

The second is your Operational Data password that allows you to query from the Operational Data data source (via Microsoft Access, SQL sever, EPM 11, etc.). Operational Data passwords expire every 90 days. You will receive an email 14 days in advance of the expiration date. If no action is taken, the password will expire and queries will fail. Passwords cannot start with a number and should only contain alphabetic and numeric characters. Change Operationa Data Password (Passwords are CASE SENSITIVE in Oracle11g).

If you are a current EPM 11 user and need to have your password reset, please contact us or call the MnSCU help desk at  1-877-466-6728. If you are a new employee to MnSCU and/or have never used EPM 11, you will need to complete the security form below. Once your form has been approved, you will receive notification and your password.

(If you experience problems logging in, contact us or call 1-877-466-6728 or 1-877-GO-MNSCU)

PASS-THROUGH CREDENTIALING - EPM 11 Feature

Pass-through credentialing eliminates having to enter the Operational Data username and password each time you run a query. Instead EPM 11 will send your operational data credentials.

If you are an occasional EPM 11 user, you may not wish to use this new feature. You would simply continue using EPM 11 as you do currently. However, each time you login and process a query you will notice new pop-up message reminding you to setup the pass-through feature. You may Ignore the message. Once you click "Okay," you should see your folders and the "Host Login and Host Password" screen. Enter your Operational Data credentials and proceed as you would normally.

If you choose to use this feature, you will need to set up/change your Pass-Through Credentialing password. Go to File, Preferences, Authentication (tab on left). Enter your Operational Data username, password, confirm and select OK. If you do not see a second box to enter the confirm password, press the tab key. Using this feature will automatically send your Operational Data password each time you select the process button eliminating you from having to enter it each time you process a query.

We hope many of you give this time-saver a try. Just remember when you change your Operational Data password every 90 days, to also update it within EPM 11.

Data Dictionaries

  • RADS Data Dictionary - This Data Dictionary is a EPM 11 Dashboard with a Wildcard search, and information on selected Operational Data Tables and Views, Columns, Operational Data Documents including entity diagrams, and EPM 11 queries. The content for this Data Dictionary is dynamic with daily updates
  • Operational Data Tables and Views - last Revised 9/23/13
  • ODS.V_LOG_DATA_DICT view which includes columns: SCHEMA_NAME, OBJECT_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, OBJECT_TYPE, COLUMN_COMMENTS, TABLE_COMMENTS, PRIMARY_KEY, and PK_POSITION. This view is available within the Operational Data/REPL data source (via Microsoft Access, SQL sever, & other query tools).