Hi,
How do I add more than one cube is an existing Analysis Services tabular project in Visual Studio 2019?
Thanks!
Charbel
Hi,
How do I add more than one cube is an existing Analysis Services tabular project in Visual Studio 2019?
Thanks!
Charbel
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.
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
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.
6 people are following this question.
Unable to create analysis services resource
Changing analysis service tier from S1 to B1
In Analysis Services, turning the AlwaysUseGateway property True/False
ADOMD. Net Product Version 18.7.0.1 trows exception when extracting data from Azure Analysis Service
Unable to upgrade tabular level to compatibility level to 1500