Can Data Hub hold formula related data? or just the spoke model is supposed to that?


  • @shlokhan

    Well, at one end of the spectrum, best practices, suggests that you should only use the data hub for transaction data, pre-aggregations, and reusable transformations. This keeps the data hub snappy and, quite frankly, it works.

    On the other end of the spectrum, is reality. Sometimes you just cannot avoid it but you should only use formulas, like variances, for example, as a complete last resort. One example might be a report that combines data from various workspaces and it's just more efficient to report it from the data hub because all the data is consolidated there.

    There's a lot of conversation about this, no right/wrong answers, but your best strategy is to follow the PLANS methodology and be conscious of the pros/cons of your decisions.

    Hope this helps.

  • Thanks a lot!