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 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,

 

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

     

  • Sai_Maganti's avatar
    Sai_Maganti
    Contributor II
    3 years ago

    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's avatar
    scottr
    New Contributor III
    3 years ago

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