Narrative Reporting

Enterprise Performance Management

Topic

    Amit Agarwal
    Inserting Last day of month in report
    Topic posted October 11, 2019 by Amit AgarwalBlue Ribbon: 750+ Points, tagged Commenting, Management Reporting, Narrative Reporting, Report Packages, Reports 
    47 Views, 3 Comments
    Title:
    Inserting Last day of month in report
    Summary:
    Inserting Last day of month in report
    Content:

    Hi Champions,

    I have a specific requirement. I have designed reports in Web Reporting Studio and at the top of the report I want to insert the date as last day of the month whenever the report is run. For example - for October report whenever its run irrespective whenever I run the report, I want the date to be as 31st October, 2019.

    What Function do I use for this purpose?

    Thanks for your help in advance,

    Amit

    Comment

     

    • Dave Roberts

      Hi Amit,

      There isn't a text function in FR to return the last day's date, the Date function just returns the date the report was last run.  The only workaround I can think of is to manually populate a date measure in your data source with the end of month date every month, retrieve it using a hidden grid in FR, then display the value using the GetCell function.  I haven't personally tested this, but it should work.

      Regards,

      Dave

    • Amit Agarwal

      Hey Thanks Dave. I will give it a try and let you know how it went. 

      Cheers!!

      Amit

    • Cassandra Marcus

      What about adding a Month End Date as a UDA / Member Property or putting it in the Member Description in the time-based dimension in the report?  It prevents the need to update multiple reports, multiple times a year with the exception of a leap year.