Reporting users have shared that sporadic data is missing from Tableau reports using the “ [CERTIFIED] Workday FIN Mart - Journal Line Detail ” Tableau data source. This data source is powered by journal line related datasets flowing into the Reporting and Analytics Environment (RAE) from Workday. T he reload/update of the journal lines data in the RAE is expected to be complete by August 24, 2022.
Starting the week of April 5, 2022, we will be working behind the scenes to reload the core Journal Line dataset from Workday into the Reporting and Analytics Environment (RAE), starting with January 2021 data and finishing through current day. The reload process is expected to be complete no later than April 15, 2022. We will load the data incrementally in monthly buckets due to the size of the files. Thus, during this 10-day period, updates will appear as the load steps complete.
There will be no system outage or downtime due to this work. Users, reports, and dashboards should not be affected. Updated and complete data will flow into your existing queries without any changes on your part. Once the reload is complete, we will send out a follow up notification.
As shared in October , progress continues on the retirement of the legacy reporting systems tied to PeopleSoft HR and Finance, and will be complete at the end of calendar year 2021. In preparation for the shutdown, multiple activities have been completed or are ongoing to ensure that business and data analysts will have access to legacy data as needed. See the full post for more details and additional activity highlights.
Remaining activities for the university's Workday rollout include the retirement and shutdown of PeopleSoft data sources, BuckeyeOasis tools, and eReports and BuckIQ reporting services. Beginning November 1, access to these systems will be restricted to a small group of core users prior to system shutdown on December 31, 2021. Please review the full announcement for more detailed information on how to access common reports and historical data using new data tools.
The OCIO Data and Analytics group continues to refine and improve the tools and processes it provides to Ohio State for the purpose of analyzing enterprise data—the data generated from university administrative functions (finance and supply chain, student information, human resources, payroll, and grants).
This update shares the latest developments for our current toolset which includes: the Reporting and Analytics Environment (RAE), Tableau and Collibra.
