mdx filter, horrible performance

• tomasborg

  Valued Member

  Points: 52

  More actions

  February 9, 2009 at 5:04 am

  #200036

  Hi

  I have a SSAS2005 calculated member defined like this:

  ----------------------------

  count (

  FILTER(

  [Customer].[Customer_id].members

  , [Measures].[Value A] > 0 and [Measures].[Value B] > 0) )

  -----------------------------

  It gives me the number of unique customers who has both a Value A and a Value B depending on what I look at for the moment.

  Quite simple. It gives me the right results but it take several minutes to get the result.

  I have defined partitions and aggregations.

  What can I do to improve the performance of this measure?

  regards

  Tomas

• purbasa.jana

  Newbie

  Points: 3

  More actions

  February 13, 2009 at 12:16 am

  #943365

  When I am trying to execute the code

  SELECT COUNT(FILTER(condition)) FROM tablename;

  I am geting the following error--

  'FILTER' is not a recognized built-in function name.