MỤC LỤC
MỤC LỤC...................................................................................................................iii
PHÂN TÍCH KHO DỮ LIỆU (QUÁ TRÌNH SSAS) VÀ NGÔN DỮ TRUY VẤN
MDX 1
1.1 Tạo project SSAS trong SQL Server Business Intelligence................................1
1.2 Tạo Data Sources...................................................................................................2
1.3 Tạo Data Source Views.........................................................................................6
1.4 Tạo Cubes..............................................................................................................9
1.5 Thực hiện truy vấn..............................................................................................18
1.5.1 Truy vấn 1......................................................................................................18
1.5.2 Truy vấn 2......................................................................................................21
1.5.3 Truy vấn 3......................................................................................................24
1.5.4 Truy vấn 4......................................................................................................26
1.5.5 Truy vấn 5......................................................................................................27
1.5.6 Truy vấn 6......................................................................................................28
1.5.7 Truy vấn 7......................................................................................................32
1.5.8 Truy vấn 8......................................................................................................33
1.5.9 Truy vấn 9......................................................................................................36
1.5.10 Truy vấn 10..................................................................................................38