Interactive reporting allows CAT users to create and/or run queries from existing tables, display and summarize results in reports, pivots, and charts, and export the results to text, Excel, PDF, etc. CAT users are able to write database queries to provide institutional budgeted salary data for analytical and decision making purposes. These tables are data views that exist in EPM but are able to be accessed through Interactive Reporting.
The EPM data views may also be accessed directly through the EPM Data Warehouses, which also allows users to create and/or run queries and export the results.
PROCESS CONSIDERATIONS: DATA VIEWS
There are different views/tables CAT users can query data from, depending on what they are looking for. By looking up the table names below in the EPM Data Dictionary a user can find the specific names and definitions of the data points in each view.
The following views combine CAT (employee) and AAP (non-employee adjustment) data into one output:
The following views are for either CAT (employee) or AAP (non-employee adjustment) data:
a. Navigate to https://bi2.fastar.wisconsin.edu/workspace/index.jsp2. Use the Studio Client
b. Click "Explore"
c. Double-click "UW-System-Wide"
d. Double-click "Compensation Administration Tool"
e. Right-click on XXXXXXX Query.bqy; select Open As; click Interactive Reporting Web Client
(See Interactive Reporting - Running a Query in the Workspace)
f. Under the "Elements" section, double-click on "Tables"
i. Enter your E+Emplid (ex. E00012345) and passwordg. The tables/views you have access to (including the CAT views) will be listed under "Tables"
a. Helpful Links: Creating IR Connection to the I/R Studio
b. Double-click on the Studio Icon on your desktop
c. Under "Recent Database Connection Files," select "EPM.oce"
d. Click OK
e. Enter your E+Emplid (ex. E00012345) and password
f. Under the "Elements" section, double-click on "Tables." The tables/views you have access to (including CAT views) should be listed.
5. Select the data points to be queried by clicking and dragging them to the "Request" row.
7. The results from the query should populate in the Results section.
a. In the Results screen, data can also be filtered and/or sorted.8. Data can also be organized into a pivot table.
a. On the tool bar, click "Insert" and select "New Pivot"
b. Under "Elements" click and drag the data points to "Row Labels," "Column Labels," or "Facts" to create the table.
a. Click the Create New Query tab
b. Set the "Search by" box to Description and enter CAT in the "begins with" field
c. Click Search
d. Click the Show Fields button for a given view to see the lists of fields within that view, prior to selecting the view for your query.
e. Click Add Record for the Current Rate and Funding View row to use this view for building your query.
f. A message will pop up informing the user that an effective date criteria has been automatically added. Click OK
g. Using the Query tab, check the box under Fields for each field desired to be in your query result set.
h. Use the Criteria tab to enter any desired criteria.
i. Click the (-) button to delete the prepopulated effective date criteria. No results will be returned if this criteria remains in your query.
ii. Click the Add Criteria button to edit criteria properties.
iii. After choosing any desired expressions, conditions, or constants, click OK to continue.
i. Click the Run tab
j. Click the Download to Excel link at the top of the results table.
h. Click the file named "download(#).xls". the "#" will be the number of downloads processed during the current browser session. This file contains all records in the selected view and all fields selected for the query.