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
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
    Contributor III
    2 years ago

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

    Regards,

     

  • swatantra's avatar
    swatantra
    New Contributor II
    2 years ago

    Thankyou Fred, this worked !