Missing Customer from Customer Hierarchy in the Spoke Model but not in Data Hub

I have a customer that is located in our spoke model, but it is not show in our data hub where the customer hierarchy lives. There is a daily process to push the CH into the spoke model. The client also stated this customer has been around for years and should be present in the hierarchy, but the source file does not have the customer in it. What would be the causation of the customer showing in the spoke but not the Data hub?

Accepted answers

All comments

rob_marshall

@michaelpfender

If it is not in the data hub but is in the spoke model, I would check a couple of things:

does the client wipe and reload the customer list in the data hub in the daily load? If so, it is very likely this customer was in there at one point but now is no longer. And due to this, is still in the spoke model because they are not cleaning up the hierarchy. Now that doesn't mean they should be wiping and reloading the customer hierarchy in the spoke model, but cleaning it up by deleting old customers…I know this is not part of the question, but it sounds like the customer could take advantage of some masterdata management.
If the customer should be there (in the data hub) and is not, they need to look at how the source data is being created. Are there filters (on the source side) that is excluding the customer?

Rob

Misbah

@michaelpfender There could be lot of reasons.

Data Hub also had this Customer and it was deleted from it but not was not deleted from Spoke

Data Hub Default View has this Customer available but the Saved View excludes this customer

Customer Hierarchy was directly loaded into Spoke initially.

Whatever the reason it is for sure that if the Customer is present in the Spoke and the hierarchy load has always come from DH then it must have gotten deleted in the DH .

Thanks,

Misbah

Miz Logix

Quick Links

Can you help?

Unanswered questions

A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385