data mining using SSAS design question

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Mining » data mining using SSAS design question

data mining using SSAS design question

Rate Topic

Display Mode

Topic Options

Author

Message

amy3672

Posted Monday, December 05, 2011 1:31 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 05, 2012 6:00 PM
Points: 9, Visits: 172

Hello -
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.
Thanks,
Amey

Post #1216664

byoBI

Posted Tuesday, December 27, 2011 8:03 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:45 PM
Points: 415, Visits: 487

would it be possible to combine the 4 dimensions in the DSV and then create 1 "super" cube-dimension for use in the dm model?

Post #1226925

Tim Paulsen

Posted Tuesday, August 28, 2012 11:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 29, 2013 11:19 AM
Points: 6, Visits: 33

As long as Dim A-D are all linked together through the fact table, you should be able to add Dimension A as the initial Dimension and the rest of the Dimensions as nested Dimensions.

Post #1351144

« Prev Topic | Next Topic »

Permissions