Skip to Content
0
Oct 02, 2019 at 08:00 AM

Cannot distribute data to the 0CALQUARTER by using the Distribution by Reference planning function

116 Views Last edit Oct 03, 2019 at 03:40 AM 3 rev

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

Attachments

filter.jpg (115.0 kB)
pf1.jpg (62.8 kB)
pf2.jpg (279.3 kB)