Search found 38 matches
- Wed Apr 03, 2024 4:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: OptimusPy - Ideal dimension order finder
- Replies: 15
- Views: 6517
Re: OptimusPy - Ideal dimension order finder
If you are using v12 on MCSP, this should work. Just substitute the 3 placeholders with their appropriate values. [tm1srv01] base_url=https://us-east-1.planninganalytics.saas.ibm.com/api/<TenantId>/v0/tm1/<DatabaseName>/ user=apikey password=<TheActualApiKey> async_requests_mode=True ssl=True verify...
- Wed Apr 03, 2024 4:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Use TM1py with PAaaS instance
- Replies: 3
- Views: 1695
Re: Use TM1py with PAaaS instance
Now that IBM is moving v12 instances to MCSP, the TM1py authentication looks slightly different. Here is an example of how to connect to TM1 v12 on MCSP. If you substitute the 3 placeholders <TenantId>, <DatabaseName>, <TheActualApiKey>, it should just work. from TM1py import TM1Service params = { &...
- Wed Jan 31, 2024 6:15 pm
- Forum: Free And Open Source Tools
- Topic: TM1py 2.0
- Replies: 1
- Views: 1478
TM1py 2.0
Hi everyone, We just released TM1py 2.0. You can find all the details here: https://github.com/cubewise-code/tm1py/releases/tag/2.0 Among many other things, this release offers - support for TM1 v12 - performance improvements - new functions to update dimensions or clear a cube directly from a data ...
- Sat Jan 13, 2024 3:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: OptimusPy - Ideal dimension order finder
- Replies: 15
- Views: 6517
Re: OptimusPy - Ideal dimension order finder
Hi Ajit,
To get started on TM1py, I can recommend this training.
https://edu.cubewise.com/training-tm1py-fundamentals/
I also recommend familiarizing yourself with the basics of Python.
This YouTube tutorial covers all the basics in the first few hours.
https://www.youtube.com/watch?v=nLRL_NcnK-4
To get started on TM1py, I can recommend this training.
https://edu.cubewise.com/training-tm1py-fundamentals/
I also recommend familiarizing yourself with the basics of Python.
This YouTube tutorial covers all the basics in the first few hours.
https://www.youtube.com/watch?v=nLRL_NcnK-4
- Sat Jan 13, 2024 3:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Use TM1py with PAaaS instance
- Replies: 3
- Views: 1695
Re: Use TM1py with PAaaS instance
Hi Mark we just completed the work for TM1 v12 (PAaaS) the other week, with special thanks to Ryan, the main developer behind this feature. https://github.com/cubewise-code/tm1py/pull/1000 We plan to draft a release in a week or two. To get the functionality now, you can already upgrade to the curre...
- Mon Jan 08, 2024 8:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: OptimusPy - Ideal dimension order finder
- Replies: 15
- Views: 6517
Re: OptimusPy - Ideal dimension order finder
I can't reproduce the error. Two questions: - Are you using the latest version of OptimusPy? - Do you have the same folder structure locally as in the project? You need to download the folder as it is in the project here: https://github.com/cubewise-code/optimus-py So the "optimuspy.py" fi...
- Tue Apr 18, 2023 9:48 am
- Forum: Free And Open Source Tools
- Topic: TM1py 1.11
- Replies: 3
- Views: 7938
Re: TM1py 1.11
You can upgrade RushTI to resolve this issue.
Please post questions regarding RushTI here:
https://github.com/cubewise-code/rushti/issues
Please post questions regarding RushTI here:
https://github.com/cubewise-code/rushti/issues
- Mon Apr 17, 2023 10:08 am
- Forum: Free And Open Source Tools
- Topic: TM1py 1.11
- Replies: 3
- Views: 7938
TM1py 1.11
Hi everyone, on Friday we released TM1py 1.11. You can find all details here: https://github.com/cubewise-code/tm1py/discussions/901 This release closes the performance gap in write speed between TM1py and Turbo Integrator. All new features are backward compatible and all upgrades should be free of ...
- Tue Jan 24, 2023 7:24 pm
- Forum: Enhancements
- Topic: Python Integration PA on Cloud
- Replies: 4
- Views: 9363
Re: Python Integration PA on Cloud
You have my vote
- Fri Jan 20, 2023 4:16 pm
- Forum: Commercial and Events
- Topic: TM1Py Support by Cubewise
- Replies: 0
- Views: 16614
TM1Py Support by Cubewise
Starting this year we will offer "TM1Py Support by Cubewise". I want to announce this quickly myself as well as answer a couple of questions people might have to avoid any misunderstandings. TL/DR: TM1Py Support by Cubewise in no way compromises the open-source nature of the project. ▶ Why...
- Fri Jan 20, 2023 4:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 to python
- Replies: 1
- Views: 643
Re: TM1 to python
Hi, are you connecting to TM1 on-cloud or PA on-premise? If you are using TM1 on-premise, what IntegratedSecurityMode are you using? For TM1 on cloud you can use this article as a reference. https://code.cubewise.com/tm1py-help-content/connecting-to-the-ibm-cloud-remotely-with-tm1py For TM1 on cloud...
- Mon Oct 10, 2022 3:00 pm
- Forum: Free And Open Source Tools
- Topic: TM1py 1.10
- Replies: 0
- Views: 8263
TM1py 1.10
Hi everyone, today we released TM1py 1.10. You can find all details here: https://github.com/cubewise-code/tm1py/discussions/811 The release includes all improvements and bug fixes that have been done since February this year! I would encourage everyone to upgrade. All the new stuff is backward comp...
- Fri Jul 22, 2022 8:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Add elements to a dimension from PAfE
- Replies: 6
- Views: 1662
Re: Add elements to a dimension from PAfE
Thanks, Wim!
Totally agree. We would want to exclude empty cells! Thanks for the fix.
Totally agree. We would want to exclude empty cells! Thanks for the fix.
- Thu Jul 21, 2022 11:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Add elements to a dimension from PAfE
- Replies: 6
- Views: 1662
Re: Add elements to a dimension from PAfE
Hi, instead of using a macro and the PAX API, you could also use a py script to read the column values from excel and add the elements to the dimension with TM1py. Here is a sample in case you are interested: import openpyxl from TM1py import TM1Service excel_products = set() wb = openpyxl.open(&quo...
- Thu Feb 10, 2022 10:30 am
- Forum: Free And Open Source Tools
- Topic: TM1py 1.9
- Replies: 1
- Views: 8219
TM1py 1.9
Hi everyone,
We released TM1py 1.9 this week You can find an overview of the new release here:
https://github.com/cubewise-code/tm1py/discussions/685
We released TM1py 1.9 this week You can find an overview of the new release here:
https://github.com/cubewise-code/tm1py/discussions/685
- Thu Nov 11, 2021 6:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI View Execution vs MDX View
- Replies: 13
- Views: 31725
Re: TI View Execution vs MDX View
Hi, I can confirm that one can process through a cubeview/MDX more efficiently with a TI than one could do with REST/TM1py. Somehow TI doesn't materialize the full view in Memory before consuming it. In the REST world it works differently. It's essentially a two-step process. 1. First, one executes ...
- Wed Sep 29, 2021 1:31 pm
- Forum: Free And Open Source Tools
- Topic: TM1py 1.8
- Replies: 0
- Views: 89713
TM1py 1.8
We just released TM1py 1.8
You can find an overview of the new release here:
https://github.com/cubewise-code/tm1py/ ... /tag/1.8.0
I hope this will be useful to the TM1 community.
You can find an overview of the new release here:
https://github.com/cubewise-code/tm1py/ ... /tag/1.8.0
I hope this will be useful to the TM1 community.
- Wed Sep 29, 2021 1:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 API Query
- Replies: 2
- Views: 2982
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 y...
- Wed Aug 11, 2021 7:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Querying the transaction log
- Replies: 5
- Views: 5311
Re: Querying the transaction log
Hello 20 Ton Squirrel, there is actually a more direct way to get the info from the transaction log in memory. You can use the TM1 REST API (or TM1py) to query the transaction log from the TM1 Server. You can send a query to TM1 to filer the transaction log by "cube", "user", &qu...
- Mon Aug 09, 2021 2:51 pm
- Forum: Free And Open Source Tools
- Topic: TM1py 1.6
- Replies: 9
- Views: 51769
Re: TM1py 1.6
Hi Michael, thanks! Am I understanding you right, that your desired data flow is PowerBI -> TM1? Interesting! Once you have the data in python it is straightforward to bring it to a TM1 cube with TM1py. However, the first part for python to retrieve data from a PBI model could be a bit more challeng...