+ Reply to Thread
Results 1 to 3 of 3

Excluding Single Member from CUBEVALUE using Curly Brackets

  1. #1
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Excluding Single Member from CUBEVALUE using Curly Brackets

    Anyone remember the syntax for excluding a single member from a CUBEVALUE without having to build a cubeset with every member but one? If I remember correctly, it involves the use of curly brackets and is something like this:
    =CUBEVALUE(CONNECTION,MEASURE,{-TUPLETOEXCLUDE})

    There was an article about this in one of the MS forums but I can't find it...


    ---------- Post added at 04:43 PM ---------- Previous post was at 04:39 PM ----------

    Further information (sorry) ... this is possible without having to use the Except MDX function....
    If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
    Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...

    Thomas Lafferty
    Analyst/Programmer

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Excluding Single Member from CUBEVALUE using Curly Brackets

    Perhaps this is what you are looking for..

    http://social.msdn.microsoft.com/For...b-182eb07de11c
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Re: Excluding Single Member from CUBEVALUE using Curly Brackets

    That should do the trick... there was one particular article from that forum which was crystal clear. What were you using for search criteria?

    ---------- Post added at 04:58 PM ---------- Previous post was at 04:51 PM ----------

    This was it...http://social.msdn.microsoft.com/For...7-a3745c460f7c

    Thanks for your help, it pointed me in the right direction...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1