Creating Employee Position Picklist

Post Reply
cardantim
Posts: 21
Joined: Wed May 25, 2011 1:49 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Creating Employee Position Picklist

Post by cardantim »

Hello,

I'm building a cube for employee headcount and a measure within an EmployeeMeasures dimension will be Position. We have about 50 different positions so rather than have people free form into the cell (and have incorrect entries) I want to have a pick list for my users. With so many different options I'd like not to use the Static: picklist. Can I create a Position dimension and refernece that in my EmployeeMeasure dimension?

Thanks
User avatar
Martin Ryan
Site Admin
Posts: 1989
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Creating Employee Position Picklist

Post by Martin Ryan »

Yes. Search for picklist in the help files and you'll see how to set it up (including the syntax for the PickList attribute) in there.

Cheers,
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
User avatar
jim wood
Site Admin
Posts: 3958
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Creating Employee Position Picklist

Post by jim wood »

If you do a search the topic has also been discussed on here several times. It's very useful stuff as it has helped me in the past.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply