OneStream: Consultant Bootcamp (5 days)

Image

HOME | TRAINING COURSES

How Can I Take this Course?

Keyteach offers private training classes tailored exclusively for your team, providing a focused learning experience.

Upcoming global instructor-led scheduled training classes. Discounts are available for OneStream Partners.

Keyteach logo featuring the European Union Flag next to the word 'Keyteach' in blue text. OneStream: Consultant Bootcamp *Virtual or In-Person* (Keyteach Instructor)
02-Nov-2026 9:00 am
Manchester UK - Keyteach HQ OR Live Online (VIRTUAL) UK Time
Price: £3850 GBP
Keyteach logo featuring the American Flag next to the word 'Keyteach' in blue text. OneStream: Consultant Bootcamp *Virtual* (Keyteach Instructor)
02-Nov-2026 9:00 am
LIVE ONLINE Instructor-Led Training (USA ET Eastern time)
Price: $4800 USD

Would you like to arrange a private class for your team?

Keyteach provides the flexibility to deliver this instructor-led course on dates that suit your team’s schedule. Private classes, conducted live online with a remote instructor, require a minimum of three participants. Alternatively, we can arrange in-person training at your location upon request.

Request Private Class

Course Summary

The OneStream Consultant Bootcamp is a comprehensive five -day, hands-on training course designed for consultants responsible for implementing, configuring, and supporting OneStream applications. The course takes delegates through the complete application lifecycle, from application creation and data loading to application design, workflow configuration, security, calculations, and reporting.

Audience

  • Implementation Consultants

Duration

  • Instructor-led training: 5 days (35 CPE Credits)

Course Description

Upon completing the OneStream Consultant Bootcamp, delegates will have developed a complete end-to-end understanding of the OneStream platform, from application design and implementation through to financial processing and reporting. They will have practical experience building a fully functioning OneStream solution and will be equipped with the skills required to contribute effectively to implementation projects, application support, and ongoing solution development.

Learning Objectives

Upon successful completion of this course, participants will be able to:

1. Navigate and administer the OneStream platform, including workflows, Cube Views, forms, and application settings to support financial processes.

2. Design and configure a OneStream application by creating and maintaining dimensions, cubes, metadata, workflows, and security using industry best practices.

3. Load, validate, and transform financial data by configuring data sources, transformation rules, Source IDs, and Data Management processes to ensure accurate and auditable data integration.

4. Implement and manage financial consolidation processes, including foreign currency translation, intercompany processing, journals, confirmation rules, workflow certification, and financial calculations.

5. Develop and customize reporting solutions by creating Cube Views, input forms, dashboards, books, Quick Views, and Excel-based reports using OneStream Spreadsheet and XF Functions.

6. Apply consulting best practices to build scalable, maintainable, and secure OneStream solutions through practical configuration exercises and implementation challenges.

Day 1: OneStream Fundamentals and Workflow

Build confidence using OneStream by learning platform navigation, Point of View, Cube Views, data loading, forms, and the core workflow process.

  1. Access and Navigation in OneStream
  2. Setting the Cube Point of View (POV)
  3. Working with Cube Views
  4. Loading Data
  5. Working with Forms
  6. Certifying the Workflow Period

Day 2: Application Creation and Metadata Management

Build the foundation of a OneStream application by creating the application, configuring core dimensions and properties, and managing metadata using OneStream and Excel-based tools.

  1. Creating a OneStream Application
  2. Building Scenarios and Core Dimensions
  3. Time Profiles and Application Properties
  4. Working with XML
  5. Using the Excel Dimension Template
  6. Using the Excel Metadata Manager
  7. Moving Members in Dimensions
  8. Metadata and Data Extract

Day 3: Application Design and Data Integration

Design and configure the application architecture by building dimensions, cubes, workflows, security, and data integration processes.

  1. Adding Detail to the Flow and Account Dimensions
  2. Cube Design and Build
  3. Extensibility Challenge
  4. Creating and Assigning Security Groups
  5. Application and System Security
  6. Building the Workflow
  7. Creating Data Sources
  8. Creating Transformation Rules
  9. Creating a Source ID
  10. Challenge – Importing a Fixed File
  11. Challenge – Loading FP&A Matrix Data

Day 4: Financial Processes and Business Rules

Configure and manage core financial processes including FX, intercompany, journals, workflow certifications, calculations, and Data Management.

  1. Setting FX Rates
  2. Setting up Intercompany
  3. Reviewing and Fixing Intercompany
  4. Creating Journal Templates
  5. Confirmation Rules
  6. Certifying Questions
  7. Getting Started with Financial Calculations
  8. Dynamic vs. Stored Calculations
  9. Calculation Process Types
  10. Calculation Statuses
  11. Running Calculations Through a Workflow Process
  12. Running Calculations Through a Cube View
  13. Data Management

Day 5: Reporting and Analytics

Develop reporting and analytical solutions by creating Cube Views, forms, dashboards, books, Quick Views, and Excel-based reports using OneStream Spreadsheet.

  1. Creating a Cube View
  2. Formatting Cube Views
  3. Cube View Templates
  4. Expansions and Substitution Variables
  5. Parameters and Prompts
  6. Calculated Columns
  7. Creating Form Templates
  8. Reviewing Dashboards
  9. Books and Reports
  10. Cube View Connections
  11. Quick Views
  12. OneStream XF Functions for Excel Reporting

National Association of State Boards of Accountancy (NASBA)

Image
  • Course title: OneStream: Consultant Bootcamp
  • Duration: 5 days
  • Audience: Implementation Consultants
  • Pre-requisites: None
  • Delivery method: Group Live and Group Internet-Based
  • Advanced preparation: None
  • Recommended CPE credits:
    Group Live and Group Internet-Based: 35 credits - computer software and applications
  • Programme level: Intermediate

Keyteach is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. Registration ID No 115820. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Any complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org

KEYTEACH