通过多维成员过滤MDX [英] MDX filtering by multiple dimension members

问题描述

问题

我需要创建一个报告，该报告将列出符合某些条件的许多帐户-simulationDate，statisticPeriod，region.

I need to create a report which will list a number of accounts that match certain criteria - simulationDate, statisticPeriod, region.

现在我的查询如下:

WITH MEMBER [Measures].[Count] as 1
SELECT [Measures].[Count] ON COLUMNS,
NON EMPTY 
Crossjoin(
[Account].[Account Number].ALLMEMBERS,
{[simulationDate].[day].&[10010101]},
{[statisticPeriod].[period].&[201201]},
{[region].[code].&[SO]}
)
ON COLUMNS
FROM [myWH]

这种跨维度过滤可以吗?

Is this cross-dimensional filtering okay?

推荐答案

最后，我最终将过滤器用作列，并让NON EMPTY子句负责过滤:

In the end I ended up using the filters as my columns, and letting the NON EMPTY clause take care of the filtering:

SELECT 
 NON EMPTY 
    {[simulationDate].[day].&[10010101]} *
    {[statisticPeriod].[period].&[201201]} *
    {[region].[code].&[SO]}
 ON COLUMNS,
 NON EMPTY
    [Account].[Account Number].ALLMEMBERS 
 ON ROWS
FROM [myWH]

这篇关于通过多维成员过滤MDX的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！