TM1 Forum

Lotsaram is right. We have 14 production servers and I am usually connected to 3 at any time. Having our Excel worksheets changing the server dynamically, based on the first connected server, would be chaos. That said, if your users are disciplined enough to disconnect and connect to just one server...

Abinaya, If you want to list all those "n" level elements in your worksheet, I can think of two methods: Active Form The active form uses TM1 worksheet functions so, technically, this fits. If you need to retrieve values from a cube with those "n" level elements than you couldn't...

This comes from an issue where Excel does not go through the startup procedures properly (always through automation). The addin will be shown as installed but really has not been opened at all. Setting the Installed property to True, when already True, will be ignored. You have to kick it into openi...

Robin, Probably has to do with the two TM1-MDX functions being evaluated instead of one MS-MDX function. I would think toe-to-toe the TM1 MDXs would out perform the MS-MDXs but I have never tested that out. As far as the levels parameter goes, when I first started using this function I would put 99 ...

Bogdan, I hope I am reading this correctly but I believe you are trying to filter on a cube that has 3 dimensions ("Model", "OPEX cost centers", "!y22" variable?) and return the corresponding "Model" members. If this is true, you don't need to specify any dime...

David, You could also venture a little outside of the TM1 box on this one. FILTER(DESCENDANTS([Product].[0400], 25, LEAVES), INSTR([Product].CurrentMember.Name, "01-R")>0 OR INSTR([Product].CurrentMember.Name, "02-R")>0 OR INSTR([Product].CurrentMember.Name, "03-R")>0 )...