Home > Articles > Data

Case Study of Building a Data Warehouse with Analysis Services (Part Two)

  • Print
  • + Share This
In Part Two of his series, database administration expert Baya Pavliashvili explores the challenges involved in building and maintaining a warehousing solution using a simple database warehouse.
Editor's Note: This is Part Two of a two-part series. Be sure to start with Part One.
Like this article? We recommend

Like this article? We recommend

The first article in this series introduced you to steps involved in building a data warehouse. It also presented an example scenario of solving business problems with a data warehouse. This article continues exploring challenges involved in building and maintaining a warehousing solution.

Analysis Services Cubes

So far we have dimension and fact tables in the warehouse. Now we can create dimensions and cubes within MS Analysis Services. Plenty of tutorials and articles exist, showing you step-by-step wizards that Analysis Services supplies for creating dimensions and cubes, so I won’t repeat them here. Instead, Figure 1 shows you the final view of the data within Analysis Manager.

Figure 1

Figure 1 View of the cube data within Analysis Manager.

If we had a data source that was continuously updated by Northwind employees, we would also have to reprocess the cube to make sure it had up-to-date data. You can process cubes manually through Analysis Manager or use Analysis Services Processing Task within DTS.

  • + Share This
  • 🔖 Save To Your Account