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
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!