Multi Dimensional Cases in Time Series

Discussion in 'microsoft.public.sqlserver.datamining' started by Panorama, Jan 22, 2006.

  1. Panorama

    Panorama Guest

    Hi,
    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".

    We're interested specifically in a Cube.

    TIA
    Panorama
     
    Panorama, Jan 22, 2006
    #1
    1. Advertisements

  2. Panorama

    Dejan Sarka Guest

    Is there any way to have multiple dimensions as cases for the time series
    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
     
    Dejan Sarka, Jan 22, 2006
    #2
    1. Advertisements

  3. Panorama

    Panorama Guest

    Thanks, Dejan!


     
    Panorama, Jan 25, 2006
    #3
  4. Panorama

    Dejan Sarka Guest

    In case if you are interested, I blogged the problem and the solution at
    http://solidqualitylearning.com/blogs/Dejan/archive/2006/01/27/1512.aspx.

    --
    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
     
    Dejan Sarka, Jan 27, 2006
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.