How to compute a single bit wise operator in MDX

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » How to compute a single bit wise operator in...

How to compute a single bit wise operator in MDX

Rate Topic

Display Mode

Topic Options

Author

Message

madamcurie2005

Posted Tuesday, February 26, 2013 2:21 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 26, 2013 3:31 PM
Points: 4, Visits: 61

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

Post #1424246

Lowell

Posted Tuesday, February 26, 2013 2:49 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 11:58 AM
Points: 11,605, Visits: 27,644

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1424256

madamcurie2005

Posted Tuesday, February 26, 2013 3:02 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 26, 2013 3:31 PM
Points: 4, Visits: 61

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

Post #1424260

« Prev Topic | Next Topic »

Permissions