TM1 Forum

Guys,

Currently I am building a model that uses control cubes, rules and security to operate a work flow mechanism. While this works well there is an issue with the amount of time it takes for security to refresh. I was wondering if anybody else had encountered this problem and how you got around it.

Bare in mind that this is a real time model so I'm pretty restricted when it comes to TI usage.

Cheers,

Jim.

I've been having a look and it's looks to me like data reservation via TI is a viable option. Do you guys agree? Any other suggestions?

Jim.

The time it takes to do a SecurityRefresh is directly related to the number of groups you have and the size of the dimensions being secured. There is nothing that I know of that you can do to make that function run faster. It is what it is based on your security setup.

I have done quite a few models using workflow (and I mean my own home-grown version, not TM1 Workflow). In some of my earlier models I attempted rule-based workflow and really was never able to get it to perform like I wanted because of the exact same thing, securtity issues and feeder issues. Ever since then I have used TI based workflow. I've never had an issue with performance as long as the users are not copying huge amounts of data up the workflow tree at the same time.

jim wood wrote:I've been having a look and it's looks to me like data reservation via TI is a viable option. Do you guys agree? Any other suggestions?

Jim.

I haven't looked into data reservation with 9.5.2 yet but in general the time a TI (or several TIs) take to run to rebuild element security for a specific group is generally much less than a page refresh time in TM1 web. In other words users won't notice, in my experience it leads to better performance and a more "real time" model than using security rules and having to do lots of security refreshes.

tomok wrote:The time it takes to do a SecurityRefresh is directly related to the number of groups you have and the size of the dimensions being secured. There is nothing that I know of that you can do to make that function run faster. It is what it is based on your security setup.

I have done quite a few models using workflow (and I mean my own home-grown version, not TM1 Workflow). In some of my earlier models I attempted rule-based workflow and really was never able to get it to perform like I wanted because of the exact same thing, securtity issues and feeder issues. Ever since then I have used TI based workflow. I've never had an issue with performance as long as the users are not copying huge amounts of data up the workflow tree at the same time.

We currently have around 7k security groups for a dimension of around 2.6k elements. The reason I went down the rules route was that we have a custom web interface for the workflow accessing the API via .net,

Jim.

I am currently using Control Cubes, TI & Security to create & manage custom workflow in TM1 9.5.1. I haven't used Data Reservations & would love to know more details about it. Started reading the TM1 9.5.2 Developers guide "Using Data Reservations". I think TI is the way to go for implementing workflow. Tried Rule based, but not completely satisfied with the results.

Hi

A way to get a security refresh from a single dimension is to use a process that reads from the }ElementSecurity Cube for the dimension and on the Data Tab use

IF(Value @= '' ) ;
Value = 'NONE' ;
ENDIF ;

ElementSecurityPut(Value,vDim,vElem,vGrp) ;

This is usually a lot faster than a full SecurityRefresh

Regards

Paul Simon