SSAS-Info.com - Microsoft SQL Server Analysis Services (SSAS) 2005/2008 resource hub
SSAS Articles Design
Design
Articles about cube design, dimension design, attribute relationship, hierarchies, etc.
Filter     Display # 
# Article Title Author
1 BI Architecture and Design Guidelines Microsoft
2 Fact table design for "State Workflow Analysis": Analysis Services Dimensional modeling Ajit Singh
3 Dimension Attributes: Introduction and Overview, Part V William Pearson
4 Null processing of measures in SSAS2005 Thomas Ivarsson
5 Identifying intra-dimensional members relationship and reducing cube sparsity in Analysis Services 2005 SP2 : Cube design tip Ajit Singh
6 Using TinyInt as keys in Analysis Services Andrew Fryer
7 Dimension Attributes: Introduction and Overview, Part IV William Pearson
8 Star vs. Snowflake in OLAP Land Jesse Orosz
9 Intrinsic Member Properties: The MEMBER_CAPTION Property William Pearson
10 Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005 Ajit Singh
11 Dimension Attributes: Introduction and Overview, Part III William Pearson
12 KPIs in Analysis Services Gogula G. Aryalingam
13 SSAS Beginner’s Guide: Storage Structure Clay Lenhart
14 Dimension Attributes: Introduction and Overview, Part II William Pearson
15 Many to many relations in natural hierarchies Thomas Ivarson
16 Measures and calculations in cubes without natural hierarchies Thomas Ivarsson
17 More Comments on attribute relations and calculations Thomas Ivarsson
18 Analysis Services: Should you use many-to-many dimensions? Denny Lee
19 Building Cubes with SQL Server 2005 Analysis Services Thomas LaRock
20 The many names of attribute relations Thomas Ivarsson
21 Designing Analysis Services database for Inventory type applications Vidas Matelis
22 Dimensional Model Components: Dimensions Part II William Pearson
23 Last Non Empty Affairs Teo Lachev
24 Dimensional Model Components: Dimensions Part I William Pearson
25 Discovering your MetaData Ella Maschiach
26 Manage Unknown Members in Analysis Services 2005, Part II William Pearson
27 Multiselect in different clients illustrated Thomas Ivarsson
28 Customizing object names in Analysis Services database using translations Vidas Matelis
29 Inferred members and dimension changes Thomas Ivarsson
30 Manage Unknown Members in Analysis Services 2005, Part I William Pearson
31 Different types of hierarchies in SSAS2005 Thomas Ivarsson
32 Maximizing Attribute Relationship Aggregations in Changing Dimensions Erik Veerman
33 DefaultMember, subcubes and non-aggregatable attributes Marco Russo
34 One-to-One Attribute Relationships: Forks versus Chains Chris Webb
35 Alternatively Sorting Attribute Members in Analysis Services 2005 William Pearson
36 Dimensional modeling with Ranged Dimensions Alberto Ferrari
37 Basket Analysis using Analysis Services 2005 Sacha Tomey
38 Introduction to Linked Objects in Analysis Services 2005 William Pearson
39 SQL Server Analysis Services Product Samples Microsoft
40 IgnoreUnrelatedDimensions Bryan C. Smith
41 Where do I create my KPIs? (by Nick Barclay) Nick Barclay
42 Inventory Management Calculations in SQL Server Analysis Services 2005 (by Richard Tkachuk) Richard Tkachuk
43 Learning OLAP - Session 1 – The Structure of OLAP Data Tim Peterson
44 Learning OLAP - Session 2 : Finding Measures, Dimensions, Levels, and Member Properties in a Relatio Tim Peterson
45 Employment Analysis BI Solution - Part I (Building the UDM) Vassil Kovatchev
46 SSAS Many to many optimization technique #1 (By Erik Veerman) Erik Veerman
47 Attribute relationships explained (by Richard Tkachuk) Richard Tkachuk
48 Overview of the Analysis Services Development and Management Environments Microsoft
49 Many-to-Many Dimensions in Analysis Services 2005 (by Richard Tkachuk) Richard Tkachuk