December 5, 2011 at 1:31 pm
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
December 27, 2011 at 8:03 am
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?
Data Enthusiast | @SQLbyoBI | www.opifexsolutions.com
August 28, 2012 at 11:28 am
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.
July 3, 2014 at 6:19 am
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.
July 3, 2014 at 6:51 am
your on investment. Salford Systems' Rapid Response Data Mining[/url] 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.
July 3, 2014 at 7:23 am
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..
July 4, 2014 at 1:12 am
The progress made in hardware technology allows today’s
computer systems to store very large amounts of data.:-D
July 14, 2014 at 11:48 pm
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.
July 14, 2014 at 11:54 pm
The data mining role also extends into engineering, in particular infrastructure and logging. A few examples that have been developed .
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy