Problems with MDX and linked objects

I have some cubes that are joined as linked objects (migration of a virtual cube from AS2000).

In the old setup an mdx like this was used to do a certain count:

'nonemptycrossjoin({Descendants([carnumber],[carnumber].[carnumber])},{Descendants([Group],[Group].[Group])},{Descendants([Time].[Time],[Time].[Time].[Day])},).count'

This was used within a cube called Services which was part of a virtual "KPI" cube

Now in SSAS2005 these are joined as a linked object.

The problem now is that the count that before gave 8000 now gives about 2000000, which is understandable, since the MDX now counts across several cubes in the linked cube.

Is there a way to do this count within only one of the linked cubes ?

What number you are counting? My guess, that if you are using function NonEmptyCrossjoin you want count agains some particular measure, in the query there is no measure (is it a typo?). In this case NECJ works agains all the measure groups. If you don't care about a measure value, when performing count you shouldn't use NECJ and use plain Crossjoin function.

|||

Thanks

It worked in AS2000 and gave the count i wanted. Added a measure in 2005 cube and now the mdx works. Thanks :-)