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 email@example.com 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 firstname.lastname@example.org 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.
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.