Microsoft Analysis Services Tutorial

Create Product Dimension in Microsoft Analysis Services

In this section we will create the Product dimension

Click Create Dimension button again

Unlike our Time Table, the product table is spanning across two tables so we will choose Snow Flake Schema and click Next

Choose 'Standard Dimension' in the next 'Select Dimension Type' screen

Next You will see 'Select the dimension table' screen. Double click and select product and product_class tables

Select the dimension tables

Click Next and make sure the two tables are joined by the product_calss_id field.

Create and Edit Joins

Click next and choose the levels by double clicking the column names in left panel. Our Product levels are Category, Sub category and Brand in that order.

Select Levels in Dimension

Click Next and and you will see 'member key columns' screen. Simply click next here.
In the next 'Advanced Options' screen click Next
In the next screen, choose a name 'Product' for our newly created Dimension. Make sure we share this product dimension across other cubes by checking the 'Share the dimension' box.
You will create the Customer Dimension Table in the next section

Create Customer Dimension >

Post your Job for Free and get resumes emailed to you instantly. A new FREE service from KnowledgeHills.com

Do you provide IT/Business related services or products? Submit your whitepapers for free and reach our 20,000 plus registered members. You may also like to list your available jobs, list your company or list your product for FREE.

KnowledgeHills© Copyright 2010 All Rights reserved. KnowledgeHills.com is for educational purposes only. We do not guarantee the correctness of the content. The risk of using this content remains with the user. Please read our Privacy Policy Send any comments to: Contact . This site is w3 HTML 4 compliant.