SSAS Logistic Regression

Question

I'm quite new to SSAS and I'm in the process of fumbling my way through my first solution. I have a defined the following in my SSAS project: (I've worked through the "Adventure Works" tutorial already).

• Data Source
• Data Source View
• Mining Structure

What I'm trying to do is predict is how likely a prospect would become a client. To accomplish this I've defined the mining structure & model, but what I'm not sure how to do is apply the prediction to my live data. I've extracted the columns from our production data base corresponding to the columns defined in the mining structure, but I'm not sure what I need to do at this point to accomplish this.

Do I need to obtain the model formula from somewhere within SSAS? If so, where? Or is there an automated process that would allow me to process and update a database table with the corresponding value?

Thanks,

Answer 1

To apply predictions to new data once, you can use "Mining Model Prediction" tab in BI Dev Studio (BIDS). Look at the child topics under http://msdn.microsoft.com/en-us/library/ms175678.aspx 

When you need to automate the process, there are SSIS tasks to perform predictions http://msdn.microsoft.com/en-us/library/ms140358.aspx

(Both of these options send DMX query to SSAS to get prediction and its probability. You can't "obtain the model formula" and use it to perform prediction without using SSAS)

---

Tatyana Yakushev [PredixionSoftware.com]

Answer 2

Hi Tatyana,

 

Thank you so much for the reply. I've built my prediction query and I'm trying to perform "Save Data Mining Query Result", but I'm running into a problem where after ~2600 rows have been written (approx. 80 seconds) the processing fails with an error "Failed to save data mining query result because of the following error:The connection either timed out or was lost". I've searched google, but none of the proposed solutions seem to fix this issue. I've setup the timeout on my Data Sources to 0 as well as adjusted the SSAS server timeout properties via Sql Management Studio to infinite as well. Still the processing fails at the same point.

Do you happen to have a solution for this?

Answer 3

Please tell us more about what you are doing. Are you saving data mining query results using BIDS? If so, can you try opening Tools, Options..., and changing timeouts under "Business Intellegence Designers" and "Database Tools"?

---

Tatyana Yakushev [PredixionSoftware.com]

Answer 4

Hi Tatyana,

That is correct, I'm using BIDS to run the data mining query. if I click on  "Result" from the Mining Model Prediction tab, I'm able to see the expected results. The issue I'm having is when attempting to save the results to another server. So, within my project I have a DataSource defined on another server which contains my data to run the prediction against and the project is connecting to the SSAS services on another server.

Another thing I had tried was running the output of the Mining Model Prediction as an MDX query from Sql Management Studio and I was able to get the results successfully from there. It's interesting that there are issues when writing to my destination table on another server.

Thanks again!

Jason

Answer 5

Hi Tatyana,

I've adjusted the timeouts under "Business Intellegence Designers" and "Database Tools" to 0. Interestingly I get the same error when I attempt to run the prediction via a SSIS package as well.

Answer 6

Hi Jason,

Are you able to connect to the destination server. Thos looks more of permissions issue.

---

Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar