TM1 - From Dropdown - Data Validation

Post Reply
Paul-TM1
Posts: 81
Joined: Tue Jun 13, 2017 3:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

TM1 - From Dropdown - Data Validation

Post by Paul-TM1 » Wed Sep 09, 2020 11:06 pm

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.

User avatar
Steve Rowe
Site Admin
Posts: 2083
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: TM1 - From Dropdown - Data Validation

Post by Steve Rowe » Thu Sep 10, 2020 12:50 pm

Hi Paul,

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

Cheers

Emixam
Posts: 76
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

Re: TM1 - From Dropdown - Data Validation

Post by Emixam » Thu Sep 10, 2020 12:58 pm

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 !!
Sorry for my English :)

User avatar
Elessar
Community Contributor
Posts: 207
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Location: Russia

Re: TM1 - From Dropdown - Data Validation

Post by Elessar » Thu Sep 10, 2020 1:26 pm

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
Best regards, Alexander Dvoynev

Post Reply