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!

conversion of minutes into hours obiee 10g

prassuJun 13 2013 — edited Jun 14 2013

hello,

i have a requirement saying that we need to convert the minutes to hours later aggregate the hour values.

i.e.,i have the outage_time=130 mins.If i try to convert the 130 mins to hrs it will be 2.16 hrs but i am expecting 2.10 hrs.And later need to aggregate(SUM) the hrs values like 2.34,2.45....=4.79 but my expectation is 5.19 hrs.

Is this requirement is possible?if yes,can anyone please help me out.

thanks,

prasanna

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 12 2013

Added on Jun 13 2013

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

8 comments

1,124 views