fox formular - referencing data objects

[Former Member]

Hi all,

as i understood the data that is restricted in my planning level/package is devided into so called data objects and for each of these data objects my fox formular is calculated. In my case i have 2 data objects and i need the data from one object to make a calculation inside the other. One way to achieve this is merging the two data objects into one, but this leads to a quite many "fields to be changed" in my planning function. Is there another way to make a reference between data objects?

Thanks,

Holger

[Former Member]

Hi,

You need to give some details about your scenario. There cannot be a general solution to your query.

[Former Member]

to give you a simple example.....

the structure of my 2 data objects is:

planpos./version/amount/quantity

data object 1:

700, 001, 20, 0

700, 002, 40, 0

700, 003, 60, 0

...

data obejct 2:

100, 001, 0, 2

100, 002, 0, 4

100, 003, 0, 6

...

the two data objects differ in their planningarea:

data object 1:

planningarea: YASPLAN

data object 2:

planningarea: YASESPLA

Now i wish to multiply the data in data object 1 with the corresponding data in data object 2. E.g.

{ 0AMOUNT, 100, 001 } = { 0AMOUNT, 100, 001 } * { 0QUANTITY, 700, 001 }.

If i try this i always get 0. I guess this is because the data is hold in two different data objects and i cannot access the quantity data for data object 2 in data object 1. I could put the planning area in "fields to be changed" so there would be only on data object. This works fine, but i have more info objects than shown in this example so my list of "fields to be changed" would become quite big.

[Former Member]

For sure this is not possible without marking 'planning area' in fields to be changed. Other than specifying the cubes for the source records in the calculation, this field will also be needed for you to specify in which cube (or planning area) the result record will go.