InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 06:57:30 GMT20http://www.sqlservercentral.com/Forums/Topic1216664-2797-1.aspxAs 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.Tue, 28 Aug 2012 11:28:24 GMTTim Paulsenhttp://www.sqlservercentral.com/Forums/Topic1216664-2797-1.aspxwould it be possible to combine the 4 dimensions in the DSV and then create 1 "super" cube-dimension for use in the dm model?Tue, 27 Dec 2011 08:03:28 GMTbyoBIhttp://www.sqlservercentral.com/Forums/Topic1216664-2797-1.aspxHello -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,AmeyMon, 05 Dec 2011 13:31:20 GMTamy3672