170 likes | 285 Vues
Embark on a mind-bending journey through a mysterious cube space where danger lurks at every turn. Explore surreal dimensions and unravel cryptic secrets. Dive into a world filled with intrigue and uncertainty. Can you navigate the complexities and find your way out?
E N D
(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. z 1 4 3 x -2 -3 -2 -4 -4 -3 -2 -1 1 2 3 4 -3 -4
(x, y, z, ?) Danger, Will Robinson. (a1, a2, a3, a4)
(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)
Cube Yeah, but what about AS? Σ Measure Member Attribute-Hierarchy Measures
[Product].[Category] • All Products • Accessories • Bikes • Clothing • Components
([Product].[Category].[Bikes]) [Product].[Category] Bikes Clothing Accessories All Products Components
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
( [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?
( [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])
SELECT [Date].[Calendar Year].Members on COLUMNS, [Product].[Category].Members on ROWSFROM [My Complex Cube]
SELECT [Date].[Calendar Year].Members on COLUMNS, [Product].[Category].Members on ROWSFROM [My Complex Cube]WHERE ([Geography].[Country].[United States])
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])