updating subset in TM1
Posted: Wed Nov 02, 2016 8:07 pm
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?