Trying to use SSAS DM to solve Multiple Linear Regression problem. Could anyone assist please?

Unanswered Trying to use SSAS DM to solve Multiple Linear Regression problem. Could anyone assist please?

  • Tuesday, May 08, 2012 4:23 PM
     
     

    Greetings,

    Let's say we have the total daily revenue R that we get selling a few hundred different products (p). We know the daily volumes sold (v) and need to use MLR to estimate each product's revenue per unit (rpu). The daily revenue equation for day will look like:

    R=v1*rpu1+v2*rpu2+...+vn*rpun

    We will have a few dozen of the days, each with its associated R

    To summarize. R, v are known. We need to get rpu. The data to be mined can be stored in a cube - 2 measure groups - one containing daily R and another with v, dims are date and products. Or sql tables - either 2 or single, with a daily R column, same R for the day accross all products. 

    I would like to understand if it's possible to use SSAS DM to tackle the task, which model to use and if possible, what keys to assign etc. Thanks!

      


    • Edited by polaro Tuesday, May 08, 2012 6:51 PM
    •