<div>
You need to install the Visual Studio Data tools with the Visual Studio installer on your system. Then there is a Import Analysis wizard project to import a SSAS database into a VS project.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2022/06_w27/1596704/Capture.PNG" target="_blank" title="Capture.PNG (27 KB)"><img alt="Capture.PNG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2022/06_w27/800_1596704/Capture.PNG" /></a><br />
I'm not exactly sure about the version you need, but afaik it is VS 2019 and maybe even at least the professional edition.
</div>


You need to install the Visual Studio Data tools with the Visual Studio installer on your system. Then there is a Import Analysis wizard project to import a SSAS database into a VS project.

Capture.PNGhttps://filedb.experts-exchange.com/incoming/2022/06_w27/1596704/Capture.PNG
I'm not exactly sure about the version you need, but afaik it is VS 2019 and maybe even at least the professional edition.

Capture.PNG

<div>
&nbsp;I have VS 2019 and had already installed SSDT so I can import SQL databases and build SSIS packages.<br><br>When I type import analysis into the templates textbox, it returns a lot of Sharepoint listings, Report server, SSIS, and Azure stuff.<br>No SSAS or anything like that.
</div>


 I have VS 2019 and had already installed SSDT so I can import SQL databases and build SSIS packages.

When I type import analysis into the templates textbox, it returns a lot of Sharepoint listings, Report server, SSIS, and Azure stuff.
No SSAS or anything like that.

<div>
You need to select the second project type from my screenshot.
</div>


You need to select the second project type from my screenshot.

George Contrabass

<div>
Have you installed SSDT? What is your VS version? As I already wrote, I'm not sure what edition is needed. It's possible, that you need Professional or higher.
</div>


Have you installed SSDT? What is your VS version? As I already wrote, I'm not sure what edition is needed. It's possible, that you need Professional or higher.

<div>
<div class="content wysiwyg-content fr-view">
<p>I want to evaluate/tweak MDX queries.</p><p>I know how to get there in SSMS.</p><p>How do I import existing SSAS multidimensional databases/cubes in Visual Studio 2019?</p><p>I am not trying to build new.</p><p>I need to support old.</p><p><br></p><p><br></p><p>Thank you.</p>
</div>
</div>



I want to evaluate/tweak MDX queries.
I know how to get there in SSMS.
How do I import existing SSAS multidimensional databases/cubes in Visual Studio 2019?
I am not trying to build new.
I need to support old.
Thank you.

Visual Studio - import SSAS multidimensional databases?

Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft. It is used to develop computer programs for Microsoft Windows, as well as web sites, web applications and web services. Visual Studio uses Microsoft software development platforms such as Windows API, Windows Forms, Windows Presentation Foundation, Windows Store and Microsoft Silverlight. It can produce both native code and managed code.

Microsoft Visual Studio

SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors - Multidimensional and Tabular.

SSAS

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.