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.
For example we have a 2 dim cube
I want A to become 800
Calculate the amount I need to break-back everywhere else to get total of x + 800 = 100
x = 100 - 800 = -700
Copy all other initial numbers, except A (set A=0) — that’s potential trouble, you’ll have to insure no-zero data input
Break-back -700 across it
Sum it up with A amount of 800
A working Analyst library is attached so I just want to highlight some details:
inputValue and value as subtotal. That’s the only way to allow input into break-backed cell.