Time Intelligence Filter Default Value RRS feed

  • Question

  • Hi cna please someone tell me how to set a default value of a Time Intelligence Filter.


    I have the values for this filter:

    Current Month

    Last Month

    Last 3 Months

    Last  6 Months

    When i open the dashborad i need the Lasty 3 Months option been selected.


    Thanks in advanced.

    Wednesday, December 14, 2011 4:41 PM


  • Couple of ways:

    1. The filter would show the first TI formula as the default. So modify your TI filter and move 'Last 3 Months' on top.


    2. Create a named sets in your Analysis Services for each filter member and then create a filter using that set. In the member selection screen set 'Last 3 Months' as default value.
    Friday, December 16, 2011 3:40 PM