Search found 732 matches

by paulsimon
Fri Mar 13, 2020 7:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hold and Proportional Spread
Replies: 6
Views: 211

Re: Hold and Proportional Spread

Hi You seem to have included pseudo code and haven't given the source view so it is hard to understand the issue. What is the business problem that you are trying to solve? It seems like you want to phase some overall cost over months without changing the year total, presumably according to some pat...
by paulsimon
Wed Mar 11, 2020 10:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Buttons parameters & Filtering two dimensions on the same side
Replies: 1
Views: 602

Re: PAW Buttons parameters & Filtering two dimensions on the same side

Hi Hector The inability to link the parameters of a TI Process in an Action Button to selections on a PAW workbook is a serious limitation that I have already raised with IBM. We cannot convert any of our existing TM1 Web screens to PAW until this is resolved as all of them need workflow that is man...
by paulsimon
Thu Mar 05, 2020 9:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updateing Model to Hierarchys
Replies: 4
Views: 424

Re: Updating Model to Hierarchys

Hi PavoGo Yes we do the same. Add any base level elements not in the Leaves hierarchy to the Leaves hierarchy and then add the base level from the Leaves to the Default hierarchy. I have raised the bug of the Leaves hierarchy not automatically being updated with base level elements and IBM are worki...
by paulsimon
Thu Feb 27, 2020 8:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updateing Model to Hierarchys
Replies: 4
Views: 424

Re: Updateing Model to Hierarchys

Hi Yes that is right. If you don't specify a hierarchy PA will look at the Default hierarchy, ie what you had before you added any named hierarchies. Therefore DBRWs will still work. If you only enter data against base level elements then those values will be shared across all hierarchies, since the...
by paulsimon
Mon Feb 17, 2020 10:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 User Locks
Replies: 2
Views: 208

Re: TM1 User Locks

Hi Maren When creating the views and subsets on the fly, try creating temporary subsets and views. It doesn't matter what they are called since they only exist within the user's session and for the duration of the process. We found that this gave a dramatic reduction in locking. If you create perman...
by paulsimon
Mon Feb 03, 2020 10:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String size limit of a parameter in a TI
Replies: 11
Views: 409

Re: String size limit of a parameter in a TI

Hi

Also when you run a TI process always check the return code eg

vRet = ExecuteProcess(...)

IF( vRet <> ProcessExitNormal() ) ;
.... Some error handling
ENDIF ;
by paulsimon
Mon Feb 03, 2020 10:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 8219

Re: RunProcess explanation

Hi Are all the processes operating on separate views with separate subsets? If not then one process may be destroying the view used by another part way through. Using temporary subsets and views may help overcome that. However, I still tend to agree with others here, that experimenting with parallel...
by paulsimon
Sun Feb 02, 2020 10:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String size limit of a parameter in a TI
Replies: 11
Views: 409

Re: String size limit of a parameter in a TI

Good point Declan. I recently had an issue where someone had used a hard-return in the column heading of an Excel worksheet and then saved it as a CSV file. When read in, it made the TI miss out something like the first 500 lines of the file. It wasn't something you could detect and fix in the TI be...
by paulsimon
Sun Feb 02, 2020 5:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String size limit of a parameter in a TI
Replies: 11
Views: 409

Re: String size limit of a parameter in a TI

Hi It can depend on how you are passing the parameter. If you are passing it from an Action Button via Excel then I believe the limit is only 255 chars, but this is due to a limitation in Excel rather than TI. I have never really needed to pass a parameter that big, but in TI I have certainly built ...
by paulsimon
Mon Jan 27, 2020 10:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use of DimensionDeleteAllElements
Replies: 3
Views: 194

Re: Use of DimensionDeleteAllElements

Hi There are some other reasons to avoid using DimensionDeleteAllElements. If the rebuild fails a) Elements will be deleted from any Static Subsets b) Any views that referenced the deleted element in title subsets may be invalidated c) If you reference consolidated elements in rules, the rules will ...
by paulsimon
Thu Jan 23, 2020 9:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process Error Log Not Available
Replies: 12
Views: 317

Re: Process Error Log Not Available

