I have a requirement from a client where they want a solution that encapsulates the following scenario:
1. Set the "Yearly" Targets for a REPs (Re-Sellers of their product)
2. Store this Target (was thinking of storing into a QVD)
3. From their DB i will get the Current (which wil vs Target)
4. This target will obviously become smaller in size as the "Current" grows in size.
My question is:
What solution types can i look at to try and build this sort of solution?
What iv'e been trying:
1. I've tried creating a Variable, for each Rep (about 6), which should hold the "Target"
2. Created a INLINE loaded table, immediately assigning the Variable, to the Rep's Code.
The issue here is that cannot give the created Variable a value, and have it remain at the "given" value... as it loses the value, back to "0" after the reload?
