I need to store and navigate the changes i have in my Customer hierarchy.
In our business, each Customer is assigned a Salesperson, and this is replicated into our BOARD data model where the entity "Salesrep" is directly linked to the entity Customer.
Over time, this relationship changes and we need to keep track of this change, instead of seeing the latest situation: all Customers' sales units and amounts will be linked to the most recent assignment.
How would you address this situation?
Hi Andrea Masiero,
the easiest way to achieve such kind of reporting and save the changes you have in the hierarchy, is to create another entity "Sales Rep" as part of your BOARD data model.
This entity should then be added to all of the information (infocubes) which might benefit from this "additional" navigation (i am assuming the infocubes are also structured by a time entity).
In this way, navigating the infocubes by "Sales Rep" (standalone entity) you would trace the different amounts or units sold by each sales rep to each customer.
Navigating, selecting or drilling by "Sales Rep" (the entity linked to the Customer) you would always have the latest situation, as per the hierarchy.
Michele Roscelli has implemented many BOARD solutions and might add to this
Hope this helps