Add more than one cube is an existing Analysis Services project

Question

Charbel Daia 41

Hi,

How do I add more than one cube is an existing Analysis Services tabular project in Visual Studio 2019?

Thanks!

Charbel

Accepted answer

1 additional answer

Answer 1

Samara Soucy - MSFT 5,141

You can have as many as you want- including having different types of projects in the same solution.

Switch over to solution view in the right-hand bar and right click the solution file at the top.

Choose Add -> New Project.

The new project dialogue will open up, allowing you to select a type and name.

You should now have two different cubes in the same solution.

Answer 2

Charbel Daia 41

Thanks for the answer!

Is it only possible to add 1 cube model for project?
If i want to add new cubes in the same solution, i have to add a new project, that's right?

I thought that within the same project it was possible to add new cubes

Thanks
Charbel

Samara Soucy - MSFT 5,141 Reputation points

2021-06-13T19:05:17.597+00:00

You can think of a project as a code equivalent of a database. In tabular each database can only have one model so the project structure matches that. You can group your models by adding multiple projects to a solution, and could further nest them in folders if you wanted, but you can't get around the limitation of 1 database = 1 model. This is different from multidimensional cubes where you were allowed multiple models per database.