Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

MDX - How do you restrict .members to subcube within calculated members Expand / Collapse
Posted Thursday, June 6, 2013 7:00 AM


Group: General Forum Members
Last Login: Friday, March 27, 2015 10:45 AM
Points: 118, Visits: 297
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:

create subcube mycube as (select {[Dim].[Dim].[Dim].&[key1] , [Dim].[Dim].[Dim].&[key2]} on 0 from mycube

followed by the query:

with member Measures.X as [Dim].[Dim].[Dim].count
select {Measures.X} on 0 from mycube

I would expect to see the value 2 not the count of members in the real cube.

Any ideas how to get around this?
Post #1460671
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse