MDX怎么查询总行数

[liwei2633]

这个是一个简单的mdx查询，但是我现在想查询ROWS的总数，要怎么查呢？求助！

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

[bluetata]

简单的

MEMBER RowCount AS COUNT(NONEMPTY([XXX].[ZZZZ].MEMBERS))

多轴：

WITH
SET [Rows] AS 
   {Axis(1)}
MEMBER [Number of rows] AS 
   [Rows].Count 
...