CODEWITHSUNDEEP
sql-serverreporting-servicesssasmdx
Frank Goortani
Frank Goortani

Reputation: 1435

Slow Running MDX Query - running total

We're trying to create a calculated measure to do a running total of another Measure. Considering the amount of data is not huge, how can we make this query faster? 

 WITH MEMBER [Measures].[X] AS aggregate 
 (
  {Null:[Transaction Date].CurrentMember},
  [Measures].[Transaction Amount]
 )
SELECT
 non empty {
  [Measures].[X]
 } ON columns
 , 
 non empty {
  ([Claim].[Claim Number].children* 
  [Transaction Date].[Hierarchy].[Day].&[2013-02-28T00:00:00]
  )
 } 
 ON rows
 FROM [ClaimsCube]

Upvotes: 1

Views: 544

Answers (1)

Andy Cheng
Andy Cheng

Reputation: 1167

Try to remove "non empty"

WITH MEMBER [Measures].[X] AS aggregate 

(
  {Null:[Transaction Date].CurrentMember},
  [Measures].[Transaction Amount]
 )
SELECT
 {
  [Measures].[X]
 } ON columns
 , 
 {
  ([Claim].[Claim Number].children* 
  [Transaction Date].[Hierarchy].[Day].&[2013-02-28T00:00:00])
 } 
 ON rows
 FROM [ClaimsCube]

Upvotes: 1

Related Questions