Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

data mining using SSAS design question Expand / Collapse
Author
Message
Posted Monday, December 5, 2011 1:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 2:55 PM
Points: 9, Visits: 183
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
Posted Tuesday, December 27, 2011 8:03 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:36 AM
Points: 416, Visits: 523
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
Posted Tuesday, August 28, 2012 11:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 11, 2014 2:15 PM
Points: 6, Visits: 38
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
Posted Thursday, July 3, 2014 6:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 14, 2014 11:48 PM
Points: 6, Visits: 6
One key aspect is there should be that cannot be handled by a single computer. Other aspects that are proposed to defined big data is that the data is heterogeneous that it is evolving , and that it is decentralized and distributed.
Post #1588821
Posted Thursday, July 3, 2014 6:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 14, 2014 11:48 PM
Points: 6, Visits: 6
your on investment. Salford Systems' Rapid Response Data Mining center plans and executes demonstration projects and proof-of-concept studies in as little as four weeks. Value assessments of large scale data mining projects are generated quickly and cost-effectively on our six high speed servers with massive storage capacity.
Post #1588844
Posted Thursday, July 3, 2014 7:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 14, 2014 11:48 PM
Points: 6, Visits: 6
A database is a collection of records or data that is stored in a computer system. The structure of a database is dependent on how the data is organized, according to a particular database model. Today we commonly use a relational database model. Other models include a hierarchical model and the network model..
Post #1588871
Posted Friday, July 4, 2014 1:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 14, 2014 11:48 PM
Points: 6, Visits: 6
The progress made in hardware technology allows today’s
computer systems to store very large amounts of data.
Post #1589221
Posted Monday, July 14, 2014 11:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 14, 2014 11:48 PM
Points: 6, Visits: 6

When refreshing data that is persisted, the OnPropertyChanged event is raised for every property in every data object, this can cause a lot of slowdown.
Post #1592413
Posted Monday, July 14, 2014 11:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 14, 2014 11:48 PM
Points: 6, Visits: 6
The data mining role also extends into engineering, in particular infrastructure and logging. A few examples that have been developed .
Post #1592414
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse