Process with Parameter

[appleglaze28]

I was trying to do create a sheet that allow admin(in case Perspective or Architecture is not available specifically access it through TM1, or if someone given security is too lazy to go to the server and do multiple steps to create the user and the group that user belongs to) to add users. I was expecting if I added a TM1 Action Button, the parameter will pop up when you run it, however that is not the case. I was thinking of how create a worksheet or something to be able to allow TM1 to process to work. I'm trying this on TM1 9.5

[lotsaram]

If a TI has parameters and you want to call it from an action button then the easiest way to do this is to enter the parameter values in worksheet cells and name range the cells, this makes them easier to refer to in the action button parameter arguments. Hopefully a picture is worth 1000 words.

Temp.JPG (38.84 KiB) Viewed 6861 times

[appleglaze28]

Can you really add a password cause I tried doing so, and when I tried logging in using the Password I created with the process its not working, it tells me when its incorrect.

When I checked the {ClientProperties, I know I typed in the right password, only difference with the users and passwords I created prior to trying to do this through TI, they are encrypted.

[Steve Vincent]

I have a spreadsheet that does exactly this. The password you send to TM1 must be the encrypted version, not plain text. So if you want to always use "TEMPPASSWORD" for new users or resets, you need to set that manually in TM1, copy the encrypted version from the }ClientProperties cube, then use that in Excel. What you cannot do is type a plain text value in to Excel as a password and expect that to work in TM1 - Excel would have to know the encryption algorithm to do that and for obvious reasons IBM aren’t going to tell you

[lotsaram]

Can you really add a password cause I tried doing so, and when I tried logging in using the Password I created with the process its not working, it tells me when its incorrect.

When I checked the {ClientProperties, I know I typed in the right password, only difference with the users and passwords I created prior to trying to do this through TI, they are encrypted.

In TI don't just write to the }ClientProperties cube you need to use the appropriate security function:
AssignClientPassword(ClientName, Password);

If AssignClientPassword is used then the password value can be (in fact should be) a plain text value!

[Alan Kirk]

I have a spreadsheet that does exactly this. The password you send to TM1 must be the encrypted version, not plain text. So if you want to always use "TEMPPASSWORD" for new users or resets, you need to set that manually in TM1, copy the encrypted version from the }ClientProperties cube, then use that in Excel. What you cannot do is type a plain text value in to Excel as a password and expect that to work in TM1 - Excel would have to know the encryption algorithm to do that and for obvious reasons IBM aren’t going to tell you

It's true that AssignClientPassword hasn't been supplied as a worksheet or macro function (why am I surprised ), but it is in fact possible to do it via Excel... if you use the API function TM1ClientPasswordAssign. But bein' as how this is the TM1 API, the most unforgiving API in the world and could blow your Excel session cleeean off, you've gotta ask yourself one question. 'Do I feel lucky?'.

[lotsaram]

It's true that AssignClientPassword hasn't been supplied as a worksheet or macro function (why am I surprised ), but it is in fact possible to do it via Excel... if you use the API function TM1ClientPasswordAssign. But bein' as how this is the TM1 API, the most unforgiving API in the world and could blow your Excel session cleeean off, you've gotta ask yourself one question. 'Do I feel lucky?'.

But (assuming 9.1 and above) if you have action buttons then there is no need as TurboIntegrator does support the function which absolves the need for the API (or VBA for that matter.)