Page 1 of 1
TM1SecurityRightRead
Posted: Wed Nov 27, 2013 3:39 pm
by dmillerksu
Does anyone have any information regarding this TM1 formula in Excel? I'm using TM1 10.1. I just noticed this formula in Excel while working on a websheet. I feel that it's functionality would be pretty useful, but I cannot find any context regarding this formula anywhere on the web. According to the function command, there are no parameters for this formula.
Re: TM1SecurityRightRead
Posted: Wed Nov 27, 2013 6:18 pm
by jim wood
Moved to the TM1 forum from the general forum.
Re: TM1SecurityRightRead
Posted: Wed Nov 27, 2013 10:25 pm
by Alan Kirk
dmillerksu wrote:Does anyone have any information regarding this TM1 formula in Excel? I'm using TM1 10.1. I just noticed this formula in Excel while working on a websheet. I feel that it's functionality would be pretty useful, but I cannot find any context regarding this formula anywhere on the web. According to the function command, there are no parameters for this formula.
Speaking of context, the exact context in which you notice something would be useful when asking a question like this. (Item 2 of the
Request For Assistance Guidelines.)
It's in fact a function that is used with classic API calls, not an Excel function. You will however find it as an external function declaration in the tm1p.xla add-in (if you're looking through the Object Browser... again, the reason that context is important) simply because that add-in itself makes calls to the API. That doesn't make it an Excel function, however.
It takes no arguments because it returns what is, for want of a better term, an enumeration value. Specifically, the TM1ObjectSecurityRightGet API function will return a numeric value indicating an object's security status. That value can be compared to the values returned by a number of functions including TM1SecurityRightRead(), TM1SecurityRightWrite(), TM1SecurityRightNone(), etc to determine what the level of security for the object is.
To be able to do that comparison, however, you need to get a handle to the object concerned by using the appropriate blocks of API code, code which will be neither brief nor simple. Consequently trying to use it as an Excel function isn't going to get you very far.