Page 1 of 1
How to create a drop down list in TM1 Perspective?
Posted: Mon Aug 27, 2012 5:06 am
by vibhanshu
I need to create a drop down list through excel so that user can see all the dim elements in that drop down ? if anybody knows please help me out.
Re: How to create a drop down list in TM1 Perspective?
Posted: Mon Aug 27, 2012 7:56 am
by lotsaram
vibhanshu wrote:I need to create a drop down list through excel so that user can see all the dim elements in that drop down ? if anybody knows please help me out.
Is this a serious question?
Re: How to create a drop down list in TM1 Perspective?
Posted: Mon Aug 27, 2012 8:01 am
by tushar.marathe
Can be achieved in 2 Steps:
1. Create the list of dimension elements using formula below, in a far-end column of the current spreadsheet tab or in a separate tab in the current spreadsheet.
Col A - Contains Index
Col B - Contains "DIMNM(<<Dimension>>,<<Col A>>)"
Scroll down these 2 lists to get the list of elements
2. Create a Excel drop down from data-validation option by referring to the list in Step-1.