300 QUESTIONS AND ANSWERS
1. What is the primary purpose of OneStream XF Platform? Answer:
OneStream XF is a unified Corporate Performance Management (CPM)
platform that provides financial consolidation, planning, reporting, analytics,
and data quality management in a single solution.
2. What are the core components of OneStream architecture? Answer:
Application Server, Database Server, Web Server, OneStream Service, and
Client applications (including Excel Add-in and web interface).
3. What database systems does OneStream support? Answer: Microsoft
SQL Server and Oracle Database are the primary supported database systems.
4. What is a OneStream Application? Answer: A OneStream Application is a
complete business solution containing dimensions, rules, forms, dashboards,
and other objects configured for specific business requirements.
5. What is the difference between OneStream Platform and OneStream
Applications? Answer: The Platform is the underlying technology
infrastructure, while Applications are business-specific solutions built on top of
the Platform.
6. What are OneStream Dimensions? Answer: Dimensions are the structural
building blocks that define how data is organized and stored, including Entity,
Account, Flow, Origin, Scenario, Time, and User-Defined dimensions.
7. What is the Entity dimension used for? Answer: The Entity dimension
represents organizational units such as companies, divisions, departments, or
legal entities in the consolidation hierarchy.
,8. What is the Account dimension in OneStream? Answer: The Account
dimension contains the chart of accounts including assets, liabilities, equity,
revenue, and expense accounts used for financial reporting.
9. What is the Flow dimension? Answer: The Flow dimension tracks different
types of data flows such as None, Eliminations, Top Adjustments, and other
consolidation adjustments.
10. What is the Origin dimension used for? Answer: The Origin dimension
identifies the source of data, distinguishing between Import, Input, Calculated,
and other data origins.
11. What are User-Defined dimensions (UD1-UD8)? Answer: User-Defined
dimensions are customizable dimensions that can represent any business
attribute such as product lines, regions, cost centers, or projects.
12. What is a OneStream Cube? Answer: A Cube is a multidimensional data
structure that stores financial and operational data organized by the defined
dimensions.
13. What is the difference between a Scenario and a Time dimension?
Answer: Scenario represents different versions of data (Actual, Budget,
Forecast), while Time represents periods (years, quarters, months).
14. What are OneStream Workflow Profiles? Answer: Workflow Profiles
define the process flow, security, and business rules for data collection, review,
and approval processes.
15. What is a Member in OneStream? Answer: A Member is an individual
item within a dimension, such as a specific account, entity, or time period.
16. What are Member Filters? Answer: Member Filters are dynamic
selections of dimension members used in forms, reports, and business rules for
data retrieval and processing.
17. What is a OneStream Data Source? Answer: A Data Source defines the
connection and mapping information for importing data from external systems
into OneStream.
18. What are Transformation Rules? Answer: Transformation Rules are
business logic components that manipulate data during import, calculation, or
consolidation processes.
19. What is the OneStream Calculation Engine? Answer: The Calculation
Engine processes business rules, performs calculations, and executes
consolidation logic within the OneStream platform.
, 20. What are Business Rules in OneStream? Answer: Business Rules are
VB.NET code components that implement custom business logic for
calculations, data validation, and process automation.
21. What is a OneStream Dashboard? Answer: A Dashboard is an interactive
reporting interface that displays key performance indicators, charts, and
analytical content.
22. What are OneStream Forms? Answer: Forms are data entry interfaces that
allow users to input, review, and submit financial and operational data.
23. What is the OneStream Security Model? Answer: The Security Model
controls user access through User Groups, Security Groups, and dimension-
based security settings.
24. What are OneStream Extender Business Rules? Answer: Extender
Business Rules are specialized components that extend platform functionality
for specific business processes.
25. What is a OneStream Application Database? Answer: The Application
Database stores all application metadata, business rules, security settings, and
transactional data.
26. What are OneStream System Dimensions? Answer: System Dimensions
are predefined dimensions (Entity, Account, Flow, Origin, Scenario, Time) that
are fundamental to the platform architecture.
27. What is OneStream Metadata? Answer: Metadata is the structural
information that defines application objects, including dimension hierarchies,
business rules, and form definitions.
28. What are OneStream Data Units? Answer: Data Units are precision
settings that define how numerical data is stored and displayed (Units,
Thousands, Millions).
29. What is a OneStream Consolidation? Answer: Consolidation is the
process of combining financial data from multiple entities while applying
elimination rules and adjustments.
30. What are OneStream Eliminations? Answer: Eliminations remove
intercompany transactions and balances to present consolidated financial
statements.
31. What is the OneStream Workflow Engine? Answer: The Workflow
Engine manages business processes, data collection cycles, and approval
workflows within applications.
1. What is the primary purpose of OneStream XF Platform? Answer:
OneStream XF is a unified Corporate Performance Management (CPM)
platform that provides financial consolidation, planning, reporting, analytics,
and data quality management in a single solution.
2. What are the core components of OneStream architecture? Answer:
Application Server, Database Server, Web Server, OneStream Service, and
Client applications (including Excel Add-in and web interface).
3. What database systems does OneStream support? Answer: Microsoft
SQL Server and Oracle Database are the primary supported database systems.
4. What is a OneStream Application? Answer: A OneStream Application is a
complete business solution containing dimensions, rules, forms, dashboards,
and other objects configured for specific business requirements.
5. What is the difference between OneStream Platform and OneStream
Applications? Answer: The Platform is the underlying technology
infrastructure, while Applications are business-specific solutions built on top of
the Platform.
6. What are OneStream Dimensions? Answer: Dimensions are the structural
building blocks that define how data is organized and stored, including Entity,
Account, Flow, Origin, Scenario, Time, and User-Defined dimensions.
7. What is the Entity dimension used for? Answer: The Entity dimension
represents organizational units such as companies, divisions, departments, or
legal entities in the consolidation hierarchy.
,8. What is the Account dimension in OneStream? Answer: The Account
dimension contains the chart of accounts including assets, liabilities, equity,
revenue, and expense accounts used for financial reporting.
9. What is the Flow dimension? Answer: The Flow dimension tracks different
types of data flows such as None, Eliminations, Top Adjustments, and other
consolidation adjustments.
10. What is the Origin dimension used for? Answer: The Origin dimension
identifies the source of data, distinguishing between Import, Input, Calculated,
and other data origins.
11. What are User-Defined dimensions (UD1-UD8)? Answer: User-Defined
dimensions are customizable dimensions that can represent any business
attribute such as product lines, regions, cost centers, or projects.
12. What is a OneStream Cube? Answer: A Cube is a multidimensional data
structure that stores financial and operational data organized by the defined
dimensions.
13. What is the difference between a Scenario and a Time dimension?
Answer: Scenario represents different versions of data (Actual, Budget,
Forecast), while Time represents periods (years, quarters, months).
14. What are OneStream Workflow Profiles? Answer: Workflow Profiles
define the process flow, security, and business rules for data collection, review,
and approval processes.
15. What is a Member in OneStream? Answer: A Member is an individual
item within a dimension, such as a specific account, entity, or time period.
16. What are Member Filters? Answer: Member Filters are dynamic
selections of dimension members used in forms, reports, and business rules for
data retrieval and processing.
17. What is a OneStream Data Source? Answer: A Data Source defines the
connection and mapping information for importing data from external systems
into OneStream.
18. What are Transformation Rules? Answer: Transformation Rules are
business logic components that manipulate data during import, calculation, or
consolidation processes.
19. What is the OneStream Calculation Engine? Answer: The Calculation
Engine processes business rules, performs calculations, and executes
consolidation logic within the OneStream platform.
, 20. What are Business Rules in OneStream? Answer: Business Rules are
VB.NET code components that implement custom business logic for
calculations, data validation, and process automation.
21. What is a OneStream Dashboard? Answer: A Dashboard is an interactive
reporting interface that displays key performance indicators, charts, and
analytical content.
22. What are OneStream Forms? Answer: Forms are data entry interfaces that
allow users to input, review, and submit financial and operational data.
23. What is the OneStream Security Model? Answer: The Security Model
controls user access through User Groups, Security Groups, and dimension-
based security settings.
24. What are OneStream Extender Business Rules? Answer: Extender
Business Rules are specialized components that extend platform functionality
for specific business processes.
25. What is a OneStream Application Database? Answer: The Application
Database stores all application metadata, business rules, security settings, and
transactional data.
26. What are OneStream System Dimensions? Answer: System Dimensions
are predefined dimensions (Entity, Account, Flow, Origin, Scenario, Time) that
are fundamental to the platform architecture.
27. What is OneStream Metadata? Answer: Metadata is the structural
information that defines application objects, including dimension hierarchies,
business rules, and form definitions.
28. What are OneStream Data Units? Answer: Data Units are precision
settings that define how numerical data is stored and displayed (Units,
Thousands, Millions).
29. What is a OneStream Consolidation? Answer: Consolidation is the
process of combining financial data from multiple entities while applying
elimination rules and adjustments.
30. What are OneStream Eliminations? Answer: Eliminations remove
intercompany transactions and balances to present consolidated financial
statements.
31. What is the OneStream Workflow Engine? Answer: The Workflow
Engine manages business processes, data collection cycles, and approval
workflows within applications.
