TM1 Forum

Yes, that's much neater - thankyou again !

Just for the sake of completeness, here is how I've solved the issue - thanks to all who responded, I wouldn't have got there without you! My Period dimension has an attribute 'Movex_serial' which is just that - the serial number assigned to a date in Movex. I just used this to get the n level eleme...

Thanks for that. This looks like a workable alternative and closer to the way I was thinking about it. I won't get chance to do it today but thankyou for all your help.

Rozef, I think your solution wouldn't be viable for 365 days. rmackenzie, no ! the index for 1 july is 2685 and 2020LTD is 6254 ..... curiouser and curiouser! This makes me think that my original idea of trying to combine the Lastperiods function with the sortbyindex at level 0 would be a logical wa...

It seems the problem only occurs with July dates (accounts for why I missed it when I was testing). I have YYYMMDD as an alias. Following is the result for { LastPeriods(10, [period].[05/07/2011]) } 2016LTD 2017LTD 2018LTD 2019LTD 2020LTD 20110701 20110702 20110703 20110704 20110705 All this is lead...

ok, I couldn't get { FILTER( { LastPeriods(10, [period].[18/07/2011]) }, [period].CurrentMember.Level.Ordinal = 0)} to work. UNION and INTERSECTION can't work since the LastPeriods function returns not only n level dates but consolidations such as YTD and I only want the n level. I'm wary of resturc...

I'm sure this is quite easy but it's driving me crazy. I have a period dimension (all dates and all the usual hierarchies). I want to create a dynamic subset based on the user inputting a date range. I have used the 'LastPeriods' function to take the end date entered by the user and count back the r...

I think I've got that covered.
The users are accustomed to recalculating worksheets by pressing a 'Calculate' button on the report. The code to call the TI and build the subset is in this macro.

Thanks for that - it's exactly what I needed to know! After creating the consolidation the next, and final line, in the VBA is simply a TM1REFRESH so I don't think the issue would arise. I did consider using the usernames but this wasn't workable due to another process that runs over the dimension. ...

My first post - please be gentle! I have a TI process called from VBA in an Excel Report. The user specifies a date range, say 1 May to 15 May the process creates a subset by MDX containing all the individual dates, these elements are then assigned to the consolidation 'Date_Range' so the report can...