February 26, 2013 at 2:21 pm
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
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?
Lowell
February 26, 2013 at 3:02 pm
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