Start, , Microsoft SQL , Analyses Services Analysis Manager.
.3.1. Analysis Manager
1. Analysis Manager .
2. . .
3. , New Database.
4. Database, , Tutorial, OK.
5. Analysis Manager, , Tutorial, .
Tutorial :
.3.2. Tutorial
Tutorial. .
(DSN), ODBC .
1. Analysis Manager Tutorial, New Data Source.
2. Data Link Properties, Provider, Microsoft OLE DB Provider for ODBC Drivers.
.3.3.
3. Connection, Tutorial.
4. Test Connection, , .
5. OK, Data Link Properties.
- . .
, Tutorial, , Wizard.
- , . - , , . .
1. Welcome , Next.
2. , Tutorial, sales_fact_1998.
3. sales_fact_1998, Browse.
4. , , store_sales. store_cost unit_sales, Next.
1. Select the dimensions for your cube Cube, New Dimension, .
2. Welcome Next.
|
|
3. Star Schema Next.
4. , time_by_day. , time_by_day , Browse Data.
4
5. , Time Dimension, Next.
6. . Select time level, Year, Quarter, Month, Next.
7. , Next.
8. .
: , , , .
9. Finish, .
10. .