1 / 16

MDX 101 Lost in Cube Space

MDX 101 Lost in Cube Space. (3). -4. -3. -2. -1. 0. 1. 2. 3. 4. y. 4. 3. 2. (3, 2). 1. x. -2. -4. -3. -2. -1. 1. 2. 3. 4. -3. -4. y. 4. 3. (3, 2, 4). 2. Trippy. 1. 4. 3. x. -2. -3. -2. -4. z. -4. -3. -2. -1. 1. 2. 3. 4. -3. -4. (x, y, z, ?).

inoke
Download Presentation

MDX 101 Lost in Cube Space

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MDX 101Lost in Cube Space

  2. (3) -4 -3 -2 -1 0 1 2 3 4

  3. y 4 3 2 (3, 2) 1 x -2 -4 -3 -2 -1 1 2 3 4 -3 -4

  4. y 4 3 (3, 2, 4) 2 Trippy. 1 4 3 x -2 -3 -2 -4 z -4 -3 -2 -1 1 2 3 4 -3 -4

  5. (x, y, z, ?) Freakin’ Sweet! (a1, a2, a3, a4) What the …?!

  6. (a1, a2, a3, a4) (a1, a2, a3, a4, a5) (a1, a2, a3, a4, a5, a6) (a1, a2, a3, a4, a5, a6, a7) (a1, a2, a3, a4, a5, a6, a7, a8) (a1, a2, … an)

  7. Cube Measure Group Σ Measure Member Attribute-Hierarchy

  8. [Product].[Category] • All Products • Accessories • Bikes • Clothing • Components

  9. ([Product].[Category].[Bikes]) [Product].[Category] Bikes Clothing Accessories All Products Components

  10. CY 2004 ( [Product].[Category].[Bikes], [Date].[Calendar Year].[CY 2002]) [Date].[Calendar Year] CY 2003 CY 2002 CY 2001 All Periods [Product].[Category] Accessories Bikes All Products Components Clothing

  11. ( [Date].[Calendar Year].[CY 2002], [Date].[Fiscal Year].[All Periods], [Product].[Category].[Bikes], [Product].[Subcategory].[All Products], [Geography].[Country].[All Geographies], [Measures].[Reseller Sales Amount] ) I’m supposed to type all that? 

  12. ( [Date].[Calendar Year].[CY 2002], [Date].[Fiscal Year].[All Periods], [Product].[Category].[Bikes], [Product].[Subcategory].[All Products], [Geography].[Country].[All Geographies], [Measures].[Reseller Sales Amount] ) ( [Product].[Category].[Bikes], [Date].[Calendar Year].[CY 2002])

  13. SELECT [Date].[Calendar Year].Members on COLUMNS, [Product].[Category].Members on ROWSFROM [My Complex Cube]

  14. SELECT [Date].[Calendar Year].Members on COLUMNS, [Product].[Category].Members on ROWSFROM [My Complex Cube]WHERE ([Geography].[Country].[United States])

  15. WITH MEMBER [Measures].[Total Sales Amount] AS ([Measures].[Reseller Sales Amount]) + ([Measures].[Internet Sales Amount]) SELECT [Date].[Calendar Year].Members on COLUMNS, [Product].[Category].Members on ROWSFROM [My Complex Cube]WHERE ([Measures].[Total Sales Amount])

More Related