I believe that calculated members can go beyond the bound of a subcube. However, to me this is counter-intuitive.
If I declare a subcube as:
[font="Courier New"]create subcube mycube as (select {[Dim].[Dim].[Dim].&[key1] , [Dim].[Dim].[Dim].&[key2]} on 0 from mycube[/font]
followed by the query:
[font="Courier New"]with member Measures.X as [Dim].[Dim].[Dim].count
select {Measures.X} on 0 from mycube[/font]
I would expect to see the value 2 not the count of members in the real cube.
Any ideas how to get around this?