Skip to Main Content
Forums

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!

Trunc Function OBIEE

sliderrulesOct 14 2014 — edited Oct 24 2014

Hi,

Is there an OBIEE function that can be used in place of TRUNC, see physical SQL below:

(TRUNC(END_TIME) *60 + (END_TIME - TRUNC(END_TIME))*100) - (TRUNC(START_TIME)*60 + (START_TIME - TRUNC(START_TIME))*100) TIME_DIFF_MINS

TO_CHAR(TRUNC(TIME_DIFF_MINS/60) + ( (TIME_DIFF_MINS/60 - (TRUNC(TIME_DIFF_MINS/60))) *60/100 ), 'FM00.00') TIME_DIFF

I have tried CAST as number in place of TRUNC but that is returning an error in OBIEE answers.

I am using OBIEE 10.1.3.4
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2014
Added on Oct 14 2014
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
6 comments
1,790 views