cellsetPut with multiple cubes


#1

Does cellsetPut support multiple cubes? Unless I was doing something wrong, it was writing values only into the first cube in the array, ignoring requests for other cubes. There were no error messages.


#2

Hi @aeremenko,

It should be able to update multiple cubes. That looks like a bug. Can you help submit a ticket for that?

Also include the TM1 and Canvas version.

Thanks!


Paul


#3

Hi @aeremenko yes this is a bug in the Rest API. I believe @mwirtz has already reported it and Hubert is aware of it.


#4

Hi,

No. Not a bug in the REST API (at least not in TM 11 and TM1 10.2.2 FP7).
Following Request works without issues:

POST https://localhost:12354/api/v1/Update

[
{
“Cube@odata.bind”:“Cubes(‘c2’)”,
“Cells”: [
{
“Tuple@odata.bind”: [
“Dimensions(‘d1’)/Hierarchies(‘d1’)/Elements(‘e1’)”,
“Dimensions(‘d2’)/Hierarchies(‘d2’)/Elements(‘e2’)”
]
}
],
“Value”: “1000”
},
{
“Cube@odata.bind”:“Cubes(‘c3’)”,
“Cells”: [
{
“Tuple@odata.bind”: [
“Dimensions(‘d1’)/Hierarchies(‘d1’)/Elements(‘e1’)”,
“Dimensions(‘d2’)/Hierarchies(‘d2’)/Elements(‘e3’)”,
“Dimensions(‘d3’)/Hierarchies(‘d3’)/Elements(‘e3’)”
]
}
],
“Value”: “1000”
}
]