mdx topcount 降序查询语句怎么写
0
MDX语句如下: 怎么把order 降序加进去
SELECT NON EMPTY { .} ON COLUMNS,
NON EMPTY
{subset(
topCount ( ...ALLMEMBERS*...ALLMEMBERS,10,. ) ,0,5) }
ON ROWS
FROM (
SELECT (STRTOMEMBER('..&', CONSTRAINED):STRTOMEMBER('..&', CONSTRAINED)) ON COLUMNS
from )
SELECT NON EMPTY { .} ON COLUMNS,
NON EMPTY
{subset(
topCount ( ...ALLMEMBERS*...ALLMEMBERS,10,. ) ,0,5) }
ON ROWS
FROM (
SELECT (STRTOMEMBER('..&', CONSTRAINED):STRTOMEMBER('..&', CONSTRAINED)) ON COLUMNS
from )
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
1 个回复
梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-03-20 回答
赞同来自: 刘三哥