Post reply

Missing SSAS project

  • September 25, 2013 at 1:59 pm

    #151283

    Hello,

    I inherited a data warehouse with cube/dimensions and am being asked to make changes.

    I do not have the SSAS project used to create the dimensions/cubes. Is there a way to recreate this or how would I go about making changes to them?

    Thank you very much,

    Josh

  • September 25, 2013 at 10:39 pm

    #1653406

    There is an Analysis Services project that Imports from an existing AS database. Create a new project in BIDS and select this project, point it at your existing database and your pretty much done.

  • September 26, 2013 at 1:35 am

    #1653431

    You can also connect Visual Studio to the project on the server.

    Choose File,Open from the menu and choose Analysis Services Database.

    This online editing mode has however a certain amount of risk, because if you screw up in the designer and save your changes, the database on the server is screwed up as well.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • September 26, 2013 at 8:32 am

    #1653600

    Thank you both, really appreciate it.

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

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