3.1 - Incomplete Data given in Data Hub?

Options
smcdonald
smcdonald Member, ALL USERS, Partner, Certified Model Builder Posts: 2 New Contributor
in Anaplan Community

Hello,

 

I am working on the sales forecasting/actual user stories and have run into an issue. It seems as if the modules "Data_ActualUnits" and "Data_Actual Unit Data" are missing valid rep-customer-product sales (specifically the customer-product combinations). For example, in the budgeting file under the "Input Units" tab there is a sale from Jan-17 of 100 units with the "The Good Dog House-6 lb Puppy Food" customer-product combination but this is not in either of the modules mentioned above for any sales rep.

 

I have built a new hierarchy (L1 Sales Centers, L2 Sales Reps #, L3 Customers #, L4 Products #) using the "Data_ActualUnits". However, without the all customer-prod mapping provided in the data hub, Im not sure how how to get the complete mapping for the L4 Products # list.

 

Am I missing something, or are we supposed to go ahead with the given mapping?

 

Thanks

Tagged:

Comments

  • PavanKumar
    PavanKumar Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Regular Contributor

    Hi @smcdonald

    You already created the hierarchy, where 'L3 Customer' is the parent of 'L4 Product' thereby you have established the mappings required.

    When it comes to data, please do not concentrate on the arithmetic accuracy of the lines just go ahead and build as per the user story. 

     

    Regards,

    Pavan

  • smcdonald
    smcdonald Member, ALL USERS, Partner, Certified Model Builder Posts: 2 New Contributor

    But if the module Data_ActualUnits does not actually contain all valid intersections for rep-customer-product, how can I get a revenue number that actually makes sense? Seems to me that there would be no way of actually attributing much of the forecast sales from the budget file provided to the hierarchy I created.

     

    Currently the revenue in my model is so low that the company is not profitable. This comes from the data_actualunits showing only 18,500 units sold per month where as the budget file shows 65,000/month. Are you saying that its ok if the numbers are this far off?

  • JDLovering
    JDLovering Member, ALL USERS, Partner Posts: 5 Occasional Contributor

    I also found the numbers to be incomplete to give a representative forecast for revenue, in the end I added data "Units" myself to make it a reasonable data set.

     

    I think you raise a good point that the base Actuals data ideally should be complete which would then be an easy test to see you completed the full relationships in your forecast model.

     

    I took extra time to make all data points look representative and balanced such that my dashboards all made sense. It's also easy to test when you have proper data.

    It's possibly not strictly needed but again I would find it difficult to produce a model without having proper data in currencies and products across the organisation. It also makes it easier to follow in your review if your data is more complete as you can present the model much easier, the scenarios show the results better and it just looks better in your charts.

     

     

Categories