Getting LinRegSlope to work

• ktflash

  Default port

  Points: 1400

  More actions

  June 9, 2022 at 5:48 am

  #4046674

  Ahoi,

  i am again struggling to make MDX work and as usual i can not understand why it does not work looking at all the examples that are out there on the internet.

  What i basically need is example of the MS Docs, but i can not get it to work no matter what i try:

  LinRegSlope(LastPeriods(10),[Measures].[Unit Sales],[Measures].[Store Sales])

  LinRegSlope(LastPeriods(24),[Measures].[Measure1],[Measures].[Measure1])

  Below are my attemps at creating the measure in mdx, the only one who does not throw an error in excel is "slope3" but i need a version not for current member but for last 24 months

   

  CREATE MEMBER CURRENTCUBE.[Measures].[slope1]
   AS LinRegSlope(LastPeriods(24),[Measures].[Measure2]), 
  FORMAT_STRING = "#,##0.0", 
  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'whatever';                                               
  
  CREATE MEMBER CURRENTCUBE.[Measures].[slope2]
   AS LinRegSlope(LastPeriods(24), [Measures].[Measure1],[Measures].[Measure2]), 
  FORMAT_STRING = "#,##0.0", 
  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'whatever';         
  
  CREATE MEMBER CURRENTCUBE.[Measures].[slope3]
   AS LinRegSlope([TimeDimension].[CY Month].members, [Measures].[Measure1],[Measures].[Measure2]), 
  FORMAT_STRING = "#,##0.0", 
  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'whatever';                                               
  
  CREATE MEMBER CURRENTCUBE.[Measures].[slope4]
   AS LinRegSlope([TimeDimension].[CY Month].members,[Measures].[Measure2]), 
  FORMAT_STRING = "#,##0.0", 
  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'whatever';                                               
  
  CREATE MEMBER CURRENTCUBE.[Measures].[slope5]
   AS LinRegSlope([TimeDimension].[CY Month].currentmember, [Measures].[Measure1],[Measures].[Measure2]), 
  FORMAT_STRING = "#,##0.0", 
  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'whatever';                                               
  
  CREATE MEMBER CURRENTCUBE.[Measures].[slope6]
   AS LinRegSlope([TimeDimension].[CY Month].currentmember,[Measures].[Measure2]), 
  FORMAT_STRING = "#,##0.0", 
  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'whatever';     
  
  CREATE MEMBER CURRENTCUBE.[Measures].[slope7]
   AS LinRegSlope(LASTPERIODS(24,[TimeDimension].[CY Month]),[Measures].[Measure2]), 
  FORMAT_STRING = "#,##0.0", 
  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'whatever';                                               
  
  CREATE MEMBER CURRENTCUBE.[Measures].[slope8]
   AS LinRegSlope(LASTPERIODS(24,[TimeDimension].[CY Month]), [Measures].[Measure1],[Measures].[Measure2]), 
  FORMAT_STRING = "#,##0.0", 
  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'whatever';    
  
  CREATE MEMBER CURRENTCUBE.[Measures].[slope9]
   AS LinRegSlope(LASTPERIODS(24,[TimeDimension].[CY Month].currentmember),[Measures].[Measure2]), 
  FORMAT_STRING = "#,##0.0", 
  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'whatever';                                               
  
  CREATE MEMBER CURRENTCUBE.[Measures].[slope10]
   AS LinRegSlope(LASTPERIODS(24,[TimeDimension].[CY Month].currentmember), [Measures].[Measure1],[Measures].[Measure2]), 
  FORMAT_STRING = "#,##0.0", 
  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'whatever';    
  
  CREATE MEMBER CURRENTCUBE.[Measures].[slope11]
   AS LinRegSlope(LASTPERIODS(24,[TimeDimension].[CY Month].members),[Measures].[Measure2]), 
  FORMAT_STRING = "#,##0.0", 
  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'whatever';                                               
  
  CREATE MEMBER CURRENTCUBE.[Measures].[slope12]
   AS LinRegSlope(LASTPERIODS(24,[TimeDimension].[CY Month].members), [Measures].[Measure1],[Measures].[Measure2]), 
  FORMAT_STRING = "#,##0.0", 
  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'whatever';    
  
  

   

  I want to be the very best
  Like no one ever was

  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  June 10, 2022 at 6:10 am

  #4047341

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.