Return results with "missing" members

Last Post 13 May 2005 06:25 AM by cacrawford. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
cacrawford
New Member
New Member

--
13 May 2005 06:25 AM
I have a cube with two dimensions, and I'm querying the intersection of a single level in each dimension like this:

SELECT {[Measures].[My Measure]} ON COLUMNS,
{DESCENDANTS([Dimension1].[Level1], Level)} on ROWS,
{DESCENDANTS([Dimension2].[Level2], Level)} on PAGES
FROM MyCube

It works great and returns almost what I'm looking for. I get back something like this:
MemberA Member1 Value
MemberA Member2 Value
MemberA Member3 Value
MemberB Member1 Value
MemberB Member2 Value
MemberB Member3 Value
.... etc...

I would like to add a single item that shows how many items were part of the set MemberA, but not in any of Member1, member2 or member3, sort of like this:

MemberA Member1 Value
MemberA Member2 Value
MemberA Member3 Value
MemberA NotInAnyOfTheAbove Value

I've been reading and searching and I'm pretty sure it can be done, I'm just not able to put it together. Can anyone give me a push in the right direction?

Thanks!


Acceptable Use Policy
---