11-02-2023 04:04 AM
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 consolidated it, the data got cleared from the same destination intersections.
On checking the cell status of the destination cell (intersection), i found that the storage type is Calculation
Whereas, if we use api.Data.Calculate(formula, isDurableCalculatedData), the storage type is DurableCalculation, and consolidation works fine after using this Calculate function.
We do we have a boolean parameter to set the DurableCalc as True or False in the api.Data.Calculate(formula, isDurableCalculatedData) function, but i didn't see any such parameter or setting for Buffers [Calculate(formula, onEvalDataBuffer, userState)].
How can i make the StorageType as Calculation to DurableCalculation for Buffers, so that the values doesn't disappear after consolidation ?
Solved! Go to Solution.
11-02-2023 05:29 AM
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)
11-02-2023 09:10 AM
11-02-2023 09:11 AM
11-02-2023 05:29 AM
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)
11-02-2023 09:11 AM
11-06-2023 01:03 AM
Thankyou Fred, this worked !
11-02-2023 09:10 AM
11-06-2023 01:03 AM
Thankyou Mike, this worked !