Frequently asked questions about the new data warehouse and how it works in tandem with our Workday enterprise system

Reporting

Where do I go for my reports? (general info)

Please see this page for detailed information about where to go for which type of reporting.

Where do I go now to report on HRMS or FIS data?

HRMS and FIS data will be visible, though not editable, inside HRMS and AIS for approximately one year after Workday has gone live. Both during and after that year, Pre-Workday data will be reportable from within Cognos, a reporting tool that connects to our data warehouse. HRMS and FIS data from after the Workday go-live date will be reported on from Workday.

Where do I go now to report on RMS data?

RMS data will still be reported on from Cognos.

Where do I go now for WebFOCUS reports?

As part of the MyDay program, the reporting team collected reports currently used at WashU, including WebFOCUS reports, that were identified as necessary for HR and financial operations by academic and administrative units. These reports, including WebFOCUS reports, have been consolidated, designed and built in Workday.

Essentially, Workday reports should be able replace all WebFOCUS HR and financial reports. Note, though, that Workday reports will only work with data inside Workday, not pre-Workday HR or Finance data from WebFOCUS or any other system.

Pre-Workday HR and finance data, as well as other types of data, such as student data, will remain accessible in WebFOCUS until its retirement.

Has Workday replaced Cognos and Tableau as a reporting tool?

The Cognos and Tableau reporting tools are still a part of our data ecosystem along with Workday. 

You will report out of Workday for HR and FIN data generated after July 1, 2021.

Cognos is still the tool for RMS reporting and HR and FIN data from before July 1, 2021.

How does year-over-year reporting work if part of the data is pre-Workday and part of it is post-Workday?

If you need to produce a report that contains HR and/or finance data from both before and after Workday go-live, you’ll be able to do so in Cognos, a reporting tool that connects to our data warehouse. The data warehouse will contain “historical” pre-Workday data, and receive data from Workday once it goes live.

Keep in mind, though, that our current data structure and chart of accounts are fundamentally different than what we have configured in Workday. You may be able to “match up” and compare some sets of data, but as you move into more granular data, it will become more challenging.

Fortunately, this challenge will become less pronounced the longer we’re in the new system. For example, if you want to run a two-year report, you’ll be able to do that completely in Workday after two years.

How do I know what type of Cognos training I need?

The type of Cognos training you need depends on whether you are a report author or a report user. Take this quiz to help you identify the best training path for you.

Is there a Cognos report that will show current Dept/Fund vs. new Workday Account number?

Please use the FACT application to see what your dept/funds are being converted to for Workday. FACT data is not being brought into the data warehouse.

Warehouse

How does security work in the new Data Warehouse?

See this page to read about how our new RBAC security model works.

What data is in the new Data Warehouse?

The long-term goal is for the WashU data store (which includes the data warehouse) to include data from all of the university’s source systems. Initially, our focus is on loading data from key source systems to the data store. Later, we’ll begin efforts to bring in more systems’ data.

Watch the recording below from the MyDay Café session, “Connecting with our data,” presented by executive director for data management Rooji Sugathan, to learn more about the data store.

What can we do in the new warehouse that we couldn’t do before?

Our new DQM-enabled data source packages in Cognos now enable us to do multi-package reporting and cross-domain reporting. We’ll be able to answer important questions more quickly and easily, like:

  • Where do I stand with research funding?
  • How much does it cost to run an academic program?
  • How have students with a particular academic profile performed?

Governance

What is Data Governance?

Data governance ensures that WashU data is accurate, consistent, and understood through the creation of structures, processes and tools. Through these combined efforts, data governance helps WashU to manage its data as a valuable asset.

How does Data Governance address data quality and privacy?

The data governance office is facilitating the implementation of a data stewardship structure that will designate people that are responsible for different sets of data around the university. This responsibility includes subject matter expertise and addressing quality. We have started with Human Resources and Finance data as a part of the Workday launch. Thew stewardship personnel will meet regularly to discuss issues surrounding data quality, such as data definitions, to ensure clarity and consistency across our university data.

The data governance office is also partnering with the data management office to implement a data classification standard. The standard will address issues of data privacy as it relates to reporting and analytics in the data warehouse.