Page 1 of 1

TM1 - From Dropdown - Data Validation

Posted: Wed Sep 09, 2020 11:06 pm
by 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.

Re: TM1 - From Dropdown - Data Validation

Posted: Thu Sep 10, 2020 12:50 pm
by Steve Rowe
Hi Paul,

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

Cheers

Re: TM1 - From Dropdown - Data Validation

Posted: Thu Sep 10, 2020 12:58 pm
by 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 !!

Re: TM1 - From Dropdown - Data Validation

Posted: Thu Sep 10, 2020 1:26 pm
by 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