2 Replies Latest reply: Aug 7, 2013 5:22 PM by Paul Scotchford RSS

    Concatenate Month grained fact to Day grained fact

    Paul Scotchford

      Hi All

       

      I am looking for an effective way to apply Month grained fact Data to Day grained data ?

       

      Scenario is ...

       

      Month based Sales Budgets to concatenate into a

      Day based Sales fact

       

      One obvious answer is to make Daily budget facts and concatenate to the Sales Fact, but this

      will misrepresent the shape of the chart as budgets are determined for a Stock Sub Category and

      Store.

       

      Currently I concatenate at a Month level and this is fine in a chart where rolling at Month to Year ,

      but when drilling to the Week, Day then of course the budget value will be 0.

       

      Has anyone done something like this ?

       

      Many thanks

       

      Paul