, OLAP- MS SQL Server Analysis Services.
- .
:
Ø OLAP_Balance_Teplo_DB, 1;
Ø SQL Server, Analysis Services SQL Server Browser ( 2008).
1
ü Analysis Services. ( OLAP_Balance_Teplo_DB) .
MS SQL Server Business Intelligence Development Studio.
2. File → New → Project. Analysis Services Project. OLAP_Analysis_BalanceTeplo Name. Ok .
3. Solution Explorer Data Source. New Data Source. . Next .
4. , . Create data source based on an existing or new connection , . , New Connection Manager ( 1). OK . Next .
1
5. , Impersonation Information, , Analysis Services . Use the service account ( , Analysis Services) Next.
6. . OLAP Balance Teplo DB Finish . Data Source Solution Explorer.
7. , Analysis Services , . Solution Explorer Data Source Views. New Data Source View. . Next .
|
|
8. Select a Data Source. OLAP Balance Teplo DB. Next.
9. , . T_OLAP_Dim_Pech, T_OLAP_Dim_Dates, T_OLAP_Fact_Balance_Teplo , . Included Objects. Next .
10. OLAP Balance Teplo DB View Finish . Data Source Views Solution Explorer, ( 2), .
2
2
ü OLAP- .
1. Cubes Solution Explorer New Cube. . Next.
2. (, , , ). Use existing tables Next.
3. Select Measure Group Tables. Data Source View OLAP Balance Teplo DB View. , , . .. T_OLAP_Fact_Balance_Teplo, ( 3). , , Suggest. , Next.
3 ,
4. Select Measures ( 4). , . Next.
4
5. ( 5). Next.
5
|
|
6. OLAP Balance Teplo Cube Finish . Cubes Dimensions . , , , , ..
7. Analysis Services ( ). , , Analysis Services. OLAP_Analysis_BalanceTeplo Solution Explorer Deploy. Deployment Progress. Deployment Completed.
6 Deployment Progress
3
ü .
ü 1, 4, 9.
ü .
1. , Browser . ( , ). .
2. T_OLAP_Dim_Pech ( +) . PK . , Drop Column Fields Here. ( 7).
7
3. PK T_OLAP_Dim_Dates , Drop Row Fields Here ( 8).
8
4. T_OLAP_Fact_Balance_Teplo . , Drop Totals or Detail Fields Here. ( 9).
9
5. , PK . T_OLAP_Dim_Pech. All 1, 4, 9 ( 10). Ok.
, ( 11).
10
4
ü T_OLAP_Dim_Pech .
ü T_OLAP_Dim_Dates . . PK .
1. T_OLAP_Dim_Pech.dim, Dimensions Solution Explorer. .
2. Dimension Structure : Attributes ( ), Hierarchies ( ) Data Source View ( ). Data Source View T_OLAP_Dim_Pech Attributes.
|
|
3. T_OLAP_Dim_Pech.dim Solution Explorer Process Analysis Services. , Visual Studio . Yes.
4. Process Dimension T OLAP Dim Pech. Run . , . Process Progress Process Dimension T OLAP Dim Pech Close .
5. Browser T_OLAP_Dim_Pech. Reconnect. Hierarchy . All , ( 11).
11
6. T_OLAP_Dim_Pech ( T_OLAP_Dim_Pech.dim [Design] → Close). 1 2 T_OLAP_Dim_Dates .
7. Regular ( ), .. . . Analysis Services , , , , .. T_OLAP_Dim_Dates (, ), , . Dimension Structure Attributes T_OLAP_Dim_Dates Properties. Properties . Type Time .
8. 7 PK , . Type Date → Calendar → Date, Date → Calendar → MonthOfYear, Date → Calendar → Years. , 3 4. T_OLAP_Dim_Dates 5, , .
9. Dimension Structure Attributes Hierarchies . , . Properties Hierarchy Name . , Attributes <new level>. PK . , 12. (Process).
|
|
12
10. Browser T_OLAP_Dim_Dates. Hierarchy . ( 13).
13
5
ü .
1. OLAP Balance Teplo DB Cube OLAP Balance Teplo DB Cube.cube Cubes Solution Explorer.
2. Cube Structure Measures . Properties. Properties .
3. Properties AggregateFunction Sum Min. , , , . , Process , .
4. Browser. Reconnect, Browser. (), () ( ). ( 14).
14