How to ignore a dimension in MDX?

Hot Topic

Are report parameters cached in the report server?
Cannot change naming metadata
Linking Oracle Servers
How to browse a cube using a web browser
Accessing DataReader data in Script Task
No Real in 2005??[:S]
Study Material
Calculations tab - MSAS 2005
SSIS data lookup question
Management Studio - Graphical Show plan

SQL Server

Merge disparate queries into raw file
kick people logged on
2005 64 bit : Client Tools for 32 bit.
How to connect SQL Server Mangement Console to Adventure Works
VB.Net 2003 and SQL Server 2000 application on a Thin Client Network
print from report manager in landscape
Interactive sort doesn't work for multiple sub-reports
DTC - Transaction context in use by another session
Schedulling Jobs on SQL 2005
Full-Text Search -- What Thesaurus does it use??

How to ignore a dimension in MDX?

So my fact table looks like this:

SurveyID ( --> Survey Dimesion)
GroupID( --> Group Dimension)
StatusID ( --> Status Dimension ... e.g. Complete, InProgress, New)
GroupCount (the actual measure)

How would I create a calculated member that would return the "overall" count for a specific group in a survey (e.g. ignore Status dimension) regardless if the user is slicing the data by Status or not

Thanks again - wgpubs


Answer this question

How to ignore a dimension in MDX?

  • c4210

    tried this ... but if I include the ResponseStatus dimension in my slicer it still filters on ResponseStatus.

    In my slicer I got survey, group and response status ... the kind of report I'm trying to generate in SSRS needs to looks something like this:

    Survey Group Count OverallCount


    ... where Count should use the ResponseStatus dimension (so that users can filter out certain statuses and what not thru a RS parameter) while OverallCount should not.




  • ennisb

    Try this ("ignoring" the status dimension - your exact naming may differ):

    CREATE MEMBER CURRENTCUBE.MyCount AS

    '([Status].[StatusID].[All StatusID],[Measures].[GroupCount])';



  • ST2B

    My suggestion should work, if I understand you correctly. Please post your exact MDX query.

  • Richard Hathaway

    Yah I thought it would too ... but no go. here is the query:

    CREATE MEMBER CURRENTCUBE.[MEASURES].[Overall Group Count]
    AS ([Response Status].[Response Status].[All], [Measures].[Group Count]),
    VISIBLE = 1 ;


  • How to ignore a dimension in MDX?
Answer this question