Dynamic Cube Services (Limited Availability)

Dynamic Cube Services are a concept primarily associated with business intelligence (BI) and data analytics. They assist you with managing and analyzing large volumes of financial data, leading to more accurate analysis, reporting, and decision-making. Dynamic Cube Services provides features for designers with advanced knowledge of the OneStream architecture and of Workspace assembly files to:

  • Consolidate financial data from various sources

  • Create and compare different budgeting and forecasting scenarios

  • Track key performance indicators in real-time, enabling better management and decision-making

  • Analyze risk data across multiple dimensions, helping mitigate financial risks

  • Help ensure that financial data is accurate and up-to-date for internal compliance and auditing

This section will guide you on the application of dynamic cubes and dynamic dimensions used in OneStream solutions.

Dynamic Cubes Overview

Dynamic cubes structure external data into a multidimensional cube for simplified reporting and analysis using tools such as cube views, quick views and workspace dashboards. Dynamic cubes offer a solution for application designers to surface non-traditional data, such as transactional data, into cubes without loading data.

Dynamic cubes enable real-time connectivity to an external source, such as a database, without needing to store the data in a cube. They are based on workspace assembly files that define the dimension metadata and hierarchies, and instruct the cube on how to retrieve and commit data records.

Data is integrated using data bindings configured on the cube, rather than workflow-based imports. Sources that can supply content to a dynamic cube are other cubes, tables, and other external databases. Data is copied from a source and stored in data record tables, or it may be shared. A shared operation functions as a reference to the source system, which means the data is not physically stored in OneStream.

Dynamic cubes allow data collection through the Forms origin member. The data submission flow can be customized using workspace assembly files to target tables, or to target the data submission to an external table.

The elimination of stored metadata is accomplished using dynamic dimensions. Dimensions are created and referenced by the dynamic cube in the same manner as a standard cube. However, members, properties, and relationships, are defined using workspace assembly rules, which manage the retrieval of data records as well as the cadence and method to refresh data and dimension metadata.

Dynamic Dimensions Overview

Dynamic dimensions are dimensions in which dimension members are not stored in an internal member table. Instead, the dynamic dimension is used to surface members from external sources for use in cubes. Dynamic dimensions are a key design tool that enable external database integration with dynamic cubes. Dynamic dimensions cannot be created, updated, or deleted through the standard user interface.

Workspace assembly rules define and retrieve members from external sources. They are used to apply properties, and to define relationships used to create a dimensions. Metadata management of the dynamic dimension is performed by the definition within workspace assembly rules.

Dynamic dimension members are read in real-time and cached from the external source system each time the workspace assembly executes. Dynamic dimension members only exist in their sources and are not saved to tables. They are stored in an internal table, called DynamicMember, to facilitate audit and application management.