TM1 Forum

Thank you lotsaram , gtonkin and andreykadysh , your explanations helped me make sens of this problem. Thanks to you lotsaram and gtonkin I was able to understand this MDX syntax which was totally new to me and never knew we could do somthing like this IN MDX, I am glad I asked and Glad I found help...

As an alternative to StrToMember you can also do something like {Filter( {TM1FilterByLevel( {TM1SubsetAll([Week].[Week])}, 0 )}, [Week].[Week].CurrentMember.Name = [Settings].([SysParams].[SysParams].[Current Week],[Settings Measure].[Settings Measure].[String Value]) )} Thank you for your help ! A...

I am assuming you have the current week in a subset or control cube somewhere. If you have it in a subset, you could try the following: {TM1Member( [Period].[Period].[Current Month].Item(0),0 ), TM1SubsetToSet([Period].[Period],"All N")} That should give you the current week as the first ...

Hello TMOners,

I have a Cube view where there is a Week dimension, I want to create a MDX formulat to automaticly update the View Week dimension to contain the current week.

Is there a way to do it without having to create a TI process?

Thank you in advance