Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Thursday, June 06, 2013 7:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 02, 2013 1:49 AM
Points: 116, Visits: 289
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