• MDX is nothing i've played with, but my google fu pointed me here:

    http://www.google.com/search?q=mdx+bitwise+operations

    and that seems to say you've got to add some .net toys? because MDX does not do bitwise operations at all?

    http://sqlblog.com/blogs/mosha/archive/2007/09/26/how-to-detect-subselect-inside-mdx-calculations-aka-multiselect-in-excel-2007.aspx

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!