TM1 Forum

I want to ADD a Button in worksheets which will add a row of Dimensions in worksheet. And it should be availible in TM1 web too...
I have attached a photo and now i need to add a button which adds a row of dimensions.Is this possible using any Excel script or TM1 ?? Action Button Script inside TI?? I need a approach.. Thank you very much

You can't really do any code within an excel workbook that will be published to the web. The alternatives you have are:

• Restrict your users to excel
• Use Enterprise Services
• Create a web page using the API

If all you are trying to do is have some open areas to put data into, then create the input area with dimension elements that are already created, but empty so that they can be populated as needed. If you need more line items, just add more elements. In other words, if you know you will need 8 line items, create 18 line items in the spreadsheet, and then let the users fill in the remaining 10. If they start to approach 15, or so, add in some more elements and update your spreadsheet to account for the additional line items.

It stinks, but then Excel was not meant to do this. If you must have it published to the web, then you will have to use Enterprise Services, which does this natively, or build your own using the TM1 API.

Good luck!

Thats a Owesome Reply.. Need some more guide lines in this.. If i need to look the possibility in Enterprise Service where do i search/learn or know things for my task?... Can you please let me know the resource/any links for Enterprise service??

Appreciate your time..