Re: Multi Dimensional Cases in Time Series

Thanks, Dejan!



>
> > Is there any way to have multiple dimensions as cases for the time series
> > algorithm?
> > For example, you can have both "Customer" and "Product" dimensions as
> > cases for the time series algorithm, so you'd get, for example, the time
> > series results of the customers in "Washington" buying product category
> > "Food".
>
> I don't think it is possible directly. Data Mining structure supports only a
> single level of nesting tables, and this is level used by a fact table, no
> matter from which dimension you start.
> The best solution I can remember at the moment is:
> - in SQL Server, create a linked server to the Analysis Services
> - in SQL Server, create a view by using Qpenquery T-SQL function
> - in the body of the Openquery use MDX query to retrieve the data from the
> cube
> - take care to return a two-dimensional set only!
> - mine the view.
>
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www.SolidQualityLearning.com
> Anything written in this message represents solely the point of view of the
> sender.
> This message does not imply endorsement from Solid Quality Learning, and it
> does not represent the point of view of Solid Quality Learning or any other
> person, company or institution mentioned in this message
>
>
.

Relevant Pages

  • Re: Multi Dimensional Cases in Time Series
    ... > Is there any way to have multiple dimensions as cases for the time series ... > cases for the time series algorithm, so you'd get, for example, the time ... - in SQL Server, create a linked server to the Analysis Services ...
    (microsoft.public.sqlserver.datamining)
  • Re: HMM applied
    ... observations with lines of trend doing it computationally, ... Mario Sacco ... What I'm looking for is an algorithm for segmenting time series. ...
    (sci.math.num-analysis)
  • Re: How does the Yule Walker method for calculating autocorrelation work?
    ... I want to know the algorithm. ... Google didn't help much. ... Time Series: Theory and Methods, second edition ...
    (comp.soft-sys.matlab)
  • Re: HMM applied
    ... observations with lines of trend doing it computationally, because I have to work on a lot of time series. ... I read something about the use of Hidden Markov Model to reach this objective ("Tutorial PM2 - Time series similarity measures" of Prof Gunopulus and Das, ... I'm looking for a document that describes in detail the algorithm to use to translate it in a program. ... Mario Sacco ...
    (sci.math.num-analysis)
  • Discrete-time finite-state Markov model
    ... My need is to substitute observations with multiple lines of trend (of variable length, related to the time series values). ... Now I'm looking for a document that describes in detail the algorithm to be used, so I could translate it in a program. ...
    (comp.dsp)