BI Blend is a read-only aggregate storage model designed to support reporting on large volumes of data that are not appropriate to store in a traditional OneStream cube. BI Blend data is large in volume and often transactional in nature. For example, to analyze data by invoice, a standard cube would require metadata to store the data records. In a short period of time, most of the invoice metadata would be unneeded because of the transactional nature of the data. Therefore, storage in a cube design is not a best practice solution for transactional data.
A key challenges of reporting on Transactional data, is presenting it in a uniform format that supports standardized reporting yet is flexible enough to support ever changing records and reporting requirements. The overall large size of the data sets requires a model suitable for responsive reporting and analysis. BI Blend approaches these challenges in an innovative way by rationalizing the source data for uniform and standardized reporting, much like the Standard OneStream Cube Models, but storing the data in a new relational column store table for responsive reporting.
The BI Blend solution is intended to support analytics on large volumes of highly changing data, such as ERP system transaction data, which typically would not reside in a OneStream cube. The processing is unencumbered from the intensive audit controls within a traditional Consolidation Cube, such as managing calculation status.
Key Elements of BI Blend
-
Flexible for change
-
Fast Aggregation through data as Stored Relational Aggregation
-
Single Reporting Currency translation
-
LeveragedOneStreamMetadata, Reporting and Integration tools
-
Non-cube, executed to a relational table optimized for reporting on large data sets by storing results in a column store index
