Combining BIBlend data with OneStream Metadata

[SamKing]

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 UD3 dimension to the detailed sales data. However, as the BIBlend is an external database & the metadata is an application database, I can't call both of these in one data adapter.

Is there a way to combine metadata & BIBlend tables in a SQL data adapter?

Thanks,

[TonyToniTone]

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

[Sai_Maganti]

Another option is to fetch the two datasets in a BR and then use a LINQ query to join your columns to make a new dataset and then call the BR from your SQL adapter.

[scottr]

Not the greatest, but we just replicated a subset of the the member table to BIBlend database.