一般维度设计

简单介绍BI模型设计

3

简单介绍BI模型设计

01(

02 03 04 05(Measure)

)

(Dimension)

SSAS 2008 SSAS 2000 SSAS 2000

3.13.1.1 SSAS 2008( SSAS 2000) Cube ( Cube )

42

简单介绍BI模型设计

SQL Server 2008 OLAP

01Cube Cube (Properties) Cube SSAS 2005 SSAS 2005 based) (Attribute-

02 3.1 04 05

Tipattribute property

(Attribute) (Business Entity) (Attribute)

(Key Attribute)

SSAS 2000 Cube SSAS 2008

43

简单介绍BI模型设计

(

) )

01(Attribute)

(

02 03

3.1 ( ( ) ) ( ( ) )

04 05

(Key Attribute) 3.1

(Attribute) SSAS 2000 (Hierarchy) 2008 (Attribute) SSAS 2008 SSAS

44

简单介绍BI模型设计

SQL Server 2008 OLAP

3.2SSAS 2008 SSAS2008OLAP Sample

01 02 3.2 04 05

3.2.1

2

3.2

3.2

Step01 3.3

3.3

45

简单介绍BI模型设计

Step02

01 02 03 04 05

SSAS

3.4

Step03 ) (Key Attribute)

(

( )

SSAS

(Attribute)

(Key column) (Name column) (Value column) ( ( ) )

46

简单介绍BI模型设计

SQL Server 2008 OLAP

01 02 3.2 04 053.5

Step04

SSAS 2008 SSAS 2008

3.6

3.6

47

简单介绍BI模型设计

Step05

SSAS 2008 (Attribute) 3.7

01 02 03 04 05

3.7

Step06

SSAS 2008 MDX

48

简单介绍BI模型设计

SQL Server 2008 OLAP

01 02 3.2 04 053.8

( ( ) Step07 3.9 )

3.949

简单介绍BI模型设计

Step08

3.10

01 02 03 04 05

3.10

Step09

(Attribute) (Attribute) (Attribute)

(Attribute) (Properties) (Properties) (Attribute) ( ) 3.11 NameColumn

50

简单介绍BI模型设计

SQL Server 2008 OLAP

01 02 3.2 04 05

3.11

(Properties)

3.12

Step10

(Attribute)

3.1351

简单介绍BI模型设计

01 02 03 04 05

3.2.2SSAS 2008 (Attribute) (Key Attribute) (Attribute) 3.14 (Attribute)

3.14

(Attribute) ( ) SSAS 2000 Changing Dimension

(Attribute)

52

简单介绍BI模型设计

SQL Server 2008 OLAP

01 023.15 (Attribute)

3.2 04 05

3.2.3

3.16

8

Cube

3.17

53

简单介绍BI模型设计

01 02 03 04 05

3.18

(Attribute)

3.19

54

简单介绍BI模型设计

SQL Server 2008 OLAP

3.3(Balanced Hierarchy) (Unbalanced Hierarchy) SSAS 2008 Hierarchy) (Parent-child Hierarchy) (Ragged

01 02 3.3 04 053.20

3.3.1

( )

3.20

( (Properties) HideMemberIf

) ParentName

55

简单介绍BI模型设计

01 02 03 043.21 HideMemberIf

05

HideMemberIf

Never OnlyChildWithNoName

OnlyChildWithParentName

NoName ParentName

ParentName 3.22 SSAS 2008 ) HideMemberIf (

3.22

56

简单介绍BI模型设计

SQL Server 2008 OLAP

3.3.2

01 02 3.3 04( )

(BOM)

05

SSAS 2005

SSAS 2008 3.23

3.23

57

简单介绍BI模型设计

(

3.24

01 02 03 04 05

)

3.24

3.25

(Naming Template) NamingTemplate58

3.26

简单介绍BI模型设计

SQL Server 2008 OLAP

01 02 3.3 04 05

3.26

NamingTemplate

3.27

Leve02

3.2859

简单介绍BI模型设计

01 02 03 043.28

05

(Leaf Member)

( )

SSAS 2008 MemberWithData NonLeafDataVisible ( ) 3.29 ) NonLeafDataVHidden (

60

简单介绍BI模型设计

SQL Server 2008 OLAP

01 02 3.3 04 05M e m b e r Wi t h D a t a NonLeafDataVisible ( ) 3.30 ) NonLeafDataHidden (

3.29

3.30

MemberWithData

61