微软BI开拓者

with
set [SoldInUSA] as 'Filter([Product].[Brand Name].Members, Not
IsEmpty( ([USA], [Unit
Sales]) ))'
member [Measures].[SoldInState] as 'iif( IsEmpty(([Product].CurrentMember, [Unit Sales],
[Customers].CurrentMember)), "No","Yes" )'
select [USA].children
on
COLUMNS,
  [SoldInUSA] on
ROWS
from Sales
where ([SoldInState]) 请教高手给我解释解释这个语句吧。。我是新手不要笑哦。

回复一下：看见没有人回复。。您一定很着急

我也只能提示一下：不好意思
1。 IsEmpty( ([USA], [Unit Sales]) ) 判断这个SET是否为空
2。Filter([Product].[Brand Name].Members, Not IsEmpty( ([USA], [nit Sales]) )) 过滤掉[Product].[Brand Name].Members 为空的
3。'iif( IsEmpty(([Product].CurrentMember, [Unit Sales],
[Customers].CurrentMember)), "No","Yes" )  判断( IsEmpty(([Product].CurrentMember, [Unit Sales],
[Customers].CurrentMember)) 为空则显示NO，不为空显示YES
3。 [USA].children 常规来说是显示的内容为USA的各个州名


见笑了。。