Hi Team,
We are trying to import some data from a tm1 cube/View using API technology through Postman.
What is the best command /URL to extract data from a view, We need both row/column data including headers.
We have tried below URL but it is only giving measure values..
POST https://localhost:8881/api/v1/Cubes('General Ledger')/Views('P&L')/tm1.Execute?$expand=Cells
Regards,
Neelima
Tm1 API Query
-
- Posts: 19
- Joined: Tue Nov 13, 2018 3:16 am
- OLAP Product: COGNOS TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Tm1 API Query
HI Team,
I have used below sample URL and it is lot better.
https://awsptm1pa:8086/api/v1/Cubes('Cu ... xpand=Axes($expand=Hierarchies($select=Name),Tuples($expand=Members($select=Name))),Cells
Regards,
Neelima
I have used below sample URL and it is lot better.
https://awsptm1pa:8086/api/v1/Cubes('Cu ... xpand=Axes($expand=Hierarchies($select=Name),Tuples($expand=Members($select=Name))),Cells
Regards,
Neelima
-
- Posts: 31
- Joined: Sat Apr 08, 2017 8:40 pm
- OLAP Product: TM1
- Version: 10.2.2.6
- Excel Version: 2016
Re: Tm1 API Query
Hi,
maybe checkout tm1py.
It's an open-source python package that makes it easy to build stuff with the TM1 REST API.
https://github.com/cubewise-code/tm1py
It provides functions to retrieve data from cube views or through MDX.
You can also retrieve data directly as a data frame. That is useful if you want to save it as XLSX or want to do advanced analytics with the data.
maybe checkout tm1py.
It's an open-source python package that makes it easy to build stuff with the TM1 REST API.
https://github.com/cubewise-code/tm1py
It provides functions to retrieve data from cube views or through MDX.
You can also retrieve data directly as a data frame. That is useful if you want to save it as XLSX or want to do advanced analytics with the data.
Code: Select all
from TM1py import TM1Service
with TM1Service(address="", port=12354, ssl=True, user="admin", password="apple") as tm1:
data_frame = tm1.cells.execute_view_dataframe(cube_name="Sales", view_name="Default", private=False)
print(data_frame)
State | SalesMeasure | Value | |
0 | AK | Gross Margin | 1413042.040 |
1 | AK | Revenue | 1544055.000 |
2 | AK | COGS | 131012.960 |
3 | AZ | Gross Margin | 83001.740 |
4 | AZ | Revenue | 175440.240 |
5 | AZ | COGS | 92438.500 |
6 | CA | Gross Margin | 921247.800 |
7 | CA | Revenue | 2075148.000 |
8 | CA | COGS | 1153900.200 |
9 | CO | Gross Margin | 15677.264 |
10 | CO | Revenue | 28648.464 |