Post reply

Analysis Service - AdventureWorksDW database

  • February 2, 2012 at 8:00 am

    #267493

    I am trying to import AdventureWorksDW database into Analysis Service but it does not like the database format. what are the steps to import a database into analysis service?

  • February 2, 2012 at 8:27 am

    #1441874

    I am guessing you are just trying to import the Datasource for AdventureWorksDW into an SSAS project, so here is one of the MSDN tutorials that walks you through how to do all of the basics. Lesson 1 walks you through defining the data source.

    Tutorial

  • February 2, 2012 at 8:34 am

    #1441881

    Thanks for the link.

    yes, I am trying to create PerformancePoint Reports (Dashboard, reports, charts, etc.). and I would like to use cube and therefore need to user Analysis Service.

    My understanding was to analysis service need to have it's own database before i can start creating cubes. Little lost but let me go through the link you sent.

    Thanks

  • February 2, 2012 at 9:29 am

    #1441917

    Here are the steps to show existing sql server databases into analysis services

    http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Analysis%20Services%20Database

    Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply