Dagsorden OLAP

1
Dagsorden - OLAP

• Væsentlige kendetegn ved OLAP
• Sammenhæng til øvrige modeller
• Installationen af OLAP
• Express - Objects
• Et eksempel på anvendelse af OLAP
• Litteratur m.v.
• Case - øvelser

2
Tabeller
3
Kube opfattelsen
Salgsdistrikter
Produkter
Nordjyllland
Midtjylland
Tents
Øvrige Danmark
Canoes
Racquets
Sportswear
Footwear
Q1
Q2
Q3
Q4
Tid
4
Systemanvendelse og design
5
Opbygning af grundregnskab
6
Datawarehouse
Any Source
Any Data
Any Access
Query Reporting Tools
Operational Data
Warehouse Storage
OLAP Tools
External Data
Applications
7
Kunde kategorier
Ordre type
Politikker
Salgs ansvarlig
Varetype
Produktions grupper
Kunder
Brancher
Salgs grupper
Salgs distriktet
Råvarer
Ordre
8
Dimensionering af kuben
District
Dimensions
Product
Boston
Market
New York
Tents
Philadelphia
Time
Canoes
Channel
Organization
Racquets
Line Item
Sportswear
Product
Footwear
Category
Employee
Q1
Q2
Q3
Q4
District
Time
9
Udvælgelse af Data
District
Product
Boston
New York
Philadelphia
Query Example Selecting from my biggest sellers
in Philadelphia (at least 150K Sales for the
latest quarter), pick the top 2 products based on
profitability
Q1
Q2
Q3
Q4
Time
10
Udvælgelse af Data
District
Product
Boston
New York
Philadelphia

• Query Example
• limit Time to last 1

Q1
Q2
Q3
Q4
Time
11
Udvælgelse af Data
District
Product
Boston
New York
Philadelphia

• Query Example
• limit Time to last 1
• limit District to Philadelphia

Q1
Q2
Q3
Q4
Time
12
Udvælgelse af Data
District
Product
Boston
New York
Philadelphia

• Query Example
• limit Time to last 1
• limit District to Philadelphia
• limit Product to Sales gt 150000

Q1
Q2
Q3
Q4
Time
13
Udvælgelse af Data
District
Product
Boston
New York
Philadelphia

• Query Example
• limit Time to last 1
• limit District to Philadelphia
• limit Product to Sales gt 150000
• limit Product keep Top 2 BasedOn Profit

Q1
Q2
Q3
Q4
Time
14
Rapportering med OLAP vs. relationel rapportering
Query Reporting
OLAP

• What is happening?
• Detail data (transaction-level)
• Simple Analysis
• Sum, average, count

• Why? What next? What if?
• Summary data
• Advanced Analysis
• Trend, forecast, year-to-date, moving average,
  prior period, embedded totals

15
Mapping mellem relationel og OLAP
16
(No Transcript)
17
(No Transcript)