Enterprise Data Warehouse

Cognos Reporting Replacing Query Studio

With the upcoming deprecation of Internet Explorer in August, 2021, Cognos Query Studio is reaching its end-of-life. Fortunately, there's another feature in Cognos that you can use for ad-hoc report building called simply Cognos Reporting.

New UCPath Reports Organization Structure

In order to make our UCPath reports easier to find, we have reorganized the folder structure in Cognos.

In order to make our UCPath reports easier to find, we have reorganized the folder structure in Cognos to more closely align with each report's intended purpose.

The "UCPath CDW" folder in Team Content will now have the following sub-folders available (the highlighted folders are new):

The new "Funding - Payroll Ledger – Financial" folder has been further broken down into the following sub-folders which include the reports listed below each:

EDWS Scheduled Maintenance on May 17, 2020 from 6:00 a.m. to 8:00 a.m.

IT Services will be performing maintenance to the Enterprise Data Warehouse Services (EDWS) on Sunday, May 17th.

On May 17, 2020, at 6:00 a.m., IT Services will be performing a code update to the Enterprise Data Warehouse Services (EDWS). The update will reduce downstream sync issues that have been prevalent the last few weeks.

The EDWS service will remain available during the update. We expect the update to be completed within two hours.

The QDB Server Has Been Upgraded

The QDB Server has been upgraded from SQL Server 2008 to SQL Server 2014.

The QDB Server has been upgraded from SQL Server 2008 to SQL Server 2014. With this upgrade comes the requirement that you must use TLS version 1.2 as lower versions have been disabled.

As a result, if you're connecting to QDB via an ODBC connection (e.g. using Microsoft Excel or Access), you may need to install some updates on your computer or have your IT team do so for you.

Cognos Has Been Upgraded

The Data Warehouse team has upgraded Cognos to the newest version!

In order to take advantage of all the exciting new features and to allow us to provide future enhancements, the Data Warehouse team has upgraded Cognos to the newest version!

Cognos Analytics 11 provides a streamlined and more intuitive user interface than previous versions. It includes the following upgraded features:

Analytics and Reporting Group Established

In order to review, prioritize, and approve all report requests, we have established the Analytics and Reporting Group (ARG).

In order to review, prioritize, and approve all report requests, we have established the Analytics and Reporting Group (ARG) which consists of representative stakeholders from all key departments.

The purpose of this group is to provide oversight and management of UCPath report deployment and modification to ensure that reports are accurate and appropriate for use across the UCLA reporting community

New UCPath Reports Available

EDB has produced 10 new reports.

Since UCPath went live in September, the Enterprise Data Warehouse team has strived to provide comprehensive reports that meet a wide range of needs.
 
We started with reports identified by the user-base as top priority and have since, not only modified those "Day One Reports" based on feedback and suggestions, but have also worked diligently to analyze incoming requests and produce more key reports.
 

SSL Certificate updates on Thurs, 1/17/19

On Thurs, 1/17, the Network Services team will update the SSL certificates for some services.

On Thurs, Jan. 17, at 7 p.m., the Network Services team will be updating the SSL certificate to remove weak ciphers, as part of following security best practices for the A10 Load Balancer. Connections to the Enterprise Data Warehouse application will be briefly interrupted while the SSL certificate is updated.
 
If you experience issues after the update, please contact help@it.ucla.edu or call us at 310-825-8000.

QDB ACCOUNT MAINTENANCE IS GETTING A BOOST

As of Sunday, July 1st, 2018, you will be able to manage your QDB Logon account at the same site where you manage your UCLA Logon account!The Enterprise Data Warehouse team is joining forces with the UCLA Identity and Access Management team to bring you a more secure and user friendly enhancement for QDB Account maintenance.