Using Hyperion with WISDM Financial Data

Hyperion can be used to interact with WISDM financial data. The goal of this document is to help get you started working with the WISDM financial data.

Hyperion Intelligence Client

Hyperion Intelligence Client is a web based version of Hyperion. Since the Intelligence Client is web based, the installation is extremely simple. A user may obtain the Intelligence Client after logging into Hyperion through the UW System Authentication Hub. Instructions for installing the software can be found on the DoIT Help Desk web site (located at: http://kb.wisc.edu/helpdesk/page.php?id=5853 ). Hyperion documentation may be downloaded from the web site as well. The Hyperion Intelligence Client is the recommended option for interacting with WISDM financial data.

Connecting to Madison WISDM Financial Data

1. After logging in to Hyperion using the UW System Authentication Hub, this screen will appear.

After logging in to Hyperion using the UW System Authentication Hub, this screen will appear.

2. A list of subfolders will appear under the “Madison” folder. Click on “WISDM DataViews.”

A list of subfolders will appear under the "Madison" folder. Click on WISDM Data Views.

3. At this point you will go through the installation process of the Intelligence Client if you don’t have it installed on your computer.

4.Here is the resulting screen once Hyperion Intelligence Client loads your request. Click on the plus sign next to the word “Tables”.

Here is the resulting screen once Hyperion Intelligence Client loads your request. Click on the plus sign next to the word "Tables".

5. Once the plus next to “Tables” is clicked, Hyperion will prompt you for your login information, as seen below. In the “Host User” field, type in your old WISDM username. In the “Host Password” field, type in the password connected to your old WISDM username.

Once the plus next to "Table" is clicked, Hyperion will prompt you for your login information, as seen below.

6.The Data Views you are authorized for will appear under “Tables”. Here is an example of what yours might look like (you may not have access to all the views listed here).

The Data Views your are authorized for will appear under "Tables". Here is an example of what yours might look like (you may not have access to all the views listed here).

Appendix A – TNS Names Entry

If the TNSNAMES.ORA file does not contain an entry for the WISDM database, add the following lines to the TNSNAMES.ORA file. If you are not sure how to update this on your computer, please contact your technical support person or department.

WISDM = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = tcpcom.doit.wisc.edu)
          (PROTOCOL = TCP)
          (Host = wisdmdb.doit.wisc.edu)
          (Port = 1526)
        )
     )
    (CONNECT_DATA =
       (SID = SFMRT)  
     ) 
   )


Business Services Home | 'How-To' Pages | Acronym Index