Search found 36 matches

by MariusWirtz
Wed Jan 31, 2024 6:15 pm
Forum: Free And Open Source Tools
Topic: TM1py 2.0
Replies: 1
Views: 466

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 ...
by MariusWirtz
Sat Jan 13, 2024 3:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: OptimusPy - Ideal dimension order finder
Replies: 13
Views: 5253

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
by MariusWirtz
Sat Jan 13, 2024 3:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use TM1py with PAaaS instance
Replies: 2
Views: 632

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...
by MariusWirtz
Mon Jan 08, 2024 8:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: OptimusPy - Ideal dimension order finder
Replies: 13
Views: 5253

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...
by MariusWirtz
Tue Apr 18, 2023 9:48 am
Forum: Free And Open Source Tools
Topic: TM1py 1.11
Replies: 3
Views: 7441

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
by MariusWirtz
Mon Apr 17, 2023 10:08 am
Forum: Free And Open Source Tools
Topic: TM1py 1.11
Replies: 3
Views: 7441

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 ...
by MariusWirtz
Tue Jan 24, 2023 7:24 pm
Forum: Enhancements
Topic: Python Integration PA on Cloud
Replies: 4
Views: 8219

Re: Python Integration PA on Cloud

You have my vote :)
by MariusWirtz
Fri Jan 20, 2023 4:16 pm
Forum: Commercial and Events
Topic: TM1Py Support by Cubewise
Replies: 0
Views: 14765

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...
by MariusWirtz
Fri Jan 20, 2023 4:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 to python
Replies: 1
Views: 586

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...
by MariusWirtz
Mon Oct 10, 2022 3:00 pm
Forum: Free And Open Source Tools
Topic: TM1py 1.10
Replies: 0
Views: 7588

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...
by MariusWirtz
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: 1581

Re: Add elements to a dimension from PAfE

Thanks, Wim!

Totally agree. We would want to exclude empty cells! Thanks for the fix.
by MariusWirtz
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: 1581

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...
by MariusWirtz
Thu Feb 10, 2022 10:30 am
Forum: Free And Open Source Tools
Topic: TM1py 1.9
Replies: 1
Views: 7703

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
by MariusWirtz
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: 31567

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 ...
by MariusWirtz
Wed Sep 29, 2021 1:31 pm
Forum: Free And Open Source Tools
Topic: TM1py 1.8
Replies: 0
Views: 89098

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.
by MariusWirtz
Wed Sep 29, 2021 1:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 API Query
Replies: 2
Views: 2928

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...
by MariusWirtz
Wed Aug 11, 2021 7:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Querying the transaction log
Replies: 5
Views: 5205

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...
by MariusWirtz
Mon Aug 09, 2021 2:51 pm
Forum: Free And Open Source Tools
Topic: TM1py 1.6
Replies: 9
Views: 51121

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...
by MariusWirtz
Mon Aug 09, 2021 1:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics Integration With Google Sheets
Replies: 7
Views: 10245

Re: Planning Analytics Integration With Google Sheets

Hi,

sorry for the late reply.
I just wanted to confirm that you can indeed build a lovely integration between Planning Analytics and Google Sheets with Python and TM1py.

I did this recently for a customer. We implemented read and write features and TI process executions.
Happy to share more details.
by MariusWirtz
Tue Mar 30, 2021 10:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CAM authentication in RushTI
Replies: 2
Views: 2577

Re: CAM authentication in RushTI

Hi,

Yes. CAM security is supported. You need to adjust the config.ini accordingly.
https://code.cubewise.com/tm1py-help-co ... with-tm1py