transform time series to a desired time step

Discussion in 'microsoft.public.sqlserver.datamining' started by manuel costa, Jan 2, 2006.

  1. manuel costa

    manuel costa Guest

    Hi

    i'm starting to get inside data mining tools for sql server 2005. Thank you guys!
    I saw that it possible to use office web components to explore data. Are there any available tools in development studio to use pivot tables to transform time series to the desired scale and export the entire source data into a new table? If not, is there any way to do it on the fly?

    Manuel
     
    manuel costa, Jan 2, 2006
    #1

    1. Advertisements

  2. manuel costa

    Jamie MacLennan \(MS\) Guest

    Depending on the complexilty, you could use SQL GROUP BY statements (in
    which case you could just create a named view in the DSV). If the
    complexity is too high for SQL to process efficiently, you could create an
    OLAP cube to do the aggregations.
     
    Jamie MacLennan \(MS\), Jan 3, 2006
    #2

    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.
Similar Threads

  1. RDA Step by step

  2. Where do I find a step by step how to use SSIS

  3. Step by Step Side by Side SQL Server 2005

  4. Merge replication step by step

  5. step by step article to create a new database

  6. TRANSFORM DATA TASK or STEP DOES NOT RETURN CONTROL BACK TO PACKAG

  7. Problem with DTS Transform step

  8. SSIS: Is it possible to start execution of series of data flow tasks part way through series?

Loading...