How to create a drop down list in TM1 Perspective?
-
vibhanshu
- Posts: 1
- Joined: Mon Aug 27, 2012 4:07 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2007
How to create a drop down list in TM1 Perspective?
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.
-
lotsaram
- MVP
- Posts: 3702
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: How to create a drop down list in TM1 Perspective?
Is this a serious question?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.
-
tushar.marathe
- Posts: 12
- Joined: Sun Aug 26, 2012 2:29 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007 2010
- Location: London, UK
Re: How to create a drop down list in TM1 Perspective?
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.
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.