SQLServerCentral.com / Analysis Services / Data Warehousing / How to compute a single bit wise operator in MDX / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 23:02:59 GMT20RE: How to compute a single bit wise operator in MDXhttp://www.sqlservercentral.com/Forums/Topic1424246-17-1.aspxThanks 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-SarahTue, 26 Feb 2013 15:02:23 GMTmadamcurie2005RE: How to compute a single bit wise operator in MDXhttp://www.sqlservercentral.com/Forums/Topic1424246-17-1.aspxMDX is nothing i've played with, but my google fu pointed me here:[url]http://www.google.com/search?q=mdx+bitwise+operations[/url]and that seems to say you've got to add some .net toys? because MDX does not do bitwise operations at all?[url]http://sqlblog.com/blogs/mosha/archive/2007/09/26/how-to-detect-subselect-inside-mdx-calculations-aka-multiselect-in-excel-2007.aspx[/url]Tue, 26 Feb 2013 14:49:18 GMTLowellHow to compute a single bit wise operator in MDXhttp://www.sqlservercentral.com/Forums/Topic1424246-17-1.aspxIn SQL I have a query like this Select power (hourofday,2) & 9 from table 1In MDXI 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 SQLSelect (hourofday^2) &.... this doesnt workon columns,date on rowsfrom aggregatorAlso results form & are not similar to && as && returns only true or false.I want bit wise computation.Please helpThanks-SarahTue, 26 Feb 2013 14:21:15 GMTmadamcurie2005