The task is following:
There are three cubes - one with data to be distributed (non-transactional), one with reference data (non-transactional) and one where the distributed data should be written (transactional).
I am trying to use standard IP planning function Distribute with Reference Data to achieve the result. However when I put 0INFOPROV as a characteristic to be changed, I can select value for it only in block FROM and TO, and not in REFERENCE DATA SELECTION.
So to tell the system, taht reference data are located in third cube I have added new car which for the is always filled with constant in the reference cube (for every record).
But it seems that it does not help: When trying to execute, following error message appears: Cannot find reference data for sub-process 1 of the function
Anywone has ever customied standard function in a way that it is able to use data from three cubes? What do I do wrong?
Thanks in advance,
ps. I work with IP, but assume that BPS is very similar regarding stadard planning functions, so any suggestion is welcome.