Tm1 REST api for dimension element Count

Post Reply
kavitha2002
Community Contributor
Posts: 180
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

Tm1 REST api for dimension element Count

Post 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
lotsaram
MVP
Posts: 3652
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Tm1 REST api for dimension element Count

Post by lotsaram »

Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
kavitha2002
Community Contributor
Posts: 180
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

Re: Tm1 REST api for dimension element Count

Post 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.
Post Reply