This curriculum develops OneStream capability from platform fundamentals through applicationconfiguration, data integration, workflow, reporting, business rules, consolidation, planning, analytics,administration and production operations. Learners progress from understanding core CPM architecture tobuilding and supporting a realistic OneStream solution.

Course overview

About the OneStream program.

This curriculum develops OneStream capability from platform fundamentals through application configuration, data integration, workflow, reporting, business rules, consolidation, planning, analytics, administration and production operations. Learners progress from understanding core CPM architecture to building and supporting a realistic OneStream solution.

Hands-on labs and simulators

Work through OneStream in your browser. Each one is sold on its own page and opens in your dashboard.

Hands-on lab OneStream Implementation Foundations Lab Portal OS-101 $121View → Hands-on lab OneStream Administration R2 Lab Portal OS-102 $121View → Hands-on lab OneStream Core Platform Architect Certification Lab OS-201 $121View → Hands-on lab OneStream Financial Consolidation & Close Simulator OS-FCC $121View → Hands-on lab OneStream Planning Hands-On Labs OS-PLN $182View → Hands-on lab OneStream Account Reconciliation & Transaction Matching Lab OS-ARTM $121View → Hands-on lab OneStream Planning Virtual Lab OS-PVL $121View →

Why learn with BISP

Trusted by professionals across 30+ countries.

Industry trainers

Certified consultants with 12+ years of real project experience.

Hands-on practice

Real-time scenarios & live project modules, not just slides.

Placement support

Resume building, mock interviews & job referrals.

Certification

BISP certificate + full guidance for official exams.

Course curriculum

Download curriculum (PDF)

91 modules 173 topics

01 Course overview

Professional Course Curriculum

Beginner to Advanced | CPM Architecture, Data Integration, Consolidation, Planning, Reporting, Business Rules & Capstone

Course Track	OneStream Corporate Performance Management
Level	Beginner to Advanced
Recommended Duration	25-30 Hours
Delivery	Concepts + Configuration Labs + Real-World Scenarios + Capstone
Modules	26
Outcome	Job-Ready OneStream Consultant / Developer Skills

02 Course Outcome

By the end of this program, learners should be able to configure and support a OneStream CPM application; design metadata, cubes and workflows; load and transform financial data; build Cube Views, calculations, consolidation and translation logic; create dashboards and reporting; manage security and migrations; troubleshoot performance; and deliver an end-to-end implementation capstone with governance and production support documentation.

03 Course Overview

04 Learning Outcomes 8 topics

Understand OneStream CPM architecture, application navigation and core dimensional concepts.
Design metadata, cubes, workflow profiles and extensible dimensional structures.
Load, transform and process source data using governed integration patterns.
Build Cube Views, reports, dashboards and Excel-based analysis for finance users.
Create and troubleshoot business rules, calculations and reusable formula patterns.
Execute consolidation, currency translation, intercompany and journal processes.
Configure security, migration, integrations, performance monitoring and production controls.
Deliver an end-to-end implementation capstone with reconciliation and support handover.

05 Recommended Audience 6 topics

Oracle EPM / CPM consultants expanding into OneStream
Finance systems and consolidation professionals
FP&A; and financial reporting technology teams
Data integration and application support professionals
Developers working on OneStream business rules and dashboards
Students preparing for OneStream implementation and support roles

06 Suggested Prerequisites

Basic accounting, consolidation or planning knowledge is helpful. Familiarity with dimensional financial systems, data integration, Excel and enterprise application concepts will accelerate learning, but the course begins with foundational OneStream concepts.

07 26-Module Learning Roadmap

