MDX Intersect() Function

[teroman]

Hi,

I have a column in my fact table that can be split in two ways, so i have attatched 2 dimensions to it.

These are sites, and can be split by location or by business group. Several business groups can operate in the same location.

I want to count the number of sites as i split in both dimensions, so need to count sites that are in both.

I can do either using the count(descendants) type function

These work fine, so I tried to Intersect() them and then count the result. This results in #ERR appearing all over the shop, and i dont know why.

Any help would be appreciated

thank

col