Data Source View

Discussion in 'microsoft.public.sqlserver.datamining' started by Gilgamesh, Apr 4, 2007.

  1. Gilgamesh

    Gilgamesh Guest

    I've got a situation where I need to pull data from a few tables, then do
    some comparison, and then aggregate them into a new dataset. The final
    dataset will be passed to Reporting Services to be used as the back end
    data. I don't see any other way rather than processing the collected data is
    some kind of C# program before it can be presented to Analysis Services as a
    Data Source View. I need to use Analysis Services because it's been already
    setup for feeding data to Reporting Services. Is there any way to get this
    done with or without a C# program?

    Thanks,
    Gilgamesh
     
    Gilgamesh, Apr 4, 2007
    #1
    1. Advertisements

  2. Gilgamesh

    Dejan Sarka Guest

    I've got a situation where I need to pull data from a few tables, then do
    You can use SQL Server Integration Services (SSIS). You can read data from
    multiple sources, merge and cleanse it, aggregate it... All with tasks
    shipped with the product. Check it in Books OnLine, I guess this is what you
    need.
     
    Dejan Sarka, Apr 4, 2007
    #2
    1. Advertisements

  3. Gilgamesh

    Gilgamesh Guest

    Will SSIS be feeding data to SSAS then?
    -G

     
    Gilgamesh, Apr 4, 2007
    #3
  4. Gilgamesh

    MC Guest

    Short answer would be yes. SSIS can prepare the data for your SSAS models...


    MC
     
    MC, Apr 4, 2007
    #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.