Last week, I was waiting for somebody to provide me Analysis Services solution files to update some SSAS cubes. I updated those cubes when I got solution files but later I found out a simple way to reverse engineer and create exact same source code files based on an existing Analysis Services database. To reverse engineer, follow these simple steps.

• From BIDS, create a new project by selecting project template “Import Analysis Services Database” as shown in the following snapshot.

• When you click on OK, Import Analysis Services Database Wizard will start.
• Click Next and enter Server name and the Analysis Services database you want to import

The wizard will start import process and create project files exactly same as the original source files.

In SQL Server 2012 Analysis Services, the Import Analysis Services Database option is available for both Tabular and Multi-dimensional databases.