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


    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 costa, Jan 2, 2006
    1. Advertisements

  2. 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
    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.