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
Tm1 REST api for dimension element Count
-
- Community Contributor
- Posts: 180
- Joined: Sat May 05, 2018 11:48 am
- OLAP Product: tm1
- Version: 10.3.10100.8
- Excel Version: 14
-
- 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
Did you search?
http://www.tm1forum.com/viewtopic.php?f ... unt#p69937
http://www.tm1forum.com/viewtopic.php?f ... unt#p69937
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- 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
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.
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.