Search found 3024 matches
- Thu Mar 28, 2024 12:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to avoid queuing at the end of processes parallelization ?
- Replies: 5
- Views: 442
Re: How to avoid queuing at the end of processes parallelization ?
Also, 2000 processes doing less work is most of the time less optimal than less processes doing more work (on average).
- Thu Mar 28, 2024 12:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Financial Consolidation TM1 Sample Module
- Replies: 1
- Views: 153
Re: Financial Consolidation TM1 Sample Module
That would definitely be useful. Maybe uploading to a Google Drive ? Or your own webspace if possible ?
- Mon Mar 25, 2024 10:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Rule to Propagate Values Between Dimensions
- Replies: 6
- Views: 487
Re: TM1 Rule to Propagate Values Between Dimensions
Do you really think people will still want to help, voluntarily, after your first post here ?
viewtopic.php?t=16641
Hijacking a thread, not responding to help given, etc.
Not for me
viewtopic.php?t=16641
Hijacking a thread, not responding to help given, etc.
Not for me
- Thu Mar 21, 2024 2:55 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CubeSecurity and ProcessSecurity
- Replies: 4
- Views: 452
Re: CubeSecurity and ProcessSecurity
No it will not give an error.
- Thu Mar 21, 2024 1:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: A couple of strange TM1 bugs
- Replies: 4
- Views: 2307
Re: A couple of strange TM1 bugs
Could it be some kind of string length that is exceeded, when concatenating parameter names and parameter values at runtime ?
- Tue Mar 19, 2024 5:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 927
- Tue Mar 19, 2024 9:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 927
Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes
200 GB ? No rules and feeders ?
You don’t have to put the whole TM1 model in 1 cube.or are you recreating the DWH in a cube ?
You don’t have to put the whole TM1 model in 1 cube.or are you recreating the DWH in a cube ?
- Mon Mar 18, 2024 8:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 927
Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes
"We have a Turbo Integrator that makes a copy within the same cube. In the source cube, we selected a consolidated level, and in the target cube, we load at a fine level." Now, what is it, same cube or different cube ? Not that it makes a lot of difference, but still. If I were you, I woul...
- Mon Mar 18, 2024 7:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Planning Analytics workspace is down
- Replies: 8
- Views: 1107
Re: Planning Analytics workspace is down
Hello,
I do have a suggestion. Why don't you use a recent version of the software (and related OS) ?
You are now on software that is almist 4 years old. In PAW and PA-land this is quite a big gap.
2.0.9.2 is from July 2020.
I do have a suggestion. Why don't you use a recent version of the software (and related OS) ?
You are now on software that is almist 4 years old. In PAW and PA-land this is quite a big gap.
2.0.9.2 is from July 2020.
- Mon Mar 18, 2024 5:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 927
Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Version 11.8.00800.5 ?
That is 2.0.9.9 from July 2021 and 3 years old.
Plenty of changes and fixes in the meantime. I would try upgrading first.
I also had issues with RunProcess and only in 2.0.9.19 it seemed solved.
That is 2.0.9.9 from July 2021 and 3 years old.
Plenty of changes and fixes in the meantime. I would try upgrading first.
I also had issues with RunProcess and only in 2.0.9.19 it seemed solved.
- Mon Mar 18, 2024 4:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 927
Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes
That's not the full picture. You need the version of PA, not (necessarily) the version of PAW.
2.0.9 something probably
2.0.9 something probably
- Mon Mar 18, 2024 3:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 927
Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Difficult to say with this information but I know that efforts were made regarding RunProcesses in the latest versions.
What version are you using for the PA server ?
What version are you using for the PA server ?
- Mon Mar 18, 2024 9:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBCOutput Delete table error with MS SQL2019
- Replies: 7
- Views: 290
Re: ODBCOutput Delete table error with MS SQL2019
Hello, I did not mean a production environment, but a testing environment would have been good too. Nice to see that there is a solution. Just note that ExecuteCommand will not be available anymore in the next major version of PA (that being said, changes to ODBC could come too but that's a differen...
- Mon Mar 18, 2024 7:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBCOutput Delete table error with MS SQL2019
- Replies: 7
- Views: 290
Re: ODBCOutput Delete table error with MS SQL2019
Hello,
Do you have an environment with the latest version of PA ?
Do you have an environment with the latest version of PA ?
- Fri Mar 15, 2024 8:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Moving data from cube with different dimension
- Replies: 5
- Views: 258
Re: Moving data from cube with different dimension
2 people who do not reply anymore because no one wrote down all the code they needed ?
- Mon Mar 11, 2024 1:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding two if loops to a statement
- Replies: 4
- Views: 699
- Fri Mar 08, 2024 5:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Conditional Pick Lists
- Replies: 3
- Views: 174
Re: Conditional Pick Lists
Hi Wim, Thank you for this. It really helped me to understand more about using picklist control cubes. I've wrote this rule for one of my picklists: ['Tableau Sub-Function Level 1']=S:IF(DB('74 MDM Tableau - Entity and Cost Centre W Locations',!070 MDM - Tableau Reporting Log List,'Tableau Function...
- Thu Mar 07, 2024 5:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Conditional Pick Lists
- Replies: 3
- Views: 174
Re: Conditional Pick Lists
Hello
Did you try Google on:
TM1 dependent picklists
Did you try Google on:
TM1 dependent picklists
- Wed Mar 06, 2024 5:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding two if loops to a statement
- Replies: 4
- Views: 699
Re: Adding two if loops to a statement
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. You mentioned that you have double loops, but I don’t see any code for that. I would also like to question your cube design. Ins...
- Mon Mar 04, 2024 6:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Moving data from cube with different dimension
- Replies: 5
- Views: 258
Re: Moving data from cube with different dimension
Yes, but I need help with the TI code As is the case for many TI processes, the Prolog tab code contains a zero out of the target cells. Also, the Prolog tab contains the code for creating a view collecting the input cells - those that need to be allocated. After that, the Data tab contains code to...