question

CharbelDaia-9232 avatar image
0 Votes"
CharbelDaia-9232 asked SamaraSoucy-MSFT commented

Add more than one cube is an existing Analysis Services project


Hi,

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

Thanks!

Charbel

azure-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SamaraSoucy-MSFT avatar image
0 Votes"
SamaraSoucy-MSFT answered

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.
104800-cube1.png

Choose Add -> New Project.
104894-cube-2.png

The new project dialogue will open up, allowing you to select a type and name.
104838-cube-3.png

You should now have two different cubes in the same solution.
104839-cube-4.png



cube1.png (51.0 KiB)
cube-2.png (72.9 KiB)
cube-3.png (108.5 KiB)
cube-4.png (35.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CharbelDaia-9232 avatar image
0 Votes"
CharbelDaia-9232 answered SamaraSoucy-MSFT commented

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

1 Vote 1 ·