University of Wisconsin Stout | Wisconsin's Polytechnic University

How Do I Get Access to the Data Warehouse?

All who have been given appropriate authorization can request access to any of the data warehouses mentioned above. Self-service reporting can be done at no charge utilizing the resources available on this site, including the Query Library that houses commonly-used queries and reports. The campus-wide supported query tool used to access data in any of the warehouses is the Interactive Reporting Work Space (currently Hyperion Interactive Reporting v11.1.1.4).

Data Leads

"Data Leads" are designated power users of Interactive Reporting and the RDS data that can help get specific data for a particular college, unit, or office. If you are new to reporting, the data lead for your area is a good place to start. The Data Lead webpage provides information on the program as well as links on how to get additional information.

Using Data to Assess, Evaluate, and Plan

University personnel require data in order to assess, evaluate, and plan. However, it isn't always clear where the data can be found, who can get at it, how it is accessed and how to interpret it accurately.
Student information is collected at the time of application and stored in PeopleSoft Campus Solutions (AccessStout). Much of that data is subsequently collated and stored for end-user access in the data warehouse, Reporting Data Store (RDS). Each evening data is loaded into the RDS where it can be readily accessed using query tools. Current, historical and data collections, e.g. data related to applications, are available.

Additional Data Warehouses

There are also two additional data warehouses available for use. These systems are not administered here at UW-Stout and may require additional access requests.

• General ledger, PO, budget and expenditure data is available via WISDM (Wisconsin Data Mart)

• Budget and personnel data is available via InfoAccess and HRS EPM (Enterprise Performance Management)

How to Submit a Request 

To submit a request, you must log in to the Project Request System.

1. Click on Submit Request.

2. Select Project Request.

3. Fill out the form as completely as possible.

4. Click the Submit Request button. This will initiate a request for a report to be developed and assigned to a developer. You will receive an email notification informing you that the project request has been submitted.

Several Interactive Reporting queries are available for use across campus. Most of these queries use the RDS Data Warehouse to gather Student or Admissions related data. The results of these queries can be exported to Microsoft Excel for additional filtering or manipulation. There are also some financial queries based on WISDM and human resources HRS EPM. 

Requesting new published queries

If you have an idea for an Interactive Reporting published query that could be used across campus, you can put in a request to have the query created and published.

Access to HRS EPM queries

UW-Madison creates and maintains several queries against the HRS EPM system to pull employee related data. Due to the sensitive nature of this data, additional steps must be taken to gain access to this data and get permission to view and run these shared queries on Hyperion. Contact Jo Johnson in Human Resources for access and more information.

Data Owners

The following data owners are contacted when users attempt to get access to the data.

How to Obtain a User ID

In order to run the published queries, each user will need to have an ID on the Hyperion Interactive Reporting system and the Interactive Reporting web client plug-in needs to be installed on the Internet Explorer browser.

To get an ID on the Interactive Reporting site:

1. Email your request to the the PeopleSoft Technical Support Team. Include your name, email address, and which reports you are looking to run.

2. The campus Interactive Reporting Admin will contact FASTAR to have an ID created. The campus admin will also contact the data owners related to the reports in order to get permission to provide access.

3. If you already have an ID but would like access to additional reports, send that request to the PeopleSoft Technical Support Team. The campus administrator will contact the data owners to get permission to give you access.

4. Once the ID has been created, you will receive a notification from the campus Interactive Reporting admin. If you are a new user, this email notification will include attachment documents detailing installation, troubleshooting, and user documentation.
   

There are also "power users" and data leads who create and run adhoc queries on their own using the Interactive Reporting Web Client. In addition to a Hyperion Interactive Reporting ID, these users will need to have developer level access to Hyperion and a separate database user ID and password to use while creating and running the queries. A separate user ID and password is needed for each database system the user plans on connecting to and querying. 

Access to Shared Financials /
WISDM / SFS Data Queries

Most of the Shared Financial queries go against WISDM data. Some of these queries require an additional WISDM database user ID and password to run. Contact Sheila Williams or Sheri Olson in the Business and Financial Services for access and questions.

Helpful Documentation

All Hyperion Interactive Reporting documentation is included on the Interactive Reporting site under the STOUT\About Interactive Reporting (Hyperion) folder. These documents include tips on installing the web client as well as answers to the most commonly encountered issues (under the table of contents).

Documents included are:

• Downloading and Installing the Interactive Reporting (Hyperion) Browser Plug-In (includes screenshots)
  

• Troubleshooting

• User Document

• Developer Document

• Additional Interactive Reporting 11 technical documentation
  

Hyperion Interactive Reporting Web Client

The main tool used for querying and reporting data at UW-Stout is the Hyperion Interactive Reporting Web Client. This tool runs within the Internet Explorer web browser on a Microsoft windows computer.
Currently, there are several published reports and queries that can be run by users to gather data. The data gathered from these reports can be exported to an Excel spreadsheet for additional filtering and manipulation. 

In addition, users can have the option creating their own ad-hoc queries for gathering data. This requires additional skills and data knowledge on the users side, as well as additional database level access and access to develop queries.