Re: Multi Dimensional Cases in Time Series

> 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: Data Mining in SQL Server 2008
    ... that I can expect in SQL Server 2008? ... The most important one is the ARIMA algorithm support for Time Series. ... Dejan Sarka ...
    (microsoft.public.sqlserver.datamining)
Loading