#	Module	Track
1	OneStream Platform Fundamentals & CPM Architecture	Foundation
2	Application Navigation, Profiles & User Experience	Foundation
3	Metadata Foundations & Core Dimensions	Foundation
4	Cubes & Extensible Dimensionality	Foundation
5	Workflow Profiles & Process Control	Core Configuration
6	Data Sources, Import Channels & Data Load	Data Integration
7	Transformation Rules & Mapping Design	Data Integration
8	Data Management & Processing Sequences	Data Integration
9	Cube Views: Design, POV & Navigation	Reporting
10	Business Rules Fundamentals	Development
11	Finance Business Rules & Member Formulas	Development
12	Calculation Design, Data Buffers & Formula Patterns	Development
13	Consolidation Process & Entity Hierarchies	Consolidation
14	Currency Translation & FX Configuration	Consolidation
15	Intercompany Matching & Elimination	Consolidation
16	Journals & Adjustment Processes	Close & Controls
17	Forms, Data Entry & Planning Input	Planning
18	Reporting, Books & Management Reporting	Reporting
19	Dashboards, Components & Interactive Analytics	Analytics
20	Excel Add-In, Quick Views & Ad Hoc Analysis	User Productivity
21	Security, Roles & Access Governance	Administration
22	Integration, Connectors, APIs & External Systems	Integration
23	Application Build, Migration & Environment Promotion	Lifecycle
24	Performance Tuning, Diagnostics & Troubleshooting	Operations
25	Administration, Governance & Close Operations	Operations
26	End-to-End OneStream Implementation Capstone	Capstone

08 Module 1: OneStream Platform Fundamentals & CPM Architecture

Track	Foundation
Learning Outcome	Explain the OneStream platform architecture and identify the major components used in a CPM solution.

09 Key Topics 5 topics

OneStream unified CPM platform concepts and use cases
Core platform architecture: application, cubes, workflows and reporting
Financial consolidation, planning, reporting and analytics in one platform
OneStream terminology and major administration areas
Typical enterprise deployment and implementation lifecycle

10 Hands-on Focus

Map a sample finance use case to OneStream platform components and responsibilities.

11 Module 2: Application Navigation, Profiles & User Experience

Track	Foundation
Learning Outcome	Navigate a OneStream application confidently and locate the principal end-user and administrator work areas.

12 Key Topics 5 topics

Application login, navigation and main user interface
Application, Workflow and Cube View perspectives
Workflow profiles and user task navigation
Favorites, POV, global selections and user preferences
Understanding application roles and responsibilities

13 Hands-on Focus

Navigate a training application, set POV selections and complete a sample workflow task.

14 Module 3: Metadata Foundations & Core Dimensions

Track	Foundation
Learning Outcome	Design and explain the core dimensional model used by a OneStream application.

15 Key Topics 5 topics

Entity, Account, Scenario, Time, View, Flow, Origin and Intercompany dimensions
User Defined dimensions and business-purpose design
Member properties, hierarchies and relationships
Metadata naming, descriptions and governance standards
Metadata impact on calculations, reporting and security

16 Hands-on Focus

Design a metadata hierarchy and document core dimension purposes.

17 Module 4: Cubes & Extensible Dimensionality

Track	Foundation
Learning Outcome	Explain how cubes and extensible dimensionality support scalable OneStream application design.

18 Key Topics 5 topics

Cube concepts and cube-specific dimensionality
Extensible dimensionality and shared versus local structures
Cube configuration and application design considerations
Scenario and entity relationships across cubes
Design trade-offs for scale, reuse and reporting

19 Hands-on Focus

Sketch a multi-cube/extensible-dimensionality design for a planning and consolidation use case.

20 Module 5: Workflow Profiles & Process Control

Track	Core Configuration
Learning Outcome	Configure and explain a practical workflow structure for data collection and financial processes.

21 Key Topics 5 topics

Workflow profile hierarchy and profile types
Workflow channels, scenarios and time periods
Import, forms, journals and certification workflow concepts
Workflow status, locking and completion
Designing workflow around business ownership and close/planning cycles

22 Hands-on Focus

Build a workflow profile hierarchy for entities, scenarios and periods.

23 Module 6: Data Sources, Import Channels & Data Load

Track	Data Integration
Learning Outcome	Configure the major components required to load external data into OneStream.

24 Key Topics 5 topics

Data Source concepts and source-system mapping
Delimited file and database-style source patterns
Import channels and workflow integration
Data load lifecycle from source to staging and cube
Source data validation and error handling

25 Hands-on Focus

Configure a sample source layout and execute a controlled data import.

26 Module 7: Transformation Rules & Mapping Design

Track	Data Integration
Learning Outcome	Build and troubleshoot transformation rules that convert source values into governed OneStream metadata.

27 Key Topics 5 topics

