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


New Field Added to Financial Transactional Reports - February 19, 2020

Attention: IQ/Cognos Financial Customers    

In response to a recent request, IQ (Information Quest) is pleased to announce we received approval to add a new column, Vendor EID, to the Cognos financial reports (Checkbook, Transaction Detail, and Transactions by Object Codes) and the MFR Cube drill through report. The new Vendor EID column is next to the Vendor Name column in the reports.

The updated reports are now available to all Financial Cognos customers who use IQ-Data (cubes & reports).

Vendor EID Definition:

  • The EID is a unique Electronic Identification assigned to any entity that conducts business with the University. If the financial transaction in *DEFINE includes a UT EID, such as a payment to a vendor, then the EID is displayed in this column.

Contact us at iqhelp@austin.utexas.edu if you have any questions.


Update to Cognos Financial Year Over Year Cube - February 7, 2020

Attention: Financial Cognos Customers

Historically, “Refunds to Grantors” (object codes 9081, 9083, 9085, and 9087) have appeared within the “Expenditures” Object Code Group dimension of the Year Over Year Cube. These object codes are specific to 26-accounts and are used when funds are returned to the Sponsor.

IQ received a request to move these object codes to appear under the “Spending Authority” Object Code Group dimension. We reviewed this request with the data stewards and subject matter experts, and it was determined that these object codes are represented on the Annual Financial Report and other external financial reports, as a reduction of revenue rather than an expense.

The Year Over Year Cube has now been updated so that “Refunds to Grantors” (object codes 9081, 9083, 9085, and 9087) appear under the “Spending Authority” Object Code Group dimension.

Please contact iqhelp@austin.utexas.edu if you have any questions.


IQ Workday HCM Update - January 28, 2020

Attention: Financial/HR Cognos Customers

With UT’s implementation of Workday, the university tasked Information Quest (IQ) with the goal of developing reporting products to provide continued access to legacy data while enabling trend reporting spanning the legacy and Workday systems.

IQ has made great progress toward this goal. However, after focused effort to integrate complex Workday (WD) data structures, it is apparent that more work is required to offer accurate, comprehensive Human Capital Management (HCM) data and analytics products to the university.

As a result, IQ will pause WD-sourced products, including the HCM Worker Year Over Year Cube, while determining the best approach for obtaining HCM data with the highest degree of data veracity. IQ and Enterprise Business Information Technology Solutions (eBITS) are working together to establish high quality products using WD data.

For more details, see the IQ Workday HCM Update Document.

IQ: iqhelp@austin.utexas.edu

eBITS: askus@austin.utexas.edu


COGNOS BROWSER ISSUES:

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.

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.

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. ****Monthly Server maintenance scheduled the first Thursday of each month, 9pm-9:30pm. Service will be unavailable during the maintenance window.****

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.