Adding Attributes to an Excel Input Sheet

[youngjedi]

I have a TM1 input sheet in Excel and I would like to add a new element along with 2 attributes for the newly added element. So essentially, I would like to prompt the user for 3 pieces of information

1. Company Name
2. Date
3. Individual's Name

The company name is an element and the date and individual's name are attributes of the company. How do I collect this in Excel and have this populate back to TM1???

Thanks in advance.

[declanr]

Have you read the user guides?
If you want to create an element from a workbook you will need to have an action button that runs a TI looking at parameters in the book.

DimensionElementInsert()
DimensionElementComponentAdd() (Maybe... you haven't explained your task fully)
AttrPutS()


If you have a more specific problem with the task then please elaborate.

[Duncan P]

Don't forget that the DimensionElementInsert needs to be in the Prolog and the AttrPutS needs to be in the Epilog.

[youngjedi]

Ok I'm going to give that a try using TI. I'm still not sure how the user will be prompted to enter the three bits of information. All I need the user to return to TM1 is

Company (Element)
Date (attr of Company)
Individual/Name (attr of Company)

[declanr]

When you add a TI into excel via an action button you (normally) link the parameters to cells within the excel sheet.
Update the contents of these cells in excel and then run the action button.