Remember that I said we keep switching between the visual studio and SQL server environments?
And I said that the reason was that each of the environments is meant for a specific goal.
We create and implement components such as the schema, dimensions, hierarchies, facts, and the cube in the visual studio.
After doing these, we should take the cube, our database, and all the dimensions and facts in it to the SQL Server.
By doing this, we create an OLAP database, and whenever we need the data from this database, all we need to do is to connect to the database and make our requests.
The act of taking the cube from the visual studio to the SQL server is called deployment.
Doing this creates an OLAP database in the SQL server under a specific name.
Deploying the Cube
The following steps must be taken for deployment:
We should right-click on the name of the project and select the last option, which is called properties.
A window then opens with multiple tabs on its right.
We go to the Deployment tab, where we should choose the name of the SSAS server.
Since I am doing the work on my computer, I consider the “Localhost” value for it.
In the Database section, I should specify a name for the OLAP database, which I have chosen to be Nill2Bill.
After making the initial settings, I hit ok.
Now everything is prepared for the deployment.
All I have to do is right-click on the name of the project again and click deploy.
The operations above lead to the deployment.
Get Exclusive SSAS Tips
That I Only Share With
Save my name, email, and website in this browser for the next time I comment.
SQL Server BI
SQL Server DBA
SSAS Tutorial for Beginners
SSAS Tutorial for Intermediate
SSAS Data Mining
United States & Turkey
© Copyright 2021 - 2023 | All Rights Reserved | Powered by Nill2Bill