Selection of multiple elements

[bergstrand]

I would like to create an Excel-template where the user can select one or more elements in a dimension. These elements are then passed to a TI-process triggered by an action button (the process is used for exporting the selected data to a text file). The tricky part is when the user want to select multiple elements. Since there is no way of doing this with the SUBNM command, I am thinking of other possible ways to solve this. My question is basically: is there any good way of acheiving selection of multiple elements in Perspectives, using built in TM1 functionality, or do I have to invent the wheel myself with Excel and TI-scripting? Have someone built this kind of thing before?

[lotsaram]

No you have to build it, a SUBNM can only display a single selected element, that's essentially the purpose of the function.

Yes this has been done before. Easiest way to do this is to have a column of your report sheet with a DBRA that is filled via in cell validation dropdown.
The action button creates a dynamic subset based on the "selected" members then exports the extract then clears out the attribute values (you have to do this or the export selections will become additive.) Hey presto, done.

Another way would be to create a UDC rollup in subset editor and select the UDC, then pass the UDC as a parameter value to the TI through an action button and loop through the children of the UDC. Due to various issues with user defined consolidations my preference would be to go with the first option.

[bergstrand]

Thank you very much for the suggestions! I solved it using the DBRA-method.

[Lukas Meyer]

To answer your basic quesion - if you don't mind not using TM1Web (which can be good, since you wouldn't have to play around with stupid formats not being 1:1 from excel), you can use an Excel macro. SUBPICK would be your function

When using the DBRA approach, you have to be careful not to have two users using that application at once. They really don't like messed up exports and they will call you and annoy you with all their little problems...

[karuna]

Hi All,

I am quite new to this TM1 forum - just wanted to understand how we can call DBRA functions attributes into TI Process to load the with SubsetCreatebyMDX('Base Products','{TM1FILTERBYLEVEL({TM1SUBSETALL( [Product] )}, 0)}');
Because as per my understanding the filter criteria will not be able to accept multiple selections eg MONTH - JAN ,FEB MARCH (how it will show data of these three elements by using bsetCreatebyMDX on basis of Action Button function )