MDX - How do you restrict .members to subcube within calculated members

  • 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?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply