MDX语句查询总行数

Question

怎么通过MDX查询ROWS的总数。

SELECT {[activeUser],[clickCount],[showCount]} ON COLUMNS,
    {[channel_name].children} ON ROWS
FROM [adCount]

现在我想查ROWS的总数，应该怎么写呢？求助！

Answer 1

已经找到了，记录下

channel_name维度的总数

WITH MEMBER 
    [Measures].[channelCount] AS {
        [channel_name].children
    }.COUNT
SELECT {[Measures].[channelCount]} on COLUMNS 
FROM [adCount]