WITH SET [用户] AS 'Filter([用户].Members,[分类维度].[分类].CurrentMember.Properties("Cate Id")="attr1" AND
[分类维度].[分类].CurrentMember.Properties("Cate Id"))="attr2"'
select [Measures].[分类下用户总计] on columns,
{ [用户] } on rows
from [Cube]
select [Measures].[分类下用户总计] on columns,
{[分类维度].[分类].Children} on rows
from [Cube]
得到的是一个分类下的用户数,那要得到两个分类的交集用你的这个怎么写后面的
WITH SET [用户] AS 'Filter([用户].Members,[分类维度].[分类].CurrentMember.Properties("Cate Id")="attr1" AND
[分类维度].[分类].CurrentMember.Properties("Cate Id"))="attr2"'