Hi, thanks for the response

The error only occurs when browsing in the dimension editor of BIDS

I did use the profiler and carriedout the query is MSSMS and Excel.

In these environments the query returns a complete list of leaf node members, no matter which of the two dimension members I drill-down from

I tried filtering the query to a total of 978 records (in this case rented properties), 954 are "Not Let in the Period" and 24 are "Let in Period". The measure used is a base measure, i.e. it is derived from a column in the fact table called Nr properties

Drilling down on the "Let in Period" dimension I would expect just 24 records. In fact the complete list of 978 properties is returned although the sub-total reports 24

There are really two problems here; the CHILDREN function error, and, the complete leaf node data-set being returned

Any ideas, help will be appreciated