Post reply

Generate day of Month automatic in SSRS

  • November 14, 2013 at 2:46 pm

    #280206

    Goal:

    To generate the day of month automatic, without hardcoding, as a parameter value in the red box. For instance if the day 15th, the parameter value, in the red box, shall generate value 15. This is used as a default value.

    Problem:

    I do not know how to do it?

    Information:

    *I really apprreciate for all the previous support and advice!!!*

    *Low maintenance.

    I'm using SQL server 2012 DW

    *Data source is SSAS

  • November 15, 2013 at 2:51 am

    #1666658

    Set the default value of your parameter as an expression like

    =Today()

    with any formatting of the date that you need (I'm thinking that since you are passing this value to SSAS then you'll need to split it up to match your date dimension structure).

    Have a read of this date function examples in this article:

    http://msdn.microsoft.com/en-us/library/ms157328.aspx

    Good luck 🙂

    I'm on LinkedIn

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply