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:
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