© 2015-2024. MindStreamAnalytics.com

Oracle Analytics Cloud

Integration of Oracle Analytics Cloud (OAC) with Workday

Oracle Analytics Cloud (OAC) has made great strides in becoming a top tier analytics tool by providing a quick-to-deployment solution that can consume data from a broad variety of sources. This data can then be stored within a multidimensional cube within the Essbase component of OAC and analyzed via Oracle's Data Visualization tool. This creates a fantastic, flexible solution for self-service or published analytics.

Typically, an organization utilizing OAC also has a variety of transactional systems that are ripe for integrating and analyzing via OAC.

Workday is a well-established solution for cloud-based financial and human capital management. This means it will have a deep well of data related to the business that can provide insights and understanding to every level of your organization. Integrating OAC with Workday can provide that analysis and make it available across your organization.

OAC can be integrated with Workday in one of two ways:

  • 1. Through direct connect capabilities that come standard in OAC
  • 2. Through the use of flat files that are generated by Workday and consumed by OAC

This blog will focus on the second bullet - Integrating metadata and data through the use of flat files. Keep in mind, this whole process can be automated and scheduled based on your business requirements.

Metadata Loads - Flat File

The first step in integrating metadata with OAC using Workday is to have Workday provide the file extracts needed with all information called out in the file. The file should be provided in a comma or tab delimited .txt file with all parent-child relationships residing within the file. OAC will use the parent-child relationship to build the hierarchies needed in the outline.

For example, if trying to automate the build of an account hierarchy in OAC, the file might look something like this:


Assets,10000,Accounts Receivable

Liabilities,200000,Accounts Payables


Net_Income,60000,Operating Expenses

By using dimension load rules within OAC, this file can be loaded directly into the OAC file repository and then ran through the load rule created specifically for the account dimension. What you would typically see is two metadata files for each dimension being sourced from Workday. The first file would contain all level 0 accounts and their respective parents (level 0 referring to the lowest level members in the hierarchy). The second file would contain the parent member build. Using the example above, the second file would have the detail needed to map Assets to Balance Sheet and Net Income to Income Statement. It is ok if the files being provided have extra columns with details not needed, these columns can be ignored within the load rule.

Metadata load rules also give us the ability to add prefixes or suffixes to the members coming over from Workday. A best practice would be to give a prefix before all level 0 members. For example, we might want to add "A_" before all the account member names so they would look something like "A_40000". The purpose of this is to eliminate the chance of any duplicate member names or aliases within the application.

Data Loads - Flat File

Separately from metadata loads, data loads can be built within the OAC application. Again, starting from the Workday side, we would need to extract a format friendly file with all the required information needed to be called out in the file. To provide an example of how this file might look, let's assume we have 7 dimensions in our database: Account, Company, State, Period, Year, Scenario, and Version. Based on this, the file might look something like:




Through the load rule, we would be able to map each column to a specific dimension to tell the data where to go. Notice how Scenario and Version are not called out in the file. This is okay since these are typical descriptors that are specific to OAC. Through the load rule, we would be able to prepopulate a field needed to load our data into the "Actual" scenario and the "Final" version.

Overview of Automation

This entire process can be fully automated from the extract of Workday data to the import of that data into OAC. Here are the required components to automate the process:

  • A SFTP utility - needed to pull the files that are being extracted from Workday and place them on the server
  • A small server - needed to hold the extracted Workday files, any backups of the application, and a scheduler that can kick off the command line jobs
  • OAC Command Line Utility - this is the automation utility that comes standard with OAC. Command line scripts can be created that will pick up the updated Workday files on the server, replace the current files in OAC, and then execute the metadata and data load rules.

Assuming the automation process runs overnight, users will have the ability to access the most up to date actuals for the current year to provide for better and faster analysis. This process could be scheduled to run on more frequent intervals as required by the business.

Partner SpotLight


Oracle has the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce cost..

Oracle Profile

Our Company

MindStream Analytics' senior staff was there at the birth of Business Intelligence. We have been part of building Business Intelligence nationally from its humble niche product status to the ubiquitous analytic tool that it is today. MindStream consultants are well versed in reporting and information management and are ready to help you leverage the power of multiple tier-1vendors. From Oracle Hyperion to IBM Cognos, we can help you select and integrate the right tools for you to better understand your information. MindStream Analytics has experience across a wide variety of industries: Business Services, Consumer Products, Energy, Financial Services, Healthcare, Manufacturing, Transportation , and Telecommunication. We have the depth and breadth of experience to help you deliver actionable information to users.

