TM1 - From Dropdown - Data Validation

[Paul-TM1]

Hi,
We are using PA 2.0.9 and trying to get some assistance in building a dynamic drop down.

What I am trying to accomplish:
1. Bring in selected LaborCategories in a "drop down" for a selected Account and Employee.
2. I have a cube that has for a selected Account, employee, there will be available LaborCategories.
3. I have a created a planning input sheet that the user log in to to do planning with the Account and Employee selected.

I have read Chapter 14 for Subset Editing but have not understood. Can someone please help me? Is the documentation somewhere else?

Thanks,
Paul.

[Steve Rowe]

Hi Paul,

Not sure where you are stuck but picklists is the functionality you need.

Cheers

[Emixam]

Hi,

Search for "Picklist TM1" in Google. Here's some good resources:

ExploringTM1

Quebit

Revelwood

IBM

and there is a lot of thread on that forum.

Enjoy !!

[Elessar]

Hi,
If I understand you right, you need a dynamic/cascading picklist.

They are well discussed and described here:
viewtopic.php?t=10469
https://everanalytics.wordpress.com/201 ... ognos-tm1/
viewtopic.php?t=6078