Problem: How to deploy a cube
to SQL Server Analysis Database.
Solution:
To access the cube from SQL Server Analysis database we need
to deploy the cube structure design created from BIDS or SSDT. If you are
curios to learn how to build a cube design please go through this article, How
to build a cube.
What happens in the deployment process of a cube?
To deploy a cube, we first need to build the cube project
which will help to copy structure of the cube design when it has been built,
the data source view will get build in the form as database in the solution bin
folder when you build the analysis services project.
After the build is successful we can deploy to a target
server from the project itself to set the properties of destination database
and server information.
Example:
In this example, I would like to show we can deploy a cube
which has been designed already.
Step 1:
launch the SQL Server Data Tools and open the SSAS project and build the
project by right clicking on the project and hit build.
Step 2: After
the build is successful you should expect to see some files in the bin folder
.asdatabase and configsettings and etc like below.
Step 3: Now
you can deploy the cube from the project folder by right clicking on the project
and hit properties to set the target server and database name.
Step 4: Hit
deploy and you should expect the cube design on the SQL server analysis server
where you have deployed.
Step 5: verify
the cube by connecting to SQL Server Analysis Engine from SSMS.
Results:
0 comments:
Post a Comment