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
Quote from: James1366 on 30 Sep 2014 08:42:42 AM
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.
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
Quote from: James1366 on 01 Oct 2014 05:35:51 AM
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.
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!
Morning
Did the information provided enable anyone to support this problem? If not, many thanks for the efforts, they are appreciated
Thanks
Quote from: James1366 on 01 Oct 2014 12:18:26 PM
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.
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
Quote from: James1366 on 09 Oct 2014 07:19:55 AM
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.
Indeed, completed and running
Thanks for the support 8)