TM1 Forum

Thanks Alan, I see what I was doing wrong. I thought that I would have to specify the cube that I was pulling the data from, but turns out that I don't. Once I dropped the cube "All GL" from the first argument the function works like a charm. Appreciate the help :) FYI, my now working code...

I'm not trying to create a public subset, I want to embed a macro in the report that will create private subsets on the user's PC.

Hi All, I'm building some reporting in excel using perspectives which requires custom subsets so that I can consolidate data in ways outside of the official hierarchies. I don't have write access to the server so I can't create any public subsets. My workaround has been to create some private subset...