FOX Formula to read data from two infocubes and make * in result

[Former Member]

Dear all,

The request is to make a planning function through fox formula in order to calculate two different s BPC Accounts.I have two different s info cubes matched in one composite provider.Also i created a query which is like this

So the main purpose is to take YTD Sailings * YTD Total Fuel Consumption * YTD Average Fuel Price = YTD Fuel Cost.Also in YTD i have periods with values.So after that i created two fox codes .One to calculate Total Fuel Consumption and the second one to caclulate Fuel Cost

1.

2.

So the fox code has no errors but the changed data is 0.

Could you please advise?

[former_member186338]

Sorry, but please answer in a readable form!

Use "Insert Image" instead of incorrect "Insert File"!

[Former Member]

Hi George, sorry for the format, look like was a problem with my browser,

To read the information from another cube I usually do this:

1-) Activate the infoprovider in the fox formula:

This must give you the signature to read information like this:

Please check the last 2 items.

After that I declare and set the name of the infoprovider that I'm going to read:

And finally I use the code like this:

Please be aware that you must use the appropiated signature for each cube,

Regards,

And thanks Vadim

Mario Mendoza

[gregor_dieckmann]

Hi George,

why are you using FOX and not just formulas in the query?

Regards,

Gregor