TM1 Forum

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi

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

vRet = ExecuteProcess(...)

IF( vRet <> ProcessExitNormal() ) ;
.... Some error handling
ENDIF ;

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

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

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

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

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