locked
Is posible to set a default value on a MDX Filter? RRS feed

  • Question

  • Hello,

    I have a Filter "Start Month" that is composed by a set = Last24Months. If I select the MDX Filter in order to create the filter StartDate the filter select as default the first Month of the set [Last24Months] but i need the default member of the filter to be set as [FirtMonthOfTheYear] (another set).

    I make a nasty solution for this {[FirtMonthOfTheYear],EXCEPT([FirtMonthOfTheYear],[Last24Months])}, this solution shows the months not ordered,.... and i don´t want it

    It is posible make a better solution?

    Thanks
    Tuesday, January 20, 2009 1:33 PM

Answers

  • Hi,

       As far as i know you cannot define a default Member in the MDX filter. You can specify it in the cube.


    Regards,
    Ram
    • Marked as answer by Carmine001 Wednesday, January 21, 2009 9:58 AM
    Wednesday, January 21, 2009 4:48 AM

All replies

  • Hi,

       As far as i know you cannot define a default Member in the MDX filter. You can specify it in the cube.


    Regards,
    Ram
    • Marked as answer by Carmine001 Wednesday, January 21, 2009 9:58 AM
    Wednesday, January 21, 2009 4:48 AM
  • Hi

    what you want to set default,

    That depends Like if you want a default measure/dimension.

    You may set default time as current year/month,similarly  you can do that in dimensions But only inside the cube.

    here is the script to do that iff you want to calculate current month to last 12 months 

    use this script  to get that(nonempty(Tail(Time.Month.Month.MEMBERS,1)).item(0) current month using mdx)

    {nonempty(Tail(Time.Month.Month.MEMBERS,1)).item(0):
    nonempty(Tail(Time.Month.Month.MEMBERS,1)).item(0).lag(11)}


    D
    Friday, January 23, 2009 1:32 AM
  • Lets say a MDX query like  

    NonEmpty([Date].[Calendar Month].Members)
    returns a filter as below and by default it selects all.

    MDX Filter

    Is it possible to select last six months viz, May 2012 to October 2012 as default values?

    Thanks,

    Merin


    Merin


    Wednesday, November 20, 2013 9:49 PM
  • That option in Dashboard Designer is not available with the MDX Query, works with the Member Selection though.

    Dan English's BI Blog

    Friday, January 31, 2014 1:44 AM