Transformation Rule Groups and rule sequencing
Explicit, range, list and mask-style mapping concepts
Source-to-target dimensional mapping
Unmapped data analysis and correction
Reusable mapping and governance practices

28 Hands-on Focus

Create transformation mappings and resolve intentionally unmapped source records.

29 Module 8: Data Management & Processing Sequences

Track	Data Integration
Learning Outcome	Design repeatable Data Management sequences that automate key application processing steps.

30 Key Topics 5 topics

Data Management steps and sequences
Load, calculate, translate, consolidate and process orchestration
Parameters and workflow-aware execution
Scheduling and repeatable operational processing
Job monitoring and failure diagnosis

31 Hands-on Focus

Assemble a Data Management sequence and validate step-by-step processing.

32 Module 9: Cube Views: Design, POV & Navigation

Track	Reporting
Learning Outcome	Create governed Cube Views for financial analysis, reporting and workflow use.

33 Key Topics 5 topics

Cube View structure, row and column definitions
POV, parameters and member filters
Formatting, suppression and expansion behavior
Dynamic member lists and reusable reporting patterns
Drill, navigation and user interaction concepts

34 Hands-on Focus

Build a parameterized Cube View with suppression, expansion and POV controls.

35 Module 10: Business Rules Fundamentals

Track	Development
Learning Outcome	Explain when and how business rules are used to extend OneStream application behavior.

36 Key Topics 5 topics

Business Rule types and development lifecycle
Rule parameters, sessions and API concepts
Using business rules for reusable application logic
Calling rules from workflows, dashboards or processes
Testing, logging and controlled deployment

37 Hands-on Focus

Create a simple business rule and test logging, parameters and controlled execution.

38 Module 11: Finance Business Rules & Member Formulas

Track	Development
Learning Outcome	Implement and evaluate calculation logic using Finance Business Rules and member formulas.

39 Key Topics 5 topics

Finance Business Rule concepts
Member formulas and formula scope
Data Buffer and calculation-oriented concepts
Formula variables and reusable calculation patterns
Choosing metadata formulas versus rule-based logic

40 Hands-on Focus

Implement a sample Finance Business Rule/member formula and reconcile outputs.

41 Module 12: Calculation Design, Data Buffers & Formula Patterns

Track	Development
Learning Outcome	Design maintainable calculation logic that performs correctly across dimensional intersections.

42 Key Topics 5 topics

Calculation sequencing and dimensional scope
Data Buffer concepts for efficient data manipulation
Reusable formula patterns and parameterization
Handling missing, zero and derived data
Calculation testing and reconciliation

43 Hands-on Focus

Build a calculation scenario using reusable formula patterns and validate results.

44 Module 13: Consolidation Process & Entity Hierarchies

Track	Consolidation
Learning Outcome	Explain and validate the OneStream consolidation process across an entity hierarchy.

45 Key Topics 5 topics

Entity hierarchies and consolidation ownership concepts
Consolidation lifecycle and parent-child processing
Entity aggregation and consolidation states
Scenario/time considerations during consolidation
Reviewing consolidated results and diagnostics

46 Hands-on Focus

Run consolidation across a sample hierarchy and analyze parent-level results.

47 Module 14: Currency Translation & FX Configuration

Track	Consolidation
Learning Outcome	Configure and validate currency translation behavior for multinational reporting.

48 Key Topics 5 topics

Local, translated and reporting-currency concepts
Currency metadata and rate types
Translation processing and rate application
Balance-sheet versus income-statement considerations
Troubleshooting translation differences

49 Hands-on Focus

Load FX rates, run translation and reconcile translated balances.

50 Module 15: Intercompany Matching & Elimination

Track	Consolidation
Learning Outcome	Explain the intercompany lifecycle from data capture through matching, reconciliation and elimination.

51 Key Topics 5 topics

Intercompany dimension and partner relationships
Intercompany data capture and matching concepts
Elimination logic and consolidation impact
Mismatch investigation and reconciliation
Governance of intercompany accounts and flows

52 Hands-on Focus

Prepare intercompany data, identify mismatches and validate eliminations.

53 Module 16: Journals & Adjustment Processes

Track	Close & Controls
Learning Outcome	Configure and operate a controlled journal process for financial adjustments.

