Search found 152 matches
- Wed Apr 24, 2024 1:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Button - Process Failed - with No Log
- Replies: 5
- Views: 625
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: 581
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: 367
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: 6
- Views: 209
- 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: 1121
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: 70
- Views: 8485
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: 1049
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: 70
- Views: 8485
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: 70
- Views: 8485
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: 70
- Views: 8485
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: 18693
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: 18693
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: 3520
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: 4111
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: 4111
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: 16780
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: 10272
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: 10272
- Mon Nov 06, 2023 3:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding another if loop on status
- Replies: 3
- Views: 6736
Re: Adding another if loop on status
Formatting your code will go a long way in helping you to read/understand it and posting within a code block will go a long way in helping the rest of us help you. By the CellGetN you posted at the bottom for InvStatus, it appears you're using only the variables defined in the source view to derive...
- Mon Oct 23, 2023 3:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pafe/PAW View - Auto Spread at Consolidated Level
- Replies: 2
- Views: 2909
Re: Pafe/PAW View - Auto Spread at Consolidated Level
And if you want to keep Spreading enabled for some of the users, you should consider turning OFF this option
ProportionSpreadToZeroCells=F
By default this is turned on and in my experience this is dangerous
ProportionSpreadToZeroCells=F
By default this is turned on and in my experience this is dangerous