How to get started with MDX

Question

Hi, I played with MDX and need a very high level getting started guide. I already have SQL-Server 2008 R2 DB and is working with the data in it. I want to try something very simple in MDX to get familiar with the stream. I am not a DW or Cube expert, so I need to start slowly. (Facts / Dimenions are new to me)

I have a view from my relational database that I want to use as the only source for MDX. It's simple:

TABLE WEEKLY_GAIN
  PCTGAIN (DECIMAL) -- The pre-calc'd pctg gain in price from day x to day x+1  
  DATE (DATE)       -- The date the stock pctgain was generated  
  WEEK(INT)         -- Contiguous/Consecutive integer that is keyed to the last trading day of each week.  
  YEAR (INT)        -- The year of the current PCTGAIN from the DATE column

Data examples

PCTGAIN          DATE           WEEK   YEAR  
0.01709791       2011-01-14     2      2011  
0.01102063       2011-01-07     1      2011  
0.0006922469     2010-12-31     52     2010  
0.01033836       2010-12-23     51     2010

I would like to use MDX to generate a cube and some functions (MEDIAN, MEAN, STDEV, etc.). I have successfully identified the above view as a source in MDX. However, I need help with sizing (MDX), keys, cubic definitions, and everything else that needs to be done, etc.

, (, , ?), .

"", , - ... (1950-2011) - , (1-52) , MIN, MAX, MED, PCTGAIN . , T-SQL. , MDX, MDX .

.

Answer 1

MDX : MDX

, , , , UNPIVOTing , , . , MDX MIN, MAX, MED, PCTGAIN .. .

Answer 2

:

Microsoft SQL Server 2008 MDX

.