Problem: How to browse a SQL Server Analysis Database cube from Microsoft Excel.
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 curious
to learn how to build a cube design please go through this article, How
to build a cube.
We can access a cube from Microsoft analysis services by
writing some MDX queries and alternatively we can pull the data from cube using
Microsoft excel by specifying data connections.
Example:
In this example, I would like to show we can browse the cube
from EXCEL.
Step 1:
launch Microsoft excel and make sure you have permissions to connect to the analysis
server database.
Step 2: select the analysis services option from the drop down of sources.
Step 3:
Specify the connection server and login credentials if needed.
Step 4:
Select the analysis database you want to browse.
Step 5:
From the excel you should now have options to select the fields you want to
slice and dice
Step 6: I have generated a sample report from the pivot
fields to sum the sales amount by year month day hierarchy.
Results:
0 comments:
Post a Comment