Problem: How to process a
cube SQL Server Analysis Database.
Solution:
To access the cube from SQL Server Analysis database we need
to deploy and process 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 process of processing a cube?
After we build and deploy the cube database we need to load
all the dimension’s data and facts by aggregations and hierarchy and this
process is called processing of a cube.
Example:
In this example, I would like to show we can process a cube
which has been designed already.
Step 1:
launch the SQL Server Data Tools and open the SSAS project and there are two
ways to process the cube either from the cube folder or project it self
Step 2:
After hitting process it would open a dialog where you can do advanced
configurations or run as default.
Step 3: Now
this will process the cube and you can browse the cube to verify the data load.
Results:
0 comments:
Post a Comment