Frequently Asked Questions

COGNOS

What is the URL for the Cognos Cubes and Reports server? I have a new computer and do not have it bookmarked.

The URL is https://iq-data.austin.utexas.edu (UT VPN connection required off-campus)

How do I begin using IQ (Cognos) for my information needs?

Cognos access and training are restricted. See the Cognos Access and Training page for more information.

What is Business Intelligence (BI)?

Business intelligence (BI) is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions. BI applications include the activities of decision support, query and reporting, online analytical processing (OLAP), statistical analysis, forecasting, and data mining.

What is Cognos?

IBM Cognos is a leader in business Intelligence (BI) software for the enterprise. With Cognos tools, administrators have the power to retrieve the data they need through transparent and meaningful reports.

The University of Texas has an enterprise license for Cognos software. The Cognos toolset consists of several applications that run on a web server, making it possible to retrieve reports from almost any computer through a web browser.

Why use the IQ and the Cognos business intelligence tools?

The IQ data warehouse combines information from many different campus systems in one location. Because the information is stored in a central repository and the web-based tools are easy to use, the information needed to make data-driven business decisions can be accessed easily and quickly. Extensive business rule documents are included to explain calculations, terminology, and relationships between the information.

How do Cognos users make suggestions for enhancements or send new proposals?

The IQ team welcomes your suggestions. Please complete the Enhancement Request form.

Or, for new project requests, complete the New Project Proposal form.

How much does this service cost?

There is no charge to the departments at UT Austin for using IQ/Cognos. However, when a new subject area is added, resources are needed from the subject area data steward's office.

What are the computer requirements?

The requirements for MAC and Windows computers are essentially the same. Both require a web browser, Adobe Reader, and Microsoft Excel. However, Cognos only supports Internet Explorer and Firefox browsers. Internet Explorer is the recommended browser for PC (Windows) users, but Firefox may also be used. Firefox is the only browser option for MAC users. See the Supported Internet Browsers and Settings document for more information.

May I access Cognos from my personal computer or laptop?

Yes, you may access Cognos from your personal computer or laptop while at home or away at a conference. However, you must first download the UT VPN to your personal computer or laptop. After the VPN is loaded onto your personal computer or laptop, connect the VPN each time before you logon to Cognos. It is also necessary to disconnect from VPN once you log out of Cognos.

My report downloads will not display. Are there any special browser settings?

Yes, Pop-Up Blocker MUST be OFF; follow the steps on the Supported Internet Browsers and Settings document to set your computer for Cognos use. In addition to the browser settings, when exporting a report from HTML or PDF to Excel, you may have to open your “View Downloads” box (available from your browser’s Tools Menu) to display the Excel file.

My cube options are not working; I cannot filter on a dimension - what is the problem?

PC users who use Internet Explorer browser (version 10 or higher) MUST enable Compatibility View. If using Chrome v 65+ it does not display the Cognos cubes correctly; switch to Firefox or Internet Explorer when accessing IQ-Data. See the Supported Internet Browsers and Settings document to set your computer for Cognos use.

TABLEAU

What is Tableau?

Tableau is a software tool used for visualizing data. Tableau is utilized for the creation of interactive dashboards, charts, and storyboards that allows the producer (author) to tell a data story in a visual manner. The Tableau producers use the Tableau Desktop software to create visualizations; the visualizations are then published to the IQ Tableau server where consumers may view the visualizations.

Who can access a published Tableau visualization?

Production visualizations can be shared with the University of Texas at Austin employees (valid EID is required). Security permissions can be set by subject area or at the College/VP level for UT Austin access. Visualizations intended to be shared with the public cannot contain sensitive, protected, or private information.

How do I get the Tableau Desktop software?

Follow the instructions on the Tableau Request Form.

Are there any training tutorials available for Tableau desktop producers?

Yes, visit the Tableau website for on-line training videos.

Is there a glossary available for new Tableau desktop producers?

Yes, see the Tableau Glossary and Visual Cues document.

I'm a new Tableau desktop producer, how do I connect to a data source?

See the Connecting to a Tableau Data Source document for step-by-step instructions.

Are there style guidelines or best practices I should use to build my Tableau visualization?

Yes, see the Tableau Visual Analysis Best Practices document.

Can I embed my visualizations into my department's secured web page without prompting my users to login to Tableau?

Yes, see the IQ Tableau Ticketed Authentication Guide document for step-by-step instructions.

How do I publish or move my visualizations on the IQ Enterprise Tableau server?

See the Publishing to the Enterprise Tableau Server document for step-by-step instructions.

Web Services

What is a REST service?

REST (Representational State Transfer) is a protocol for enabling computer-to-computer communication over HTTP. IQ customers send a request in the form of a URI, and the REST service returns a response in JSON format.

What is the IQ REST service?

The IQ REST Service is intended for use by new systems and mainframe-based systems that are being rewritten. The REST service provides direct programmatic access to institutional data including, but not limited to, human resource, financial, and research (award) data. The goal of this service is to enable historical, current, and projected reporting and analysis capabilities and to assist with planning for future needs.

How do I get access to the IQ REST Service?

Follow the instructions on the IQ Data Access Request Form.

Whose data can I see in the IQ REST Service?

Developers will be able to access unit-level data that is specific to their area for the data feeds for which they are authorized or institutional level data when appropriate. All access must be approved by the relevant data steward(s).

What data is currently available from the IQ Rest Service for programmatic access?

Visit Anypoint Exchange under the home page for the “IQ REST” API to see the feeds currently available as well as the data provided in each feed. Additional information can be found on the legacy IQ REST Services wiki.

Is the IQ REST Service appropriate for general EID lookups?

No, that information would be better sourced from TED or another ITS source. However, we can provide EID and UIN for any records that we are returning (e.g., for an employee feed).