Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to compute a single bit wise operator in MDX Expand / Collapse
Author
Message
Posted Tuesday, February 26, 2013 2:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 10, 2013 6:51 PM
Points: 4, Visits: 65
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
Posted Tuesday, February 26, 2013 2:49 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:22 PM
Points: 12,889, Visits: 31,839
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
Posted Tuesday, February 26, 2013 3:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 10, 2013 6:51 PM
Points: 4, Visits: 65
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 »

Add to briefcase

Permissions Expand / Collapse