BI Blend Features

BI Blend is a blend of Multidimensional and Transactional Data.  This is done by utilizing the OneStream platform application to generate a database structure for OLAP reporting.  By utilizing the existing OneStream Workflow processes, users need to be familiar with the interface and tools required to develop BI Blend reporting solutions.

BI Blend provides focused reporting tables that are aggregated and saved as stored parent intersections for fast reporting at a later point in time. BI Blend does note replicate an entire cube, but rather focuses on specific reporting use cases that result in many parent intersections that would not perform well under Calc-On-Fly aggregation.

BI Blend also solves for use cases that are not pure analytic reporting problems. By leveraging OneStream hierarchies along with BI Blend configuration settings, it is possible to aggregate on a few dimensions (entity or account for example) while including transaction information (Invoice number) that is not associated with a cube. The ability to combine the dimensional structure with transaction details allows for selective enrichment of transactional data.

BI Blend is designed to support analytic models where some level of aggregation may be required, but contains constantly changing information that should not be loaded to a cube. This includes the following items:

• Read only access data

• Very large data sets that are transactional in nature

• Fast aggregation as stored relational aggregation

• Flexible and changing records

• Data related to cube data

• Data populated and rebuilt on demand

• Ancillary and supplemental data