Testimonials

What our customers are saying

"You're the best I have."


- D. Barton, Global Oracle Consulting Firm

about us

Service Delivery

Multiple ways to access M&S

M&S offers technology and process solutions through multiple offerings and vehicles. End-to-end solutions, training and mentoring, staffing, ongoing support.

read more

Effective and Efficient

Exceptional Results

M&S today reflects a rare combination of out-of-the-box thinkers, deep business acumen, enterprise architectural design/engineering, and software prowess.

contact us

From the M&S Blog...

First and Last Day of Month – Oracle SQL Syntax Examples

Posted on Sep 10, 2010 in Technical Tips | 0 comments

First Day of Current Month

1

SELECT trunc(sysdate) - (to_number(to_char(sysdate,'DD')) - 1) FROM dual

Last Day of Current Month

1

SELECT add_months(trunc(sysdate) - (to_number(to_char(sysdate,'DD')) - 1), 1) -1 FROM dual

OBIEE for the iPhone

Posted on Aug 12, 2009 in Industry Trends, Technical Tips | 1 comment

We recently had a customer request help with configuring OBIEE for use on both PCs and mobile devices (specifically, the iPhone). Of course, this is possible, but Oracle does not have a clearly documented approach. You might think that a separate server is required to accomplish this. However, the fact is that you can actually use a single server to deliver OBIEE reports for both PCs and the iPhone.

For those interested, following is a link to the Oracle OBIEE Indicators iPhone Demo:

obiee-iphone

Please browse our OBIEE Consulting Services

This article is part of the recent work short blurb series.