Missing SSAS project

  • 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

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

  • 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

  • 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