Homepage

alt="Gathering Data"

Information Quest (IQ)

IQ delivers business intelligence tools, data warehousing, and analytical tool training that empowers The University of Texas at Austin to make data driven decisions and gain value from academic and administrative data.

IQ operates within the Financial and Administrative Service portfolio and is comprised of staff specializing in IT service delivery for data warehousing and business intelligence. Read more »

ALERTS & ANNOUNCEMENTS

3/19/19 - Cognos 11.1 Upgrade

The Cognos upgrade was successfully completed. If you experience any problem logging into Cognos:

  • Clear your browser cache/history
  • Open a new browser session
  • Log into Cognos again

Please wait for the log in credentials to process, if you hit enter and repeatedly click the Login button, a “namespace” login error message might appear. Your login is still being processed and you will be taken to the main portal screen momentarily.  


12/20/18 - IQ Workday HCM Deliverables Released to Authorized Campus Users in Data Validation

To: Financial/HR Cognos Customers

IQ has released the HCM Year Over Year (YOY) cube and drill through report in Data Validation. While in data validation, do not use the deliverables for a business/reporting purpose until you have verified the data against the source system.

As you start working in the cube to validate your area’s data, please read the draft business rules document to help you understand the cube logic as well as the definitions for dimensions and measures.

Note: The cube is not currently on an auto refresh schedule and will be refreshed on an as needed basis during validation.

Please contact us at iq-bi@austin.utexas.edu if you see any data issues that require remediation. To assist you with validation tips and cube navigation, IQ will schedule work sessions after the winter break.

Additional HCM Data Access:

  • Legacy Appointments and HRMS data is available via Cognos frozen cubes and reports.
  • Current HCM data is available via Workday native reports.

11/6/2018 - Cognos HR/Payroll Legacy Data Frozen:

As we have been communicating over the past few months, the legacy HR/Payroll data from Define and HRMS in the Cognos cubes, reports and report authoring package are now frozen. Legacy HR/P data from Define and HRMS are no longer being refreshed during the IQ nightly processing.


COGNOS BROWSER ISSUES:

FIREFOX v57+ ISSUE on IQ-AUTHOR

Firefox (v57+) is causing error messages in the Cognos Report Authoring tool. The solution is to use Chrome or Internet Explorer when accessing IQ-Author.

CHROME v65+ ISSUE on IQ-DATA

The Cognos cubes do not display correctly when using Chrome v65+. The solution is to use Firefox or Internet Explorer when accessing IQ-Data.

Service Status for Data Consumers

Cognos Cubes & Reports

All Cognos cubes and reports are currently available.

Tableau

IQ Enterprise Tableau servers are currently available. The servers are running version 2018.2.6

Service Status for Developers

Cognos Report Studio

All Cognos report authoring packages are currently available.

Web Services

All REST data feeds are currently available.

Oracle-As-A-Service (IQ Direct)

Oracle-as-a-Service (IQ Direct) database is currently available.