Whether you need an enterprise wide Oracle BI Enterprise Edition (OBIEE) rollout, an Oracle BI Apps rollout, or an IBM Cognos ReportNet rollout, MindStream Analytics is here to help you succeed.

Case Studies


Thanks to the intervention of MindStream Analytics, Accumen's Finance department can now model their business with a new, more organized structure that isn't conventionally available in NetSuite.

Acme Brick

Acme Brick turned to MindStream Analytics for help implementing OneStream to replace their outdated TM1 solution.


Alterra sought the expertise of MindStream to address the challenges they faced in their Capital Planning process.

ATCO Group

Energy conglomerate ATCO operates worldwide in utilities, power generation, and related services.


Working with MindStream Analytics, Avalon Healthcare Solutions adopts NetSuite Planning and Budgeting to accelerate budgeting and forecasting processes.

Bayer Health Care

Bayer Healthcare implemented Hyperion Planning and Workforce Planning in 10 weeks to dramatically streamline their Income Statement budget and Workforce Planning process..


MindStream Analytics' partnership with BluEarth Renewables epitomizes the power of technology and collaboration.


An Oracle Hyperion Planning Upgrade provides multi-national organization Hyperion Application optimization and stabilization.

Cleaver Brooks

OneStream XF was chosen as the platform that would transform Cleaver-Brooks' Finance processes.


The collaboration between CoorsTek and MindStream resulted in significant improvements in CoorsTek's financial consolidation and reporting processes.

Elite Body Sculpture

MindStream Analytics' collaboration with Elite Body Sculpture encapsulates the transformative potential of targeted tech solutions in streamlining administrative processes.


Enlyte, a merger of Mitchell, Genex, and Coventry, faced challenges with disparate financial solutions and the need for combined reporting.


MindStream Analytics collaborated with Flanders to implement OneStream Consolidation and Reporting solution.

Foley Products

Foley Products was facing a significant challenge with its Excel-based actual management reporting system.

Harte Hanks

The collaboration between MindStream Analytics and Harte Hanks culminated in a highly customized, user-friendly NetSuite implementation.


Interface used a complex, manual, excel-based FP&A process for monthly review, and the summary data was loaded in OneStream.

Kymera International

Thanks to Mindstream Analytics' assistance, Kymera was able to load all of their data into OneStream and validate it successfully.

MacLean Fogg

MacLean-Fogg partnered with MindStream, a leading implementor specializing in modernizing and optimizing enterprise systems.


MindStream's expertise and experience were sought to conduct a vendor selection initiative focusing on MEPPI's F2023 planning process.


MindStream Analytics and OUAI's collaboration showcases the transformative power of strategic technological intervention.


By migrating to OneStream, Plaskolite has achieved a material reduction in consolidation time and overall Financial Close cycle, eliminated the hours spent compiling and verifying data in Excel, streamlined its Planning, Budgeting and Forecasting model and delivered flexible and timely reporting that enables more strategic analysis of their financial data.


Understanding the nuances of Redwire's challenges, MindStream Analytics devised a holistic approach to overcome them. The implementation of NetSuite was just the beginning.


Simon's existing corporate Hyperion Financial Management (HFM) production application was consolidating at a rate of seven hours, a performance issue causing great headache to corporate Accounting.

Source Code

The successful transition to OneStream revolutionized Source Code's financial reporting.


Subway collaborated with MindStream Analytics for the NetSuite Analytics Warehouse implementation.


MindStream Consulting and AppCare team members are proud be working side by side with UPenn university in accomplishing this implementation and along with continuing our AppCare services after go-live.


USG was an Oracle Hyperion customer realizing that it needed more specialized support for its various Oracle Hyperion applications.


Dividing a hyperion planning application, expanding the hyperion footprint to forecast on the business? Customer categories.

Versant Health

Versant Health engaged MindStream to help resolve the challenges they were experiencing with their consolidation, close, and financial reporting processes.

Virginia Spaceport Authority

The MindStream team implemented the Standard + Workforce NetSuite Planning & Budgeting.


MindStream Analytics determined that the best solution was to implement Oracle Essbase Cloud as part of the Oracle Analytics Cloud (OAC) platform-as-a-service


Innovative use of essbase to streamline and connect hyperion financial management for enhanced financial analysis.

XY Planning

MindStream Analytics, well-versed in addressing such challenges, presented a comprehensive Netsuite solution for XY Planning.

Related Links