Search found 148 matches
- 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: 1107
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: 68
- Views: 8185
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: 1042
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: 68
- Views: 8185
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: 68
- Views: 8185
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: 68
- Views: 8185
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: 18675
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: 18675
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: 3513
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: 4102
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: 4102
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: 16762
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: 10257
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: 10257
- 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: 6734
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: 2907
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
- Thu Oct 12, 2023 3:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Transferring and Summing Data from cube to another
- Replies: 4
- Views: 6840
Re: Transferring and Summing Data from cube to another
Hi Everyone, A quick explanation of what I want to do: I have a cube of investments with a dimension "invart1", which I want to summarize in a separate cube. I understand I need to use a process to do so, is that correct? Or is there al although a way with a rule? I just want to start in ...
- Mon Sep 11, 2023 12:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Buttons - VBA to Change Server Name
- Replies: 6
- Views: 719
Re: Action Buttons - VBA to Change Server Name
Hi there I am trying to use VBA to change the Server name for multiple actions buttons (in multiple workbooks) in Perspectives There is an article from Wim Gielis which details exactly how to do this: https://www.wimgielis.com/tm1_actionbuttons_EN.htm Unfortunately, I cannot figure out how to add t...
- Sun Aug 27, 2023 3:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ClientGroups cube not in sync. with Cognos
- Replies: 11
- Views: 1412
Re: }ClientGroups cube not in sync. with Cognos
Is the Client Groups membership defined in Cognos or in LDAP (Active Directory)? If it is in Active Directory, you can run some powershell script to extract the User/Group mappings. If they are defined in Cognos, then you can run a SQL against Cognos Content Store database tables ( as suggested by E...
- Wed Aug 23, 2023 12:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Next-Button when using SUBNM formula
- Replies: 2
- Views: 564
Re: Next-Button when using SUBNM formula
First thing, you need to have an attribute "Next_Month" on your Time/Month dimension. Then in your "Next Month" Action Button, make it Navigate to the same Websheet, but set the "Advanced Options" so the "Next_Month" Value of your Selected Month, for Target Ty...