Skip to main content
S
SamKing
Member
August 23, 2022

Combining BIBlend data with OneStream Metadata

  • August 23, 2022
  • 3 replies
  • 0 views

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,

 

3 replies

T
TonyToniTone
August 23, 2022

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

TonyToniTone_0-1661259843484.png

 

    S
    Sai_Maganti
    Newcomer
    August 25, 2022

    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.

    S
    scottr
    Newcomer
    August 25, 2022

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

    Terms & ConditionsAccessibility statement