Forum Discussion

DPCCGF's avatar
DPCCGF
Helper IV
1 year ago
Solved

Combining Data from Different Semantic Models

Hi there..........I am working with a training firm that has 11 clients.  Currently I have one data model with all 11 clients that refreshes nightly.  The reason they want them all in a single data m...
Need Help
  • mark_endicott's avatar
    mark_endicott
    1 year ago

    DPCCGF - I would suggest the dataflow option is your only viable solution. With one separate dataflow per client and a master dataflow that appends them all. This should ensure if one dataflow fails, your end dataflow will still succeed, it will just have out of date data for the one client until that connection is fixed. 

DPCCGF's avatar
DPCCGF
Helper IV
1 year ago

I can rephrase complexity.  I have to connect to the souce via API to about 8 different data topics.  So if it is one client I have 8 different APIs connections all for that single client and its token.  Well, my current model replicates that 11 times as I cannot get to each client in whole.  So all the data is brought in, then appended into one table.  Then the appended 8 tables are joined to allow for reporting.  I am open for suggestions.  

mark_endicott's avatar
mark_endicott
Super User
1 year ago

DPCCGF - I would suggest the dataflow option is your only viable solution. With one separate dataflow per client and a master dataflow that appends them all. This should ensure if one dataflow fails, your end dataflow will still succeed, it will just have out of date data for the one client until that connection is fixed.