Forum Discussion

SamKing's avatar
SamKing
New Contributor II
3 years ago

Combining BIBlend data with OneStream Metadata

Hi,   We're trying to combine our detailed sales data housed in BIBlend with the member table in the application database. The reason for this is so we can join the client name assigned to our UD...
Dashboards
TonyToniTone's avatar
TonyToniTone
Contributor II
3 years ago

A BI Blend Star Schema table can be created to leverage data and metadata for a SQL data adapter.  This can be configured through the Workflow under Profile Properties > BI-Blend Settings > BI-Blend Parameters.  Under Data Controls > Create Star Schema, this setting can be turned to True and when the Star Schema table is created, it will contain metadata with its hierarchy.  More information on this can be found in the BI-Blend Design and Reference Guide