I'm trying to write rule for next situation. I have 2 cubes. Cube A for simplicity with 2 dimension:
1. months (Jan, Feb,..., Dec)
2. measures1 (element1 (sum), element2 (Jan, Feb, ... Dec));
For example
Jan Feb Mar Apr May Jun
element1 10 20 10 30 40 30
element2 Jan Jan Jan Apr Apr Apr
Cube B also contains 2 dimension
1. months (Jan, Feb,... Dec)
2. measures2 (element3 (sum))
I want to receive next order of date in Cube B
Jan Feb Mar Apr May Jun
element1 40 0 0 100 0 0
So you can understand element 2 in Cube A shows month in Cube B where I want to allocate sum from element 1. Unfortunately I can't imagine how I can write necessary rule. Can anybody help?