Hi,
I'm very new to AS and MDX so I'm probably not using the correct terms here, sorry about that.
I'm using a cube created by PerformancePoint Server. Among other things, I have the dimensions Project and Customer. Each Project has what PPS calls a dimension property which is linked to Customer. In AS I assume that this is added as an attribute in the Project dimension.
What I would like to do is query out all the values for each Project and its corresponding Customer for a certain month (a bit simplified in this example).
The code below does almost what I want, except that it of course gives a result for each Customer with each (open) Project, instead of just the Projects belonging to that Customer.
select
{[Customer].[All Members].
Members}*{
descendants([Project].[IsOpenCustomer].[True],,leaves)}*{[Measures].
DefaultMember} on columns,{[Time].[Base View].[Month].&[200709]}
on rows FROM Financial
Thanks!