TM1 Forum

Hi guys

i have an active form that a user(call her user 1) works on to update contact information of clients. once this is updated she allocated to a salesman.

each salesman will then be able to log on and see the clients allocated to them and contact them, and if need be, update contact information too.

i have done this in one cube with various dimentions, including one called salesman (in order for each salesman to only view their info). the default element in the salesman dimention is 'unallocated salesman'.

what i would like is for user 1 to change the unallocated salesman to the salesman's name and the data then moves to that users name. is this possible to do in an active form? i cant seem to figure out how to change the dimension in an active form.

thanks.

The quick answer to your question is no, you can't natively change a dimension inside an active form. The best you can do would be to create a TI process that accepts parameters and then you could call that TI on your active form, passing the appropriate parameters, through an action button. The bigger question is why in the world are you trying to create a customer information management system in an OLAP tool like TM1? You're just going to be extremely disappointed in the results.