Skip to Content
0
Former Member
Apr 14, 2014 at 02:23 PM

Copy data from cube A to cube B via fox formula

848 Views

Hi!

I need to write a fox formula copying data from cube A (actuals) to cube B (plan, realtime).

Speciality why standard copy function is not working in this case:

I may have combinations of characteristics in my cube B, which do not exist in cube A, and I want to keep them after copy. The standard copy function is multiplying each line in cube B with -1 before it copies the lines of cube A to cube B. Lines which do not exist in cube A will be lost.

So my copy function should work as follows:

  1. For each line in cube B, check if it also exists in cube A
    1. If it exists in cube A, multiply it by -1
    2. If it does not exist in cube A, do nothing
  2. Copy data from cube A to cube B

As a result, cube B should look like cube A for all records that exist in cube A PLUS all records in cube B which do not exist in cube A.

Any idea how this can be done using a fox formula?

Thanks in advance

Marco