Forum Discussion

swatantra's avatar
swatantra
New Contributor II
2 years ago

Data copied using Eval function gets removed after consolidation

When i tried copying the data from one cube to another cube using Eval function with Buffer [Calculate(formula, onEvalDataBuffer, userState)], the data got copied at the base level but as soon as i c...
Finance
  • FredLucas's avatar
    FredLucas
    2 years ago

    Hi,

    One option would be to use this version of the api.Data.Calculate instead:

    You can skip the different optional dimension filters if not required by just adding commas until you get to the arguments you are interested in (e.g.: onEvalDataBuffer, and isDurableCalculatedData) - example below. 

    api.Data.Calculate("A#EvalACCOUNT1 = 12 * Eval(A#ACCOUNT1)",,,,,,,,,,,,,AddressOf OnEvalDataBuffer,,True)

     

  • MikeG's avatar
    MikeG
    2 years ago

    Hi swatantra , Intellisense will get you there.  

    Hope this helps

  • MikeG's avatar
    MikeG
    2 years ago

    FredLucas beat me to it, he posted it first.  Please give him the solution credit.

    Regards,

     

FredLucas's avatar
FredLucas
Contributor III

Hi,

One option would be to use this version of the api.Data.Calculate instead:

You can skip the different optional dimension filters if not required by just adding commas until you get to the arguments you are interested in (e.g.: onEvalDataBuffer, and isDurableCalculatedData) - example below. 

api.Data.Calculate("A#EvalACCOUNT1 = 12 * Eval(A#ACCOUNT1)",,,,,,,,,,,,,AddressOf OnEvalDataBuffer,,True)

 

MikeG's avatar
MikeG
Contributor III
2 years ago

FredLucas beat me to it, he posted it first.  Please give him the solution credit.

Regards,