Dynamic Month

[James1366]

Hi
Would anyone be able to share how to convert the following slicer to default from YTD to current month i.e. I would always like the report to open with the current months figures, not the YTD values.

#'prevMember([PL_Reporting].[PL_Time].[PL_Time].[Month]->:[TM].[PL_Time].[PL_Time].[@MEMBER].[YTD ' + timestampMask($current_timestamp,'yyyy') + 'M' + timestampMask($current_timestamp,'mm') + '])'#

Many Thanks

[MFGF]

Hi
Would anyone be able to share how to convert the following slicer to default from YTD to current month i.e. I would always like the report to open with the current months figures, not the YTD values.

#'prevMember([PL_Reporting].[PL_Time].[PL_Time].[Month]->:[TM].[PL_Time].[PL_Time].[@MEMBER].[YTD ' + timestampMask($current_timestamp,'yyyy') + 'M' + timestampMask($current_timestamp,'mm') + '])'#

Many Thanks

We'd need to see what a MUN for a month member in your package looks like to be able to give you an answer :)

MF.

[James1366]

Hi

I believe one of our offshore developers requested a similar fix however this was for YTD not month  :( Thread 'link=topic=25517.msg80709#msg80709 date=1406881340'

Attached MUN dimension - Month

[MFGF]

Hi

I believe one of our offshore developers requested a similar fix however this was for YTD not month  :( Thread 'link=topic=25517.msg80709#msg80709 date=1406881340'

Attached MUN dimension - Month

Hi,

Thanks - that's useful info on the structure of the dimension. What we really need is to see the Member Unique Name (MUN) of one of your Month members, though. Right-click on a Month member in the package (any month will do), choose "Properties", and find the Member Unique Name property - this is what we need to see. It will be in a similar format to [PL_Reporting].[PL_Time].[PL_Time].[Month]->:[TM].[PL_Time].[PL_Time].[@MEMBER].[something here] although that's just a guess :)

Cheers!

MF.

[James1366]

Its a bot to long to show in a screen grab, but here it is

[PL_Reporting].[PL_Time].[PL_Time].[Month]->:[TM].[PL_Time].[PL_Time].[@MEMBER].[2014Q1^2014M01]

Thanks!

[James1366]

Morning
Did the information provided enable anyone to support this problem? If not, many thanks for the efforts, they are appreciated
Thanks

[MFGF]

Its a bot to long to show in a screen grab, but here it is

[PL_Reporting].[PL_Time].[PL_Time].[Month]->:[TM].[PL_Time].[PL_Time].[@MEMBER].[2014Q1^2014M01]

Thanks!

Thanks! I've been away for a few days...

How about:

#'[PL_Reporting].[PL_Time].[PL_Time].[Month]->:[TM].[PL_Time].[PL_Time].[@MEMBER].[' + timestampMask($current_timestamp,'yyyy') + 'Q' + substitute('''','',substitute('''-','',substitute(timestampMask ($current_timestamp,'mm'),'',csv(grep(timestampMask ($current_timestamp,'mm'),array('01-1','02-1','03-1','04-2','05-2','06-2','07-3','08-3','09-3','10-4','11-4','12-4')))))) + '^' + timestampMask($current_timestamp,'yyyy') + 'M' + timestampMask($current_timestamp,'mm') + ']'#

Thanks to Nimrod Avissar for the funky way top get the quarter number! :)

MF.

[James1366]

Thank you very much
:) :) :) :)

I will try now to make the final change of month -1 to allow for my final report, I think I can tweak with a Month -1 amendment. Do you agree

Thanks again

[MFGF]

Thank you very much
:) :) :) :)

I will try now to make the final change of month -1 to allow for my final report, I think I can tweak with a Month -1 amendment. Do you agree

Thanks again

It might be as simple as including this in a prevmember() function?

#'prevmember([PL_Reporting].[PL_Time].[PL_Time].[Month]->:[TM].[PL_Time].[PL_Time].[@MEMBER].[' + timestampMask($current_timestamp,'yyyy') + 'Q' + substitute('''','',substitute('''-','',substitute(timestampMask ($current_timestamp,'mm'),'',csv(grep(timestampMask ($current_timestamp,'mm'),array('01-1','02-1','03-1','04-2','05-2','06-2','07-3','08-3','09-3','10-4','11-4','12-4')))))) + '^' + timestampMask($current_timestamp,'yyyy') + 'M' + timestampMask($current_timestamp,'mm') + '])'#

MF.

[James1366]

Indeed, completed and running
Thanks for the support  8)