54 Key Topics 5 topics

Journal templates, entries and workflow
Journal types and adjustment scenarios
Approval, posting and unposting concepts
Audit trail and segregation of duties
Close-period journal controls

55 Hands-on Focus

Create, approve and post a controlled journal adjustment.

56 Module 17: Forms, Data Entry & Planning Input

Track	Planning
Learning Outcome	Create structured data-entry experiences for planning, forecast and controlled financial input.

57 Key Topics 5 topics

Data-entry forms and workflow integration
POV and parameter-driven input design
Cell behavior, validation and guidance
Planning and forecast input patterns
Usability and governance considerations

58 Hands-on Focus

Design a workflow-linked data-entry form with validation and guidance.

59 Module 18: Reporting, Books & Management Reporting

Track	Reporting
Learning Outcome	Design reporting outputs that support management, statutory and operational analysis.

60 Key Topics 5 topics

Financial reporting using Cube Views and report content
Books and report-package style output concepts
Parameterized management reporting
Distribution and scheduled reporting considerations
Reconciliation between reports and cube data

61 Hands-on Focus

Create a management-reporting pack using parameterized financial outputs.

62 Module 19: Dashboards, Components & Interactive Analytics

Track	Analytics
Learning Outcome	Build an interactive dashboard experience that combines governed data and user navigation.

63 Key Topics 5 topics

Dashboard Maintenance Units and dashboard organization
Dashboard components and parameter concepts
Interactive navigation and user actions
Embedding Cube Views and analytic content
Designing role-based analytical experiences

64 Hands-on Focus

Build an interactive dashboard combining parameters and governed analytic content.

65 Module 20: Excel Add-In, Quick Views & Ad Hoc Analysis

Track	User Productivity
Learning Outcome	Use Excel-based analysis capabilities safely and effectively for finance users.

66 Key Topics 5 topics

OneStream Excel Add-In concepts
Quick Views and ad hoc data retrieval
POV, member selection and refresh
Write-back or input considerations where enabled
Excel governance and end-user productivity

67 Hands-on Focus

Create Excel Quick Views and refresh finance analysis by POV.

68 Module 21: Security, Roles & Access Governance

Track	Administration
Learning Outcome	Design and validate a role-based security model appropriate for an enterprise OneStream application.

69 Key Topics 5 topics

Users, groups and role-based access concepts
Metadata, workflow and data-access considerations
Application security design principles
Segregation of duties and least privilege
Security testing and audit readiness

70 Hands-on Focus

Design roles/groups and execute positive and negative security tests.

71 Module 22: Integration, Connectors, APIs & External Systems

Track	Integration
Learning Outcome	Design reliable integrations between OneStream and upstream or downstream enterprise systems.

72 Key Topics 5 topics

Integration architecture and supported connectivity patterns
Database, file and service-oriented integration concepts
Connector and extensibility considerations
REST/API-style automation concepts
Monitoring, error handling and secure credentials

73 Hands-on Focus

Design an integration flow with secure credentials, error handling and monitoring.

74 Module 23: Application Build, Migration & Environment Promotion

Track	Lifecycle
Learning Outcome	Plan and execute controlled movement of OneStream configuration across environments.

75 Key Topics 5 topics

Application artifacts and migration concepts
Development, test and production environment promotion
Packaging, dependency review and deployment control
Configuration differences across environments
Rollback, validation and release evidence

76 Hands-on Focus

Prepare a migration package checklist and validate deployment into a target environment.

77 Module 24: Performance Tuning, Diagnostics & Troubleshooting

Track	Operations
Learning Outcome	Use a systematic method to diagnose and improve OneStream application performance.

78 Key Topics 5 topics

Performance symptoms across data load, calculation and reporting
Query, Cube View and rule performance considerations
Job monitoring, logs and diagnostic evidence
Metadata and dimensional design impacts on performance
Structured root-cause analysis and remediation

79 Hands-on Focus

Diagnose a slow-running report or calculation using logs and structured evidence.

80 Module 25: Administration, Governance & Close Operations

Track	Operations
Learning Outcome	Operate and govern a production OneStream application through controlled finance cycles.

81 Key Topics 5 topics

