SSAS: Display measures in Rows

Little trick :)

WITH 
    MEMBER [Date].[Calendar Year].[Value] AS [Date].[Calendar Year].[CY 2005].Parent 
SELECT 
    [Date].[Calendar Year].[Value] ON COLUMNS,
    Measures.AllMembers ON ROWS
FROM [Adventure Works]

posted @ 2015-05-11 14:22  Hopecho  阅读(117)  评论(0编辑  收藏  举报