We are also bloggers
We are also bloggers
Using BI Blend in OneStream XF 5.2
Tips and Tricks
Via the OneStream XF Workflow interface, the BI Blend solution can be opened. A read-only aggregate storage model will be showed, and this model justifies the source data for uniform and standardized reporting. The BI Blend data is stored in a new relational column store table, which is outside of the OneStream XF Database.
The following topics popped up during our tests and research:
- Fast aggregation for (very) large amounts of data
- No eliminations are performed
- Single reporting currency translation
- Direct translation only
- Per BI Blend process 1 reporting currency
- Leveraging Reporting, Integration and OneStream XF Metadata tools.
- These tools don’t utilize relational properties, like percentage consolidation and aggregation weight.
- Via Derivative Transformation rules additional aggregation points can be included.
- Executed outside the cube.
- Not support for view dimension.
- Basic time math (via helper rules).
- Multi-period data can simultaneously be loaded, up to 12 periods.
- BI Blend is a CPU and Memory intensive process.
Data within BI Blend
To integrate transactional data, the Stage engine is used. The BI Blend source data will contain additional members and values that are defined in the integration as attribute members.
BI Blend will utilize the Cube dimensions to transform the records into a unified reporting format (including aggregated values), which is stored in a structured relational table for OLAP reporting. This table is available via the standard OneStream BI Dashboard and Grid reporting tools as well as relational blending into Cube views and dashboards. The output are read-only fact tables optimized for reporting with high level compression. These tables are created by the BI Blend process automatically.
The Dimensions the BI Blend Engine are defined by the cube’s integration settings. Defining the Blend Unit dimension is a key decision. Thereby unique top members are preferred across these dimensions. BI Blend supports Extensible Dimension hierarchies, tested and designed up to two levels of nested cubes. The workflow import channel shows the BI Blend settings.
A learning mode will automatically run to optimize the processing when the initial processing is running. You should enable this again if the Blend Unit has been changed.
We’ve noticed the following:
- Data access and other data cell level controls are not supported in BI Blend.
- The validation is limited to target mapping. Data intersection validation is not performed.
- A log file is created and intended to provide statistics to manage the blend task.
- Only UD8 can be used to generate Attribute Dimension members for aggregation.
Read More Articles
Sonum International has scheduled a 4-day OneStream Application Build for Administrators (ABA) Training from 23 to 26 August
Together with the ESG reporting experts of Intire, Sonum International developed a solution specifically on ESG for OneStream Software.
IFRS16 in Control, a free to use OneStream solution
Sonum International, a OneStream Diamond Partner, has announced the opening of a new office in Cape Town South Africa
During this session, we discussed how we helped the law firm; Hogan Lovells in implementing OneStream to optimize their consolidation processes.
December 2021, Manila, Philippines – Sonum International, a OneStream Diamond Partner, has made a commitment to the APAC markets through a merger with Chain.
December 2021, Taastrup, Denmark – Sonum International, a OneStream Diamond Partner, has made a commitment to the Nordics market through a merger with Chain.
Sonum International announces Expansion into the US and Canadian Markets Through Merger of Infogility’s Financial Planning and Consolidation Business Unit
Sonum International, a OneStream Diamond Partner, has made a firm commitment to the US and Canadian markets, by combining operations in the Americas with that of Infogility.
OneStream Software provides a unified, Intelligent Finance Platform that simplifies financial close and consolidation, planning, reporting, analytics and financial data quality for sophisticated organizations
Digital transformation is an opportunity for a fresh start
Wanna see our projects portfolio?
Let’s Start Something new
Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit laborum. Sed ut perspiciatis unde omnis.