TI process to add new element to dimension

[JFerguson]

I am new to TI so thank you in advance for your help...

We predominantly use TM1 Web for our international users. I would like the users to be able to add a new element to a dimension by clicking an action button in a websheet, after they have inserted into a cell the element name. I have read the TI Guide, but can't see any reference to the data source being a websheet/application.

Does anyone know if this can be done & if so how?

Also, how do I use TI to set the security for the new element?

We are running 9.1.3 U2 on x64 windows server.

[Wim Gielis]

Hi there

Welcome on-Board!

Create a new process, and set the Data source to None.

In the Advanced tab, setup a new parameter to "ask" for a String input. That should become the name of the element. Call the parameter pElement.

In the Prolog tab:

This inserts the element as an N-level one:

Code: Select all

DIMENSIONELEMENTINSERT('DimensionName','',pElement,'N')

This is the most basic you can go - but you do need it in one form or another

Optionally, add the element to an existing consolidation:

Code: Select all

DIMENSIONELEMENTCOMPONENTADD('DimensionName',pConsolidatedElement,pElement,1)

Then, on the websheet change the Action button properties (rightclick it) to fill in the parameter pElement with a cell reference.

For the security on that element, based on the info you give, I would use rules in the respective }ElementSecurity cube. But it might not be needed depending on the actual case at hand.

Wim

[JFerguson]

Thank you very much.