Search found 154 matches
- Tue May 07, 2024 7:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Email Alerts with PAW
- Replies: 3
- Views: 1753
Re: Email Alerts with PAW
I use a different approach. I have a 3-dimensional cube, with one of dimensions being }Processes where for each process I have a few flags such as : email on successful completion, email on complition with minor errors and email on failure with major error Then in Epilog of each process I have a few...
- Sun May 05, 2024 11:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Universal reports
- Replies: 7
- Views: 2599
Re: Universal reports
Hi guys, Is anyone aware of any utility that can help to migrate perspective reports to Universal Reports? Even if it does only half of the work, it will still be helpful We have lots of websheets with Active Forms which are really dynamic, so I know there will be impossible to find a utility that d...
- Wed Apr 24, 2024 1:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Button - Process Failed - with No Log
- Replies: 6
- Views: 1330
Re: Action Button - Process Failed - with No Log
This is an indication that the process did not get triggered at all, and usually this is due to security access or the name of process is not spelled correctly. If the name of Process is in a reference cell then check the cell, i usually use Named Ranges for process name, process params, and all oth...
- Tue Apr 23, 2024 12:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI Process with Cube and View Name as Parameter
- Replies: 5
- Views: 1700
Re: TI Process with Cube and View Name as Parameter
Is it possible to pass the view and cube name as a parameter of the TI Process for a more 'generic' export process? Can I pick the data source in the Prolog instead? Thanks. Yes you can, you can create the View in a master process and pass the name of the view to the other export process along with...
- Tue Apr 23, 2024 11:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Methods for Inputting Data into TM1 Cube
- Replies: 12
- Views: 1207
Re: Methods for Inputting Data into TM1 Cube
I have created a Python Script to do that. I pass the excel file to a python script, create a dataframe, I clean up the dataframe and at the end I store the Dataframe to a CSV file, which is consumed by a TI Process. The TI process can be executed from within Python Script (TM1Py), or it can be exec...
- Tue Apr 23, 2024 11:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can MDX work across alt hierarchies from one dim?
- Replies: 7
- Views: 919
- Mon Mar 25, 2024 9:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to avoid queuing at the end of processes parallelization ?
- Replies: 5
- Views: 2722
Re: How to avoid queuing at the end of processes parallelization ?
Do yourself a favor, use RushTI. Before I started using RushTI, process parallelization was always causing challenges.
- Sun Mar 24, 2024 6:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 83
- Views: 14775
Re: Ultimate Long TM1 quiz
Data will be spread to leaf cells proportionally with existing values.
In this Case:
Value of January will change from 2 to 3, and value of February will change from 4 to 6. Value of March will remain zero
In this Case:
Value of January will change from 2 to 3, and value of February will change from 4 to 6. Value of March will remain zero
- Mon Mar 11, 2024 1:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding two if loops to a statement
- Replies: 4
- Views: 1581
Re: Adding two if loops to a statement
lol: I was thinking exactly the same. Impossible to follow the question with these object namesWim Gielis wrote: ↑Wed Mar 06, 2024 5:52 am Hello,
Can I ask you why you don’t finish your words and dimension names? It seems weird to have dimension names like that. I have never seen such strange dimension names.
- Sat Jan 20, 2024 2:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 83
- Views: 14775
Re: Ultimate Long TM1 quiz
In that case, all cells will ne fed. Previously fed cells will remain fed until feeders will be rebuilt. On top of existing feeders, the updated feeder will Feed A1, so the results will be: ABC1('A1', 'Total Year') = 31 ABC1('B1', 'Total Year') = 16 ABC1('C1', 'Total Year') = 15 But after the feeder...
- Sun Jan 14, 2024 2:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 83
- Views: 14775
Re: Ultimate Long TM1 quiz
Still the results will be the same:
ABC1('A1', 'Total Year') = 0
ABC1('B1', 'Total Year') = 16
ABC1('C1', 'Total Year') = 15
ABC1('A1', 'Total Year') = 0
ABC1('B1', 'Total Year') = 16
ABC1('C1', 'Total Year') = 15
- A1 will not be fed
B1 will be fed from B
C1 will be fed from C
- Sat Jan 06, 2024 3:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 83
- Views: 14775
Re: Ultimate Long TM1 quiz
Only B1 and C1 are being fed, so the in the ABC1 Cube, the value of each elements will be:
ABC1('A1', 'Total Year') = 0 # A1 is not being fed,
ABC1('B1', 'Total Year') = 16
ABC1('C1', 'Total Year') = 15
ABC1('A1', 'Total Year') = 0 # A1 is not being fed,
ABC1('B1', 'Total Year') = 16
ABC1('C1', 'Total Year') = 15
- Sun Dec 31, 2023 4:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18803
Re: REST API Dimension Clone
Thank you Ardian. Good additions. Maybe useful to post a sample file for 'config.ini' (though probably standard and not too difficult to do it ourselves) ? Of course without sensitive information but just the structure and some examples of entries. I would also skip the If test for the PRO extensio...
- Thu Dec 28, 2023 10:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18803
Re: REST API Dimension Clone
Here is the version of the code I use to promote TIs from one TM1 Instance to another. I have a config file where I save all the connection details and I created a function to get all the information i need from the config file Also, I check if the Process exists in Target Instance. If it exists, I ...
- Wed Dec 13, 2023 2:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Flexible PickList Definitions
- Replies: 2
- Views: 3576
Re: Flexible PickList Definitions
Hi, I want to have a Picklist for all used user defined dimensions. So I want a complete list of all elements, which would be: Dimension:DimName I also want to offer a list of all elements without the top level and a list without the leaf elements. Additionally I need to show attribute names define...
- Tue Dec 12, 2023 4:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW - GIT Repository Connection issue
- Replies: 9
- Views: 4189
Re: PAW - GIT Repository Connection issue
Public or enterprise Github? I ran into similar errors trying to connect on-prem PAW to an enterprise Github repo and so far haven't got it working. I suspected that the connection was being blocked/rejected by enterprise github admins but haven't confirmed that. You are using the SSH url and not t...
- Tue Dec 12, 2023 3:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW - GIT Repository Connection issue
- Replies: 9
- Views: 4189
PAW - GIT Repository Connection issue
Hello, We are trying to use the new PAW feature to add TM1 objects to GIT Repository, and for some reason, we cannot make it work. We have generated the SSH Public Key / Private Key, and also saved the SSH Key to GitHub, but when we enter the Repo URL / SSH Keys in PAW, we receive an error: TM1 Git ...
- Thu Dec 07, 2023 3:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ViewZeroOut doesn't work
- Replies: 11
- Views: 16912
Re: ViewZeroOut doesn't work
Found one very strange thing in one TM1 model I can't zero any view in one Cube in it using ViewZeroOut. I've done different things - at the end I deleted all rules from cube and put in view only detail elements. But ViewZeroOut doesn't work again CellPutN works, I can put 0 by hands but ViewZeroOu...
- Wed Nov 08, 2023 8:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 Model - Limit Overall RAM Usage
- Replies: 8
- Views: 10364
Re: Tm1 Model - Limit Overall RAM Usage
Hi there We have inherited a complex model (which is non business critical) which on rare occasions (every few months), start spiking the RAM to a point where the RAM for the entire server maxes out, and all models go down. Obviously we need to get to the root cause of what is causing this (initial...
- Wed Nov 08, 2023 8:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 Model - Limit Overall RAM Usage
- Replies: 8
- Views: 10364