Accessing WebFOCUS

WebFOCUS License Information

Licenses may be purchased in person at the RAMtech Office in the Lory Student Center OR
you can download the Special Order form at RAMTech and then Email to RAMtech@colostate.edu. RAMtech will require that you include your ename, department number and account number to process the transaction. Please allow the administrator a couple of days following purchase to perform the WebFOCUS account activation.

License Costs: $125.00

Who needs a license? All campus personnel who expect to create and/or run reports within WebFOCUS will need to purchase a license. Each person is required to have their own license.

Who does not need a license? If a license holder creates and/or runs reports within WebFOCUS, they can choose to email reports to department heads or other personnel who do not have licenses. People without licenses will be able to view most emailed reports. As people create more advanced reports that offer drill down capabilities (ie. show summary high level and then drill down to details), the drill down report details will not be available to emailed non-license holders.

A license should be purchased annually and is valid until the end of the fiscal year

Blank Line
Blank Line

WebFOCUS Data Access Requirements

Many of the WebFOCUS reports are built using data from the ODS which relies on ODS security. If you are new to WebFOCUS you’ll need to request access to the data area(s) you want to report on. For example, Finance, Student, and HR. You can do this through the Security Forms page.

If you’re uncertain what your current permissions in the ODS are, you can view your ODS Information on the right-hand side of the ODS Data Dictionary.

Blank Line
Blank Line

Now Can I Access WebFOCUS

Fingers crossed, you should be all set. You can find the link to WebFOCUS on the AAR page under Application Systems. If you do not have access to the system or unable to see data in your reports, please check:

  • That you have purchased your license from RamTech
  • That you have completed a WebFOCUS training class
  • That you have submitted an ODS Data Access Request form (aar.colostate.edu)
Blank Line
Blank Line

eThority Users

If you are used to accessing your data through eThority you may find that the equivalent WebFOCUS report is blank or gives you an error. This is likely a permissions issue. You can view your ODS Information on the right-hand side of the ODS Data Dictionary. Ensure that you have access to the required area

  • Accounts Receivable
  • General Directory
  • Research Data
  • Facilities Data
  • CSU Foundation Data
  • Graduate Student Data
Blank Line
Blank Line

Special Permissions for HR and CSU Foundation Data

If you need access to either HR or CSU Foundation data, there’s one additional step required in order to access the data. One request covers both areas, HR and CSU Foundation. Fill out the Private Data Access Request online at http://informationsystems.colostate.edu/security-forms/ (second link in the left column) following the instructions below.

  • The top portion will be automatically filled out.
  • Leave ‘Database Account’ blank.
  • Leave ‘Access for College/Department’ blank.
  • Select ODSPROD for the ‘Database’
  • Enter the department(s) you need access to and the justification in the ‘Justification’ box. You can enter X as a wildcard (ex. 8XXX or 16XX) if you have a lot of accounts
  • Check the ‘Statement of Use and Understanding’ box (after reading)
  • Check only ‘Human Resources Data’
  • Enter VPD ACCESS ONLY in the ‘Human Resources Data: Table, View or Role’ box
  • Click ‘Next’
  • Sign the request

The request will go your supervisor. Have your supervisor sign it. If they choose not so have it go up the signature chain, it allows them to do that but they will get a second request for signature which they must sign too. Then the request will automatically go to HR for action.