TM1 Forum

Hi All,

I have a pax sheet where user enter some info and submits and tm1 ti does some process on top of it .

Is there a way to get the user information who logged in to enter some info or to get his email id ,

I can add the email id if there is any specific cubes for that.

I need to know how to get the user id and email associated with it .

Any suggestions on the process is appreciated.

Thanks,

You can use TM1User function in worksheet and TI process to get TM1 login username. You can save email addresses as attribute of }Clients cube and retrieve the email address when you know the TM1User.

I am not able to edit client properties dimension to add a new attribute like Email ID

Cant we edit client properties to have a new element .

Thanks,

When you right-click the }Clients dimension, you're not able to add an attribute to the }Clients dim by clicking "Edit Element Attributes"? I wouldn't mess with the }Client Properties dimension. If you don't want to use an attribute of }Clients dimension, you could create a whole new cube with two dimensions: }Clients and a new measure dim of your creation to house the element for user email address.

manu0521 wrote: ↑Tue Apr 14, 2020 3:02 pm I am not able to edit client properties dimension to add a new attribute like Email ID

Cant we edit client properties to have a new element .

Thanks,

Well you can. It is just a restriction that the Architect UI places of being unable to directly edit any dimension starting with "}" as these are control or system dimensions that developers generally shouldn't be editing. You could however, use a TI process to insert an element into }ClientProperties, whether you should do this is of course another question.

There would be nothing wrong or unsafe about adding an additional "Email" text attribute to the }Clients dimension. The UI will let you do this and it is safe to do so. Many administrators add additional atributes to the }Clients dimension. You can of course always use an additional cube instead.

I did add an additional attribute to clients as email id and it worked .

Thanks,