Getting Email ID or USer ID

[manu0521]

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,

[ascheevel]

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.

[manu0521]

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,

[ascheevel]

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.

[lotsaram]

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.

[manu0521]

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

Thanks,