Post reply

How to compute a single bit wise operator in MDX

  • February 26, 2013 at 2:21 pm

    #147589

    In SQL I have a query like this

    Select power (hourofday,2) & 9 from table 1

    In MDX

    I found the function to do the power which is ^ but I couldnt find the single bit operator.

    Can someone please help me how to compute and get exact same results from mdx for an equaviltent query in SQL

    Select (hourofday^2) &.... this doesnt work

    on columns,

    date on rows

    from aggregator

    Also results form & are not similar to && as && returns only true or false.

    I want bit wise computation.

    Please help

    Thanks

    -Sarah

  • February 26, 2013 at 2:49 pm

    #1591321

    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!

  • February 26, 2013 at 3:02 pm

    #1591325

    Thanks Lowell for your help on this. Yes... google doesnt show much.

    The second link that you sent. I have seen it but I am lost. I am new with MDX and just have no idea where to even start from when it comes to adding new "toys" to get this done 🙂

    Need some help in getting started on that article.

    Look forward to your reply.

    Thanks

    -Sarah

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply