1 / 16

Lost in Cube Space: Exploring Complex Hierarchies and Measures in Product Data Analysis

Dive into the intricacies of multidimensional cube space with this insightful guide on navigating complex data structures. This exploration covers topics such as product categories, sales amounts, and advanced queries in OLAP systems. Discover how to efficiently summarize and analyze data for products, focusing on various categories like bikes and accessories across different fiscal years. With practical examples and measure member attributes, learn to draw meaningful insights from vast data repositories—ideal for data analysts and business intelligence professionals alike.

inoke
Télécharger la présentation

Lost in Cube Space: Exploring Complex Hierarchies and Measures in Product Data Analysis

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