08-23-2022 04:25 AM - last edited on 05-24-2023 04:53 AM by JackLacava
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,
08-23-2022 09:05 AM
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
08-25-2022 08:11 AM
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.
08-25-2022 12:07 PM
Not the greatest, but we just replicated a subset of the the member table to BIBlend database.