REST API: Subset and Alias

Post Reply
Dimix
Posts: 32
Joined: Fri Jan 15, 2016 2:53 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

REST API: Subset and Alias

Post by Dimix »

Hi

This is the subset I'm using in this example. Please note that it's saved with an Alias selected.
Alias.PNG
Alias.PNG (8.25 KiB) Viewed 12867 times

I'm using following request to retrieve information about above subset:
https://localhost:12354/api/v1/Dimensio ... 'Default')

This is what I get back:
Capture.PNG
Capture.PNG (13.11 KiB) Viewed 12867 times
Can't see a reference to the alias that is used. How can I retrieve that information?

Do you know?

/R
User avatar
Mike Cowie
Site Admin
Posts: 482
Joined: Sun May 11, 2008 7:07 pm
OLAP Product: IBM TM1/PA, SSAS, and more
Version: Anything thru 11.x
Excel Version: 2003 - Office 365
Location: Alabama, USA
Contact:

Re: REST API: Subset and Alias

Post by Mike Cowie »

Hi Dimix,

The Alias isn't an official, documented property of a subset in the REST API, but it's accessible if you explicitly ask for the "Alias" property like so (threw in a quick element count example as well for you):

Code: Select all

.../api/v1/Dimensions('plan_business_unit')/Hierarchies('plan_business_unit')/Subsets('Default')?$select=Name,UniqueName,Expression,Attributes,Alias&$expand=Elements/$count
Result:
SubsetRestApiWithAlias.png
SubsetRestApiWithAlias.png (23.42 KiB) Viewed 12829 times
Hope that helps!
Mike
Mike Cowie
QueBIT Consulting, LLC

Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
Dimix
Posts: 32
Joined: Fri Jan 15, 2016 2:53 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: REST API: Subset and Alias

Post by Dimix »

Thanks Mike!
Post Reply