New BI Blend Stage Cache Engine
This is a new “in memory” process unique to the BI Blend feature. This new Engine is used to rationalize the transactional data by leveraging the OneStream Metadata Engine. During processing the BI Blend Cache will utilize the Cube dimensions to transform the records into a unified reporting format. The Cube Hierarchies are used to derive aggregation points to be stored for reporting. The BI Blend Stage Cache will also accept properties on Entities and Accounts to perform direct method translation to the application reporting currency. The Engine ultimately generates a finalized table with a Column Store Index, creating a structure for OLAP reporting. The table can be accessed with the standard OneStream BI Dashboard and Pivot Grid reporting tools for analytic reporting as well as Relational Blending into Cube Views and Dashboards.