In SQL I have a query like this
Select power (hourofday,2) & 9 from table 1
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
date on rows
Also results form & are not similar to && as && returns only true or false.
I want bit wise computation.