Can i get Linear regression line(trend line) with MDX

• santhu_smily

  Say Hey Kid

  Points: 696

  More actions

  September 30, 2008 at 9:07 am

  #194267

  Hi,

  Can i get Linear regression line(trend line) in the plot of SSRS ?

  I am trying to get the records in the MDX query level so that the resultset can be plotted as a trendline along with X,Y.

  Ex: X,Y are from cube.

  Z is to be derived as a resultset of the MDX query so i can use it for plotting a straight line in the chart of SSRS.

  Please help me in this regard.

  Give me a sample code if possible.

  Thanks in advance,

  santhu.

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  September 30, 2008 at 9:29 am

  #878934

  Mosha has some hints on how to achieve this, here.

  Steve.

• santhu_smily

  Say Hey Kid

  Points: 696

  More actions

  October 5, 2008 at 11:23 pm

  #880962

  Hi Steve,

  The link helped me .

  I am able to meet the requirements.

  Thanks a lot for the help.

  ...santhu

• santhu_smily

  Say Hey Kid

  Points: 696

  More actions

  October 5, 2008 at 11:36 pm

  #880964

  Hi steve,

  I am using scatter chart for plotting Y-axis.

  So, for the regression line i am computing the data at the MDX query level and the data is displayed as a separate value.

  SSRS wont allow different charting types in the same plot????

  For ex: Y-axis: Scatter graph

  Regression Line: Line graph

  I have null values for certain range in the data.

  But the regression line should be line graph instead of scatter graph.

  Can i achieve this?

  I am using SSRS 2008.

  Any possibility, let me know.

  Thanks a lot,

  santhu