OLAP: MS Analysis Server Tutorial (An Example of Web Log Analysis)

in place July 12, 2000, last modified July 12, 2000

---

1. Prepare Data Sources
   - Lunch DTS(Data Transper Server) wizard
   - Choose the 'Text File' as the Data Souce type and select the file, 'vpmwebaccess.log'
   - Set 'cr' and '|" as the row and column diliminaters
   - Choose the 'access db' as the Data Destination type and select the db, 'vpmwebaccess.mdb'
   - Choose the table creation and mapping caption options
   - Run DTS
   - ?? How can I repeat the transper
2. Set up System Data Souce Connection
   - Set ODBC in System DSN
3. Set up Database and Data souce
   - Start Analysis Service Manager
   - Create 'VPMweb Access Analysis'Database, Then 5 components are listed.
   - Create 'vpmwebaccess' as a data source
4. Build a Cube (Use Editor or Wizard)
   Cube : a multidimensional structure of data ={dimensions, measures}
   Star Schema : a fact table with linked multi dimension tables in RDB for OLAP
   Fact : shoud have a measure(an attribute) which has Numeric datatype (?)
   Dimension : a categorical attribute that can classify the fact
   Measure : a dimension that has numeric data type
   Time Dimension : It has a predefined level such as year, month, day etc.
   - Add 'occurance' measur to the cube, It should be numeric type attribute.
   - Add 'time' dimension to the cube, Select a type of level, It should be date/time data type.
   - Add 'person' dimension to the cube. It has two levels person and organization (two attributes are needed).
5. Edit browse cube
   - You can browse and drill down the data of the cube.
   - ?? How can I generate a report for the Cube

---

Knowledge & Engineering Databases (c) copyright Namchul Do, 2000