Question to create Measure for prior sale year and month

Hi All,

I have started with SSAS last week and getting into several options. I came across following difficulty. Please help if you have any ideas.

I’m building a report that has attributes A1, A2, A3, Year and Month and measures M1 and M2

A1

A2

A3

Year

Month

M1

M2

The M1 value is such that it is M2 of Month 6 of Year – 3.

For example, for Year 2007, month 3 the value of M2 is 100

And for year 2004, month 6 the value of M2 is 66

Then the report would be like

A1

A2

A3

Year

Month

M1

M2

a

b

c

2007

3

66

100

How to create M1 measure ?

Thanks in advance.

Sorry, but I don't quite follow what M1 represents? Is M1 the M2 value at a point in time that is 3 years prior to the current point in time?

Thanks,
Bryan

Question to create Measure for prior sale year and month

Hi All,

I have started with SSAS last week and getting into several options. I came across following difficulty. Please help if you have any ideas.

I’m building a report that has attributes A1, A2, A3, Year and Month and measures M1 and M2

A1

A2

A3

Year

Month

M1

M2

The M1 value is such that it is M2 of Month 6 of Year – 3.

For example, for Year 2007, month 3 the value of M2 is 100

And for year 2004, month 6 the value of M2 is 66

Then the report would be like

A1

A2

A3

Year

Month

M1

M2

a

b

c

2007

3

66

100

How to create M1 measure ?

Thanks in advance.

Sorry, but I don't quite follow what M1 represents? Is M1 the M2 value at a point in time that is 3 years prior to the current point in time?

Thanks,
Bryan

sql

Question on data mining report performance optimization

Hi, all experts here,

Would any of you give me any ideas for how could we optimize the report on data mining models? (as we know, for the data mining report, we have to select the mining model and the case table)

Hope it is clear for your advices and help.

Thanks a lot in advance and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

What kind of report is this? An accuracy report, such as lift chart or scatter plot?

Also, what kind of algorithm is involved?

|||

Yes, accuracy report and lift chart report. All SQL Server 2005 built-in algorithms there.

Any suggestions?

With best regards,

Yours sincerely,

|||

Service Pack 2 added some performance improvements in generating accuracy reports for the Naive Bayes algorithm.

Besides this, there is not much you can do to improve the performance of these reports.

You could try to use the tip here: http://sqlserverdatamining.com/DMCommunity/TipsNTricks/4566.aspx and implement your own accuracy chart using reporting services

What kind of problems are you running into? Could you please let us know how many test cases are you using and how much time does it take to populate the report?

|||The performance of the lift chart/etc. is directly related to the number of cases you are testing. I.e. if you cut the number of cases in half, you will cut the time in half.|||

Hi, all,

Thanks a lot for your very kind advices and help.

With best regards,

Yours sincerely,