slow MDX Query

• erics44

  SSCertifiable

  Points: 6150

  More actions

  May 6, 2015 at 1:08 am

  #297948

  Hi

  I am new to MDX and i am a bit stuck on a query that is taking too long

  it works it just takes ages.

  I have no access to the cube development so i am just hoping for some pointers on bettering my MDX or tricks that might speed it up.

  any replies would be greatly appreciated.

  heres the query.

  with

  member measures.MA as iif(isempty([Projects].[Age]), "n/a", [Projects].[Age])

  member measures.MB as iif(isempty([Projects].[Benefit]), "n/a", [Projects].[Benefit])

  member measures.MC as iif(isempty([Projects].[Classification]), "n/a", [Projects].[Classification])

  SELECT {measures.MA

  , measures.MB

  , measures.MC

  , [Measures].[Forecast]

  ,[Measures].[Actual]

  ,[Measures].[Year To date]

  ,[Measures].[Previous Year]

  } ON COLUMNS

  , ([Projects].[ParentProject].members, [Projects].[ChildProject].members) on rows

  FROM [ReportingCube]

  WHERE

  (

  StrToMember(@Month),

  ,

  StrToMember(@Project)

  );

  thanks in advance