Hello,
I have a dimension for "Departments" and another dimension for "Expenses Accounts", I manage the sparsity in a separate cube and use MDX subset as not all departments have all expenses accounts.
In PAX, I want to create two dependant dropdown lists, one for the departments, second for the Expenses accounts that depend on the first one, That is, When a user select a department from the first list, The second list will have only the Expenses accounts associated with this department.
Is that even doable?
Thanks,
Yasser
PAX dependent drop down lists
- PavoGa
- Community Contributor
- Posts: 178
- Joined: Thu Apr 18, 2013 6:59 pm
- OLAP Product: TM1
- Version: 10.2.2 fixpack 7
- Excel Version: 2013
- Location: Cleveland, Tennessee
Re: PAX dependent drop down lists
Yes. You will need a mapping cube with the relationships between the departments and accounts, and an MDX subset on the Expense Accounts that uses the entry from the first (department) dropdown.
You can get REALLY fancy and have the Expense Accounts subset even have previously selected accounts dropped from the list if that is a requirement.
You can get REALLY fancy and have the Expense Accounts subset even have previously selected accounts dropped from the list if that is a requirement.
Ty
Cleveland, TN
Cleveland, TN
- Elessar
- Posts: 120
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: PAX dependent drop down lists
Hello,
In PAX, you can use the new "TM1ELLIST" function with your MDX in it:
https://www.ibm.com/support/knowledgece ... llist.html
In PAX, you can use the new "TM1ELLIST" function with your MDX in it:
https://www.ibm.com/support/knowledgece ... llist.html
Sorry for my English ;)