Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Missing SSAS project Expand / Collapse
Author
Message
Posted Wednesday, September 25, 2013 1:59 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 3:42 PM
Points: 15, Visits: 207
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
Post #1498581
Posted Wednesday, September 25, 2013 10:39 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:20 PM
Points: 3,007, Visits: 2,608
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.


Post #1498663
Posted Thursday, September 26, 2013 1:35 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:32 PM
Points: 13,017, Visits: 10,801
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1498697
Posted Thursday, September 26, 2013 8:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 3:42 PM
Points: 15, Visits: 207
Thank you both, really appreciate it.
Post #1498886
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse