Data

Cognos training to resume in August

By becky.cowin on June 30, 2017 in Cognos Upgrade, Data

Query Studio and Workspace Advanced training classes were put on hold earlier this summer in preparation for the upgrade to Cognos Analytics. Because the upgrade has been moved to spring, we will begin holding these classes monthly again, starting in August. We are trying something new to make tr...

Cognos upgrade planned for spring

By becky.cowin on June 29, 2017 in Cognos Upgrade, Data

At the user group meeting June 2, we previewed the new Cognos Analytics and shared information about plans for the upgrade timeline. Although we had discussed a possible fall upgrade, some compatibility issues with Cognos Analytics and our current version of TM1 raised concerns that prompted us t...

Cognos tool availability changes

By becky.cowin on May 26, 2017 in Cognos Upgrade, Data

As part of the work to prepare for the migration to Cognos Analytics, the BIDW team is working behind the scenes to simplify our tool assignment structure. Instead of having multiple report-authoring tools as we do now in Cognos 10, the new Cognos Analytics will have only one tool with advanced c...

Tableau versions compatible with university server

By becky.cowin on March 31, 2017 in Data

WashU’s Tableau server uses version 10.1.5 of the Tableau software. All current and potential users should be aware that in order to publish content to our Tableau server, you must be using Tableau Desktop version 10.1.5 or earlier (example 10.1.4, 10.1, etc.). Any content created in 10.2 w...

Secure university data, share responsibly

By becky.cowin on March 30, 2017 in Data

All users of university data have a responsibility to help keep that data secure. While some information in the data warehouse might be publicly available, such as data from the National Institutes of Health, nearly everything generated by a university source system requires some level of securit...

How to Get Access to the New Clinical Datamart

By becky.cowin on March 22, 2017 in Data

BIDW connected the first clinical data to the data warehouse in February, and users of the IDX Billing and Accounts Receivable system can now request access. Due to HIPAA requirements, the Physicians Billing Services (PBS) datamart approval process is slightly different than the approvals for oth...

VPN required for Cognos

By becky.cowin on February 27, 2017 in Data

Servers for the university data warehouse are located in the WUSTL Zone – a range of IP addresses that are protected with additional security and encryption features for sensitive information. A WashU Virtual Private Network (VPN) is required for access to the university data warehouse on a...

Successful launch of new financial reporting application

By becky.cowin on February 27, 2017 in Data

In collaboration with Accounting Services, BIDW released the first phase of Consolidated Financial Reporting (CFR) in mid-February. CFR is a new TM1 application developed in-house as a replacement for Hyperion Enterprise software. The first phase of the project allows users in Financial Services ...

Adding Tableau to the Data Toolbox

By becky.cowin on January 27, 2017 in Data

As announced at the Data Users’ Group meeting on Jan. 20, WashU recently purchased licenses and a server for the data visualization software Tableau. We have not yet finalized the timeline for implementation of the server, but hope to do so in the next few months. Please continue to read th...

Clinical data coming to the data warehouse

By becky.cowin on November 30, 2016 in Data

The first clinical data is on its way to the data warehouse. The project will bring data from the Billing & Accounts Receivable (BAR) system at the school of medicine into the warehouse for clinical practice reporting. Training will be available this winter, before the first phase goes live. ...