search

cubewise-code / tm1py

TM1py is a Python package that wraps the TM1 REST API in a simple to use library.
http://tm1py.readthedocs.io/en/latest/
MIT License
189 stars 109 forks source link

TM1 REST API - Getting alias value when retrieving a cube view #637

Closed ards14 closed 3 years ago

ards14 commented 3 years ago

Hi all,

I'm trying to retrieve cube a view using the REST API. I want to retrieve data similar to architect view with alias turned on in few dimensions, API retrieves only native elements.

Is there a way to retrieve attribute names in cellset, For example Quarter dimension retrieves native elements in Fiscal year format, but i need quarters to be extracted in Calendar year format which is an attribute.

Below is my Code :

https://xxxx.planning-analytics.ibmcloud.com/tm1/api/FPA/api/v1/Cubes('P&L')/Views('P&L')/tm1.Execute?$expand=Axes($expand=Hierarchies($select=Name),Tuples($expand=Members($select=Name))),Cells

MariusWirtz commented 3 years ago

Does this solve your problem? https://github.com/cubewise-code/tm1py/issues/624#issuecomment-934271539

ards14 commented 3 years ago

Hi Marius, Thanks for the quick response, Unfortunately i can't use TM1py our end user is SAP PO/PI. They are trying to retrieve cube view contents via REST API. View pulls native elements . I need alias values to be pulled for few dimensions, not sure how to pull these inside tuples. Any help would be appreciated!

Thanks, Aravind

MariusWirtz commented 3 years ago

Please open only TM1py related issues.