MDX Refresh
Have to pick up my MDX again cause my new job role has alot of data warehouseing involved. (i Think).. here are some simple queries i played around with for Adventure Works database
A good MSDN website for
a basic overview http://msdn2.microsoft.com/en-us/library/ms144785.aspx
key concepts http://msdn2.microsoft.com/en-us/library/ms144884.aspx
select [Measures].[Internet Extended Amount] on columns,
[Source Currency].[Source Currency].Members on rows
from [Adventure Works]
where [Destination Currency].[Destination Currency].&[Australian Dollar]
select {[Measures].[Internet Sales Amount],
[Measures].[Internet Tax Amount]} on columns,
Order( [Customer].[Customer Geography].[Country].&[Australia].children,
[Measures].[Internet Sales Amount], ASC) on rows
from [Adventure Works]
SELECT {} ON 0
, [Product].[Product].[Product] ON 1
FROM [Adventure Works]
WHERE [Product].[Subcategory].[Pedals]
A good MSDN website for
a basic overview http://msdn2.microsoft.com/en-us/library/ms144785.aspx
key concepts http://msdn2.microsoft.com/en-us/library/ms144884.aspx
