Archive for the 'Data Warehouse' Category
Building a CUBE in SQL Server 2008
Creating the Project
To create a cube, we need to create a Analysis Services Project in Visual Studio. Start Visual Studio, select File, New Project. In project dialogue box, select Business Intelligence Projects from Project Types and select Analysis Services Project from right in the dialogue box.
Related Posts:
No commentsData Warehouse terms
This post describes the different useful Data Warehouse terms which are closely associated with Kimbal Data Warehousing approach.
- Measure It is a numeric value in reporting and analysis. Example: Price,Balance or Inventory. Measures come from data sources. Measure is characterized by grain.
- Dimension A dimension is a collection of related values called members. example: 2008 is a member of Time. It can be described as an “axis of analysis”. In a query, dimension can be part of the query result. The most fundamental dimension is Time, which is essential in any context. Dimensions are typically master data entries.
Related Posts:
No comments
