Problem with standard distribution function

33 Views

Hi,

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,

Marcin

ps. I work with IP, but assume that BPS is very similar regarding stadard planning functions, so any suggestion is welcome.