BI Learning - Developing First Cube

I'm trying things in a random fashion. Trying to play with AdventureWorks BI DB to create my first CUBE

Let's get Started.

Step 1. Create New Analysis Services Project

Step 2. Under Data Source, Create connection to AdventureWorks DW DB

Step 3 - Create new datasource view from AdventureWorks DW Database

Step 4. Removed Account table as it had no relation with our Fact table

Step 5 - Next step is create cube from existing table. Follow the rest of the steps and complete the process

Step 6 - Now Change Impersonation settings from DataSource. I received an error while trying to deploy, Changing the same to fix the error

Step 7 - Now Deploy the cube

Step 8 - After Deploying the CUBE goto cube browser, You would see below error. Fix this error by setting CUBE->Language-> English (US)

Step 9 - Now Drag and Drop few measures and dimensions

Step 10 - Now, We will look at using SSRS to report data from this cube. This will be in next post.

Step 11 - Create a new SSRS project

Step 12 - Add the SSAS data source to the Reports Project

Step 13 - Create a New Report based on this SSAS Data Source

Step 14 - Drag and Drop Measures and Dimensions as we selected in Step 9. Please note the parameter checkbox is checked to use this Dimension as input parameter for the report

Step 15 - Sample SSRS Report from the CUBE

More Reads

Below posts were helpful and good learning's to complete this exercise

SSRS Drillthrough for SSAS cubes, how to pass a parameter to an MDX dataset

Steps to create a SSRS report with MDX accessing a Cube

Calculated Members in SSAS Cube

Create a SSRS Report based on a Cube and Deploy it

MDX Solutions from Field, for the Field

Happy Reading!!