Contributor transactional logic example
April 29th, 2008Finally, we've solved problem stated in communities. And Robert allowed me to publish resulting library here as well. See attached zip file.
Problem statement
We have 2 cubes, one containing product groups sales (for example) and the other containing detailed product data. Users should be able to correct overall group totals and correct detailed product distribution.
If group A contains Product 1 and Product 2 and if Total(A) is 100, it's initially split 50\50.
User should be able to modify Product 1 to 75, yielding result of 75\25.
Normal break back won't work this way, because it'll see 75\50 as profile for break back and will produce 60\40 as a result.
So you'd need to create an own break back. That's easy )
Verbal Description of the algorithm
It's a copy-paste from communities topic, don't bother re-reading.
1 For example we have a 2 dim cube
Total 100
A 70
B 30
I want A to become 800
2 Calculate the amount I need to break-back everywhere else to get total of x + 800 = 100
x = 100 - 800 = -700
3 Copy all other initial numbers, except A (set A=0) -- that's potential trouble, you'll have to insure no-zero data input
Total 70
A 0
B 70
4 Break-back -700 across it
Total -700
A 0
B -700
5 Sum it up with A amount of 800
Total 100
A 800
B -700
Implementation
A working Analyst library is attached so I just want to stress some details
1 inputValue and value as subtotal. That's the only way to allow input into break-backed cell.
2 transactional logic is implemented in very same way I described it.
3 no manual items allocation in dlinks on dimensions other that transactionalLogic_1, only match descriptions and self-updating allocation table. This allows easy updates.
4 3 elements are redundant in attached library (see comments). They are left for clarity of implementation.
5 dlists are named according to my own convention, I'll write about it a bit later
Thanks Robert, it was an interesting task.
