override the title l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Override the title PowerPoint Presentation
Download Presentation
Override the title

Loading in 2 Seconds...

play fullscreen
1 / 8

Override the title - PowerPoint PPT Presentation


  • 220 Views
  • Uploaded on

Override the title Chris Harrington chris@activeinterface.com Session Overview OLAP Review MDX Explained SDK/API Options Demos Region W S N Juice Cola Product Milk Cream Toothpaste Soap 1 2 3 4 5 6 7 Month The Multidimensional Data Model

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Override the title' - MikeCarlo


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
override the title

Override the title

Chris Harrington

chris@activeinterface.com

session overview
Session Overview
  • OLAP Review
  • MDX Explained
  • SDK/API Options
  • Demos
the multidimensional data model

Region

W

S

N

Juice

Cola

Product

Milk

Cream

Toothpaste

Soap

1

2

3

4

5

6

7

Month

The Multidimensional Data Model

“Show me my sales by product by region by time”

Dimensions: Product, Region, Time

Hierarchical summarization paths

Product Region Time

Industry Country Year

Category Region Quarter

Product City Month Week

Office Day

why use olap
Why Use OLAP?
  • Relational database
    • Transactional processing
  • Data Warehouse
    • Tactical information
    • “What was the total revenue from soft drinks for Sussex in January?”
    • “What would be the effect on soft drink costs to distributors if syrup prices went up by 10p/gallon and shipping costs went down by 5p/mile?”
  • OnLine Analytical Processing (OLAP)
    • ‘Slice and dice’ for Data Warehouses
terminology
Terminology

Cube –

A multi-dimensional container for information and pre-calculated query results.

terminology6

Location

Products

Time

Terminology

China

Peru

Japan

Italy

Members –

A discrete name or identifier used to identify a data item's position and description within a dimension.

Coffee

Apples

Tea

Onions

January

February

March

April

terminology7

Location

Products

Time

Terminology

China

Peru

Japan

Italy

Hierarchy –

Parent-child relationships within a dimension.

A detail member of a dimension is the lowest level number in its hierarchy.

Coffee

Apples

Tea

Onions

January

Week1

Week2

Monday

Tuesday

Am

pm

Week3

February

March

April

January

February

March

April

terminology8

Location

Products

Time

Terminology

China

Peru

Japan

Italy

Level –

Position within a hierarchy.

e.g. Jan, Feb are of the level Month within Time

Monday, Tuesday would be of the level Day

Coffee

Apples

Tea

Onions

January

Week1

Week2

February

Week1

Week2

March

April