TM1 Forum

Hi,

We are trying to show the Dimension elements into excel cell drop down list of values.
Is any function that calls the dimension elements into excel.
Please help me on this.

Please Let me know if you need more details.


Regards.
Sathish

SUBNM() will give you an ability to navigate TM1 dimension.

DIMIX() will give you an ability to retrieve TM1 elements from a dimension based on the Index ( Probably want you need in this case)


They are explained in details in Worksheet Function Overview part of TM1 guide


Thanks

Evgeny

Hi,

Thanks for reply.
We tried with Subnm(),Dimix functions,but there are not working the way we are looking for.

Please find the attached screen shot for reference.

Regards,
Sathish

sathishh.mk wrote: Thanks for reply.
We tried with Subnm(),Dimix functions,but there are not working the way we are looking for.

Please find the attached screen shot for reference.

Look in the manuals for the word "Picklists".

hi
You can use SUBNM funtion, before You must connect server TM1.

=SUBNM("Retail:Product","All","1","VN")

http://pic.dhe.ibm.com/infocenter/ctm1/ ... D5_2_6_6_9

After you run it on TM1 application, you can see what you want

binhnguyenthy wrote:hi
You can use SUBNM funtion, before You must connect server TM1.

=SUBNM("Retail:Product","All","1","VN")

http://pic.dhe.ibm.com/infocenter/ctm1/ ... D5_2_6_6_9

After you run it on TM1 application, you can see what you want

I appreciate that as a new member here you're trying to help, but to ensure that we retain high quality answers you do need to read the question carefully and be sure that you're replying to what the question really is.

In this case the question was about creating a drop-down list in a cell in Excel, as the screenshot in the third post.

You've provided a link to a TurboIntegrator function which inserts new elements into a dimension, and a screenshot of what appears to be TM1 Web. The two don't seem to be highly connected to the question asked.

If you set the cells in TM1 to have a pick-list using the dimension the members of which you want to see then it will appear as a normal drop-down in Excel.

For information on how to set up a pick-list there is a section in the documentation here.