TM1 Forum

Hello All,

I have created web-sheet in TM1 which is at granular level for all dimensions and in list format in excel. Now i want to drill through to another web-sheet using action button/Hyperlink which will display detail data for an element in 1st active form.

I am little get stuck here as I am not sure how to pass, an element value from one web-sheet to another web-sheet using action button or Hyperlink. If i use hyper link, then not sure, how to pass parameter in URL of web-sheet which will have element value and then how to read that parameter in another web-sheet.

And if i use action button, then do i need to create one action button for each element of a dimension and if yes, then how to pass element value from one sheet to another.

Any ideas/workarounds?

Thanks,

manoj928 wrote:I am not sure how to pass, an element value from one web-sheet to another web-sheet using action button or Hyperlink.

Check out the information in the manual... which you would be advised to spend a bit more time reading.

Thanks,

I explored manual a bit and realised that, Using Action Bution will be more cumbersome, and hyperlink will work best.So i went little further down and found that using Title_S#_R#_C#_Element, i can achive what i am looking for and we did.

It worked like the way i wanted.

Thanks a lot for guidance.
Manoj