hi,
I have the following problem:
My fox formula tries to save from the basic cube to transactional cube. In basic cube is this data.
Material: A
Project: B
Validto: 00.0000
Amount: 100
And
Material: A
Project: B
Validto: 10.2006
Amount: 200
The result that I want in my transactional cube is the sum of two records in a valid to 00.0000.
Material: A
Project: B
Validto: 00.0000
Amount: 300.
The entry parameter are: project : B, validto: 00.0000 and 10.2006 ( always will be tow values, 00.0000 and other)
I write the following code.
FOREACH MATERIAL, PROYECT, VALIDTO.
{0AMOUNT, MATERIAL, PROYECT,#, ZTRASACTIONAL} =
{0AMOUNT, MATERIAL, PROYECT, VALIDTO, ZBASIC}.
ENDFOR.
But the result is the amount on VALIDTO: 10.2006. (The record is overlapped and is not getting summed)
In the example the saved amount is 200 not 300 as I want.
How can I obtain the amount that I want?
I would you appreciate your help.
Thanks,
Victoria