Hi All,

When I create a measurement from a member property, I have to
write exactly that which hierarchy I want to get the member property
from. I have four hierarchy in this dimension. A hierarchy is created
in order to filter the data.

For example, I get the member property from customer dimension
Hierarchy A because I want Hierarchy A to be rows in my report. Then I
use customer dimension Hierarchy B to filter the data. As a result,
the report show the data without concerning anything about hierarchy
B. If I want my report to be filtered, what kind of MDX do I have to
do?


This is my current MDX statement

iif(isleaf([Customer].[SalesOrg].currentmember),
iif((val([Customer].[SalesOrg].currentmember.properties("Credit
Limit"))) <> 0 and ([Measures].[Open Balance] <> Null),
val([Customer].[SalesOrg].currentmember.properties("Credit
Limit")),Null),

Sum(Descendants([Customer].[SalesOrg].currentmember,[Customer].[SalesOrg].[Customer],Leave),[Measures].[Credit
Limit]))

Best Regards,

Anote