updating subset in TM1
-
pooja_11284
- Posts: 14
- Joined: Wed Jul 01, 2015 1:10 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
updating subset in TM1
I want to fetch subset(all zero level elements) from a dimension into an excel sheet, which is connected to TM1. It is not an active form. I am populating a list(dropdown) using data validation in excel, the list contains elements from the dimension copied statically, but I want the list to get updated dynamically in case there are any future updations. Any ideas? Cn i use mdx in an excel sheet which is not an active form?
-
tomok
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: updating subset in TM1
Easy. Read the documentation around the SUBNM formula.