Skip to Content

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

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?

query.png (120.8 kB)
query.png (120.8 kB)
fox1.png (67.9 kB)
fox2.png (67.4 kB)
fox2.png (67.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 17 at 02:55 PM

    Hi George,

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

    Regards,

    Gregor

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 18 at 11:47 PM

    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


    1.png (33.4 kB)
    3.png (3.7 kB)
    2.png (2.4 kB)
    4.png (3.1 kB)
    Add comment
    10|10000 characters needed characters exceeded