IP: Distribution : cannot find reference data for sub-process 1

[Former Member]

This is the data from Cube A:-

Customer  Company  Version  Value Type ProductCode Year HalfYearly Calmonth currency Amount

1111110    255556	 0          51	2029363     2008   20081     000000  USD    600.00USD

1111110    255556	 0          51	2029363     2008   20082     000000  USD    800.00USD

This is the data from Cube B:- (for Reference Data)

Customer Company Version ValueType ProductCode Yearly YearHalf Calmonth Rate

1111110  255556    0       #         2029363     2008   #        200801   10
1111110  255556    0       #         2029363     2008   #        200801   10
1111110  255556    0       #         2029363     2008   #        200802   05
1111110  255556    0       #         2029363     2008   #        200803   20
1111110  255556    0       #         2029363     2008   #        200804   10
..................... more.. 

I want to distribute my Cube A data based on Cube B's rate. From Cube A - Value CalMonth = # to Cube A CalMonth = 200801, 200802, 200803.....

(To characteristic usage: infoprovider & calmonth are check as changed.Inprovider is required as it is from multiprovider.)

In the reference data selection: I have selected Rate.

When I executed, it is given me message" Cannot find reference data for sub-process 1of the function."

Anyone encounter this type of problem before? or I should distribute through FOX?

Thanks for sharing..

/Jamie

[Former Member]

Hi Jamie,

if you compare cube A and B you have 4 differences:

infoprovider

calcmonth

value type

halfyearly

-> you want to distribute calmonth, so only switch this one as to be changed

The key in for the other three characteristics the reference values in "Reference Values to Any Block Characteristics":

infoprovider: cube B

value type = #

halfyearly = #

The only thing which could give some troubles is the logic of your currency: what does rate stands for in cube B? can you default this also to one constant value (or to be inputted by the user)?

D

regards

D

[Former Member]

Hi D.....

In my Cube A, I dont have calmonth yet. I only have 2 records based on half yearly records.

In my cube B, I have 12 records based on calmonths....

If I want to distribute Cube A based on Cube B rate, it is provided (initially) i have calmonth records in Cube A first rite? What should I do in my case if I dont have it..I need to copy first then only distribute?

I would like to know about your suggestion?

Thanks.

/Jamie

[Former Member]

In the testing, I didnt put Vtype in the filter.

Anyhow, I try to put vtype = 51 in both cube now.., the result is same..

cannot find reference data for sub-process 1..

Do you have specify sample setting to share with me, D?

Appreciate. Thanks.

/Jamie

[Former Member]

Hi Jamie,

the data of your reference data is the same as for your planning,except for the one you switched the change flag on. Since value type in your example has a different value in your reference data AND it is not in your characteristics to be changed, the system cannot find any reference data (since it will use value 51 instead of #).

-> add this constant value in

"Reference Values to Any Block Characteristics" (just below the key figure(s) you marked for your function).

regards

D

[Former Member]

your value type is also different 51 in A and # in reference data.

add this to your standard formula. FOX is not needed for this

D