Hi Tom Your solution is pretty much what we do. However, one suggestion is that rather than have the attribute on the process dimension, have it on the client dimension or a copy of that. The reason being that if two users run the same process and both get an error, then there will only be a record ...
by paulsimon
Tue Jan 21, 2020 10:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic YTD Calculation on a Continuous Time Dimension
Replies: 15
Views: 348

Re: Dynamic YTD Calculation on a Continuous Time Dimension

Hi As Lotsaram says, consolidation is the way to do this. Rules are in general 100 times slower than consolidation. However, be careful how you arrange the rollups. In the past I would have done this using a chaining method like this. 1st Jan YTD = 1st Jan 2nd Jan YTD = 1st Jan YTD + 2nd Jan 3rd Jan...
by paulsimon
Mon Jan 20, 2020 8:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Protect DBRW fomrula in Perspectives
Replies: 8
Views: 388

Re: Protect DBRW fomrula in Perspectives

Hi Your profile shows that you are still on 10.2.2. If so, then I would consider upgrading to Planning Analytics. You can then use PAX which will give faster performance than Perspectives. I say this because if you are about to start writing VBA you might end up having to re-write it again when you ...
by paulsimon
Thu Jan 16, 2020 11:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: To know Active Users & Inactive Users of TM1
Replies: 12
Views: 540

Re: To know Active Users & Inactive Users of TM1

Hi Deleting users is a bad idea for many reasons. You will potentially lose Private Views and Subsets stored against those users. If there is anything else stored against the user it will also be lost, such as TM1 Web settings, Locks on Dimension Elements, etc. If the user does not already exist, th...
by paulsimon
Wed Jan 15, 2020 11:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Protect DBRW fomrula in Perspectives
Replies: 8
Views: 388

Re: Protect DBRW fomrula in Perspectives

Hi I know what you mean. Users simply deleting DBRW formula is one issue. The worst case is where they start cutting and pasting and you end up with a DBRW alongside one row column combination that is actually pointing at a completely different row and column and it is therefore showing the wrong va...
by paulsimon
Thu Jan 09, 2020 10:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Asciioutput Data Export is not working
Replies: 3
Views: 204

Re: Asciioutput Data Export is not working

Hi You only quoted part of my answer. If you read my full answer then that will answer your question. "There is unfortunately a known bug when exporting text from an MDX View which IBM are going to fix soon. However, your case is not quite the same as you are using a native view, albeit with a fairl...
by paulsimon
Thu Jan 09, 2020 10:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User Being Removed From Security Group in TM1
Replies: 2
Views: 139

Re: User Being Removed From Security Group in TM1

Hi Peter The fact that the security is resetting itself at login almost certainly means that it is something to do with CAM since that is the point at which CAM will copy Group membership from the security store, typically Windows Active Directory, in to TM1 Security Groups. If you open up }ClientGr...
by paulsimon
Wed Jan 08, 2020 8:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Asciioutput Data Export is not working
Replies: 3
Views: 204

Re: Asciioutput Data Export is not working

Hi Are you outputting text values rather than numerics? I am guessing that you are since you don't have any conversion on the asciioutput There is unfortunately a known bug when exporting text from an MDX View which IBM are going to fix soon. However, your case is not quite the same as you are using...
by paulsimon
Fri Jan 03, 2020 9:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Getting Subset Properties
Replies: 2
Views: 164

Re: Error Getting Subset Properties

Hi Are you talking about PAX? We encountered a similar issue whereby even a Native View has to have a column dimension. A View that only has rows, and context elements won't work. Does your view with filtered MDX on the rows have at least one dimension on the columns? We have encountered similar iss...
by paulsimon
Wed Dec 18, 2019 10:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server crash on saving dimension (status Suspended)
Replies: 14
Views: 1796

Re: TM1 Server crash on saving dimension (status Suspended)

Hi It looks like Ken's problem was specific to the Dimension Editor, but from PavoGa's description it looks like a crash from a TI process. Is that the case? We have also had some crashes with the Dimension Editor but fortunately only in Non-Production environments, as we don't really use the Dimens...