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]

原文地址:https://www.cnblogs.com/hopecho/p/4494475.html