Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using Trunc Function in OBIEE RPD to TRIM DATE

SYedururMay 22 2013 — edited May 22 2013

Below is my requirment.How can i achieve this in BMM layer.

CASE WHEN TRUNC(REPORTDATE) <= TRUNC(SYSDATE-2) THEN 1 ELSE 0 END

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 19 2013

Added on May 22 2013

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

1 comment

2,141 views