I have a design question and want to understand whether my problem could be solved using SSAS data mining and if yes, which algorithm will be useful.
I have a revenue fact table with dimension keys for say, dim A, dim B, dim C and dim D along with date dim. ( I have already built a cube for this) I want to predict my revenue for dim A and also simultaneously see effect of dim B, dim C and dim D on the behavior of this prediction. so, for example I want to see prediction of my revenue by region. But then I should be able to select a product and see the prediction by region for that product and so on for other dimensions.
I tried time series algorithm but found that i can have one time series with one date dim and one other dimension only. I can't have dim A and dim B simultaneously on time series along with dim date. (Is it true? or I'm missing something).
What other possible algorithms i can use for this kind of scenario and how to model that in SSAS?
Any help is appreciated.