我对MDX来说仍然很新,因此,我不敢肯定,如果我要求做些什么,或者说不易做,但这里对我试图为我的MDX询问做些什么的描述含糊不清。 我有两套,不是与同一等级或表象直接相关的,尽管可能有“家庭”一词,但我不知道这将做我想要做的事情。
[Company].[Parent Company].[Parent Company] retrieves a set of all the members of companies that are parents of a company in the second set.
[Company].[Company]. [Company]>检索了包括父母在内的公司所有成员。
I m trying to filter out the [C].[C].[C] set to NOT include any instances of a [Parent Company] in a MEMBER for my MDX query. I tried some weird stuff with Filter() but kept messing up sets/tuples or getting the wrong kind of data.
There isn t any grandparent/multi-generational trickery to these sets, there s only two levels to worry about (companies and their potential parents, there may not be any). If the cube was formatted better, it would had been nice if they were in a hierarchy, but that s not the case here.
例产出:
- Members of
[Company].[Parent Company].[ParentCompany]= {A, C, E} - Members of
[Company].[Company].[Company]= {A, B, C, D, E, F, G}
Then I want to get a set that will return the following: {B, D, F, G} and that s it.
感谢任何帮助!