Page 1 of 1

Tm1 REST api for dimension element Count

Posted: Fri Aug 31, 2018 3:45 pm
by kavitha2002
Hello everyone,

Is there a Tm1 Rest api query option to retrieve only the count of the dimension elements?

The below query works but its gives the count and elements. I want only the count of the elements.

http://host:8001/api/v1/Dimensions('Dim ... ts($count)

Thanks

Re: Tm1 REST api for dimension element Count

Posted: Fri Aug 31, 2018 6:04 pm
by lotsaram

Re: Tm1 REST api for dimension element Count

Posted: Sun Sep 02, 2018 7:48 pm
by kavitha2002
Thanks for the wonderful link lotsaram.

Even for my dimension the elements and members counts are different. Its a multi-headed dimension.

Query results to
{
"@odata.etag": "W/"7429"",
"Name": "Dimname",
"Elements@odata.count": 149,
"Members@odata.count": 198
}

Currently working on the performance improvement on dataLoad from tm1 to c# app.

Dont have idea of what to do next?? When this mdx querry is eat up all the memory.