Operational calendars and recurring administration
Close-process monitoring and workflow completion
Governance for metadata, rules and reports
Backup, support, audit and production controls
Change management and support handover

82 Hands-on Focus

Create a close-operations checklist covering workflow, changes, support and audit evidence.

Track	Capstone
Learning Outcome	Deliver a complete OneStream implementation case from design through validated business output and producti

83 Module 26: End-to-End OneStream Implementation Capstone

on handover.

84 Key Topics 5 topics

Solution blueprint and dimensional design
Workflow, data integration and transformation build
Calculations, consolidation and reporting
Security, migration, testing and reconciliation
Production-readiness presentation and support runbook

85 Hands-on Focus

Deliver a complete capstone from design to reconciliation, reporting and production handover.

86 Lab Portfolio 9 topics

Build a governed metadata model and workflow profile hierarchy.
Load source data, configure transformation rules and resolve mapping errors.
Create Data Management sequences for repeatable operational processing.
Build parameterized Cube Views and management reporting outputs.
Create business rules and calculation logic with reconciliation evidence.
Execute consolidation, translation, intercompany and journal scenarios.
Build a dashboard and Excel analysis experience for finance users.
Configure security roles and execute positive/negative access tests.
Prepare migration, performance and production-support checklists.

87 Assessment Framework

Assessment	Weight	Evidence
Module knowledge checks	20%	Concept and terminology quizzes
Configuration labs	30%	Working OneStream artifacts and screenshots
Scenario troubleshooting	20%	Root-cause reasoning and remediation steps
Capstone implementation	30%	End-to-end solution, reconciliation and presentation

88 Capstone: Enterprise OneStream CPM Implementation

Learners design and implement a case-study solution for a multi-entity organization. The capstone includes dimensional design, workflow, source-data load, transformations, Data Management, calculations, consolidation and translation, reporting, dashboard/Excel analysis, security, migration planning, testing, reconciliation, performance review and a production-support runbook.

89 Target Roles 8 topics

OneStream Consultant
OneStream Application Developer
OneStream Administrator
CPM / Consolidation Consultant
Financial Systems Analyst
OneStream Data Integration Consultant
OneStream Reporting & Analytics Consultant
OneStream Production Support Consultant

90 Interview Readiness Areas 7 topics

Platform architecture, cubes, metadata and extensible dimensionality
Workflow profiles, data sources, transformation rules and Data Management
Cube Views, reporting, dashboards and Excel Add-In concepts
Business Rules, Finance rules, calculations and troubleshooting
Consolidation, translation, intercompany and journal processes
Security, integration, migration, performance and production operations
Real-world design trade-offs, reconciliation and support scenarios

91 BISP Training Approach 5 topics

Concept-first explanation mapped to practical OneStream configuration
Scenario-driven labs using finance and CPM use cases
Progressive Beginner ® Intermediate ® Advanced implementation practice
Interview questions and troubleshooting exercises tied to each module
Capstone-based portfolio evidence for implementation/support roles

Ready to build OneStream implementation skills?

BISP Trainings | www.bisptrainings.com | Call Us: +91 769-4095-404

Course details

Who it is for, what you need, and how it is delivered.

Who should learn OneStream?

Prerequisites

Delivery methodology

Class delivery

Certificate of completion

Earn an industry-recognised BISP Trainings certificate when you finish the course.

Verifiable certificate with a unique ID
Shareable on LinkedIn & your resume
Recognised by our hiring partners

Frequently asked questions

Everything you need before you enroll.

Are there live classes?

Not for this course. It is self-paced: hands-on labs, MCQ practice and AI mock interviews that you take whenever suits you. If you want a trainer as well, write to us.

How do I open what I buy?

Straight after payment, in your BISP dashboard: labs open in your browser, and the MCQs and mock interviews sit on the course's own dashboard.

How long do I keep it?

Each item shows its length when you pick it: a year, or a shorter plan where one is offered. Your dashboard shows the date each one runs until.

How can I pay for the course?

Enroll securely via the payment gateway on this page using card, UPI or net-banking. EMI options are available.

More queries?

Call us at +91 769-409-5404, or write to support@bisptrainings.com.

Not sure if this course is right for you?

Book a free 1-on-1 counselling call and get a personalised learning roadmap.

Book free trial →