Search found 747 matches

by paulsimon
Wed Jul 01, 2020 8:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 20
Views: 2793

Re: Automating TM1 in VBA

Hi Wim Looking at my code the key thing is that for the VBS to work you need to have the following folder C:\Windows\SysWOW64\config\systemprofile\desktop Below is some DOS Batch that creates this if it doesn't exist. We found that it worked better to get the TI to run a DOS Batch (.BAT) file which ...
by paulsimon
Tue Jun 30, 2020 10:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 20
Views: 2793

Re: Automating TM1 in VBA

Hi Wim I will have a look tomorrow. We have the following working as part of our system a) TI Process uses ExecuteCommand to run a DOS Batch b) The DOS Batch runs a VB Script c) The VB Script opens an Excel .xlsm and runs a macro, passing parameters In our case, the macro only merges a CSV file outp...
by paulsimon
Tue Jun 30, 2020 10:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Experience with PAW and its future prospects
Replies: 12
Views: 496

Re: Experience with PAW and its future prospects

Hi I would agree with the comment about the usefulness of Named Hierarchies. However, I use PAX for that rather than PAW because I find it easier to use, apart from the issue of half the buttons not showing in the Set Editor, which is still an issue in 2.0.9. Some people have this issue and some don...
by paulsimon
Thu Jun 18, 2020 8:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Millennium Bug
Replies: 8
Views: 211

Re: Millennium Bug

Hi Jim That was just an example - the important thing is the conversion factor. Date serial numbers in Excel start at 1900, and in TM1 they start at 1960. That conversion factor of - 21916 is the number of days different between 1st Jan 1900 and 1st Jan 1960. I suspect that you might be hitting a pr...
by paulsimon
Thu Jun 18, 2020 8:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Millennium Bug
Replies: 8
Views: 211

Re: Millennium Bug

Hi Jim I am not sure that I understand the point you are making and I haven't read your rules but I am wondering if the issue is because of an anomaly between Excel's base date and TM1's base date for date values? # Adjust using Max and Min so we can rely on what goes into Date 1 YYYY-MM-DD being th...
by paulsimon
Sun May 31, 2020 11:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Process Self Triggering
Replies: 10
Views: 446

Re: TM1 Process Self Triggering

Hi Just as a gut feel, a process that runs for 9 hours seems excessive. Are the processes perhaps reading from a SQL data source that is delivering data very slowly? I have certainly seen cases where concentrating on the data source has brought more benefits than any tinkering with TM1. Are the SQL ...
by paulsimon
Sat May 23, 2020 2:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Synchronise Action Button parameters with Sheet Selections
Replies: 8
Views: 476

PAW Synchronise Action Button parameters with Sheet Selections

Hi As far as I am aware there is no way to synchronise the parameters to a TI Process on an Action Button with selections made in PAW (short of embedding a Web Sheet which for me anyone defeats the purpose of PAW). For us this is absolutely critical. Without this, we will not be able to do most of t...
by paulsimon
Fri May 22, 2020 10:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User driven security
Replies: 10
Views: 773

Re: User driven security

Hi Yes a SecurityRefresh is only needed if you have rule driven security in }ElementSecurity cubes or }CubeSecurity. If you use TI there is no need for a SecurityRefresh. Yes Rules in }CellSecurity do not need a SecurityRefresh. Changes take effect immediately. However, in my experience, }CellSecuri...
by paulsimon
Thu May 21, 2020 10:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User driven security
Replies: 10
Views: 773

Re: User driven security

By the way, the way to avoid the need for a SecurityRefresh is to use ElementSecurityPut. I typically do a CellPutS to the relevant }security cube which keeps the display up to date followed by an ElementSecurityPut which actually makes the security take effect. That way you get edit security for an...
by paulsimon
Thu May 21, 2020 9:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User driven security
Replies: 10
Views: 773

Re: User driven security

Hi I agree with what the others have said. A complex approach using Cell Security is not the right way to do. Create a Security Group per User. I have done this in the past. It is relatively easy to create a cascading process so that someone who has access to a higher level in the hierarchy automati...
by paulsimon
Sun May 17, 2020 6:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error : Incorrect syntax Near '|' (inserting Numeric value into sql query )
Replies: 4
Views: 200

Re: Error : Incorrect syntax Near '|' (inserting Numeric value into sql query )

Hi When you converted it to string did you put double quotes around it? You shouldn't do that. You are constructing a SQL statement which has to be string. Therefore the 'value' cannot be numeric as you cannot concatenate a numeric into a string. You need to put SQL= 'INSERT INTO DB_Archive VALUES (...
by paulsimon
Sun May 17, 2020 4:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error : Incorrect syntax Near '|' (inserting Numeric value into sql query )
Replies: 4
Views: 200

Re: Error : Incorrect syntax Near '|' (inserting Numeric value into sql query )

Hi

Assuming Value is of type numeric rather than string then you need to convert it to a string before you can concatenate it with other strings. Use NumberToString( Value )

Regards

Paul Simon
by paulsimon
Wed Apr 08, 2020 10:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: get a list of all groups the user is a member of. On the rules and without feeding.
Replies: 7
Views: 394

Re: get a list of all groups the user is a member of. On the rules and without feeding.

Hi Wim MDX is good for processes but Drg was asking about rules, and, unless I have missed some major IBM improvement, which is quite possible, as far as I know you can't use MDX in rules. For my particular case, I needed to get not just the group membership, but the cost centres to which each group...
by paulsimon
Wed Apr 08, 2020 10:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through custom views/subsets
Replies: 7
Views: 413

Re: Drill Through custom views/subsets

Hi We are still on 2.0.5 so I would be interested to know if this technique no longer still works in 2.0.8 In the EPILOG put IF( 1 = 0 ) around the generated statements so they don't get executed, then put your custom RETURNVIEWHANDLE below. IF( 1 = 0 ) ; #****Begin: Generated Statements*** RETURNVI...
by paulsimon
Wed Apr 08, 2020 10:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: get a list of all groups the user is a member of. On the rules and without feeding.
Replies: 7
Views: 394

Re: get a list of all groups the user is a member of. On the rules and without feeding.

Hi Drg I had a similar issue. A client could be a member of multiple groups. Each group potentially gave them access to a broad range of Cost Centres. When running a process I needed a quick way to check whether the user had access to a particular Cost Centre. A loop within a loop to find all Groups...
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: 449

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: 733

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: 662

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: 662

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: 334

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...