Is posible to set a default value on a MDX Filter?
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 dont want it

It is posible make a better solution?

Thanks
January 20th, 2009 4:33pm

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
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2009 7:48am

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
January 21st, 2009 7:48am

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
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2009 7:48am

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
January 21st, 2009 7:48am

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
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2009 7:48am

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
January 21st, 2009 7:48am

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
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2009 7:48am

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
January 21st, 2009 7:48am

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
Free Windows Admin Tool Kit Click here and download it now
January 21st, 2009 7:48am

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)}

January 23rd, 2009 4:32am

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,

Free Windows Admin Tool Kit Click here and download it now
November 20th, 2013 4:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics