Update multiple master measures in go using Engine API

Anonymous — Thu, 22 Feb 2018 08:22:51 GMT

Hi,

I have a mashup application wherein in need to update the formulae of multiple measures or dimensions in one go.

Let's suppose I have two master measures having IDs x1 and x2 having formula as below:

x1: Field1 + Field2

x2: FIeld1 + Field3

I need to replace Field1 with Field4 in both the measures.

The steps I am following to update the measure using Engine API are as follows:

1. CreateSessionObject

2. GetLayout

3. GetMeasure

4. GetProperties

5. SetProperties

6. DestroySessionObject

7. SaveChanges

I am using a loop to iterate through these IDs and calling these methods in sequence.

But the problem is that it updates the first Measure and not the subsequent one (receiving error: "{"jsonrpc":"2.0","id":0,"error":{"code":-32602,"parameter":"Invalid handle","message":"Invalid Params"}}").

I couldn't figure out what is causing the issue.

Any help would be greatly appreciated.

Regards,

Pradeep

Re: Update multiple master measures in go using Engine API

ErikWetterberg — Thu, 22 Feb 2018 20:16:26 GMT

Hi,

Looks like you use fixed values for handle in your commands, you probably need to parse the replies to find the actual handle, which will probably be different for the second measure.

I don't know your context, but another possibility is to use a variable in your expressions, and simply change the variable value.

Hope this helps

Erik Wetterberg

topic Re: Update multiple master measures in go using Engine API in Integration, Extension & APIs

Update multiple master measures in go using Engine API

Re: Update multiple master measures in go using Engine API