Hi experts,
I have an Real-time InfoCube like this:
CustomerGP - Calyear - Calquarter - Version - Currency - Net-value
01 - 2019 - 20191 - A - USD - 100
01 - 2019 - 20192 - A - USD - 130
01 - 2019 - 20193 - A - USD - 170
01 - 2019 - 20194 - A - USD - 100
02 - 2019 - 20191 - A - USD - 150
02 - 2019 - 20192 - A - USD - 130
02 - 2019 - 20193 - A - USD - 120
02 - 2019 - 20194 - A - USD - 200
03 - 2019 - 20191 - A - USD - 250
03 - 2019 - 20192 - A - USD - 200
03 - 2019 - 20193 - A - USD - 350
03 - 2019 - 20194 - A - USD - 300
These are my actual data and I want to plan base on them. I've put my actual and plan data into one Real-time Infocube. After the actual data transferred to the InfoCube, I've changed the load behavior of the InfoCube to the planning mode for executing the planning functions.
I want to plan these data for Calyear 2020, so first of all I run a copy function (change the Calyear to 2020 and Version to B) so my plan data become like this:
CustomerGP - Calyear - Calquarter - Version - Currency - Net-value
# - 2020 - 00000 - B - USD - 2100
Then, I revaluate the net-value by 20 percent:
CustomerGP - Calyear - Calquarter - Version - Currency - Net-value
# - 2020 - 00000 - B - USD - 2520
Now, I want to distribute the net-value to the CalQuarter. In this regard, my filter, and planning function selections set as follow screenshots:
Fig.1- Screenshot from my filter for the Planning Function:
Fig.2- Screenshot from my Planning Function (Distribution by Reference):
Unfortunately, when I run this planning function, I've encounter with this message:
"Cannot find reference data for sub-process 1 of the function".
I must mention that I'm using the SAP BW 7.4.
Any help would be appreciated.
Thanks in advance,
Amir