About the author

Kalyan Chukkapalli

Kalyan Chukkapalli

I am Kalyan Chukapalli, an independent contractor in United Kingdom. I've 12+ years of experience working with Oracle technologies. I started my career as a Oracle Developer (Forms/Reports), then moved to E-Business Suite. My current interests are Business Intelligence and DWH. For the last 6 years I have been working on OBIEE, BI Apps, OWB, Informatica, ODI and E-Business Suite. From this blog, I would like to share my experiences on OBIEE with you and any kind of feedback would be highly appreciated. All the views expressed here are my own and does not reflect the views of my employers or colleagues.

2 Comments

  1. 1

    Fatso

    Hi Kalyan,
    Thanks for this helpful solution. However the code will error out in obiee because of the sing quotes. If copied and pasted the single quotes will need to be physically replaced and new ones put in, I suspect obiee just renders the single qoutes differently. Below is a slightly modified version of your code.

    right(‘0’||CAST(cast(FLOOR(4000/3600) as int) AS VARCHAR(4)),2) ||’:’||
    ‘0’||right(CAST(cast(FLOOR(MOD(4000 , 3600 )/60) as int) AS VARCHAR(4)),2) ||’:’||
    right(‘0’||CAST(cast(MOD(4000 , 60) as int) AS VARCHAR(4)),2)

    Thanks

    Fatso

    Reply
  2. 2

    Vincent

    Thanks a lot, i made an ajustement to display or not day:

    CASE WHEN (“Service Request Facts”.”delai#1″ > 86400)
    THEN
    (

    CAST(CAST(CAST(FLOOR(“Service Request Facts”.”delai#1″ / 86400 ) AS VARCHAR(4)) AS INTEGER) AS VARCHAR(4))

    || ‘ jours ‘ ||
    RIGHT(‘0’||CAST(CAST(CAST(FLOOR(MOD(“Service Request Facts”.”delai#1″ , 86400 ) / 3600) AS VARCHAR(4)) AS INTEGER) AS VARCHAR(4)) , 2) ||’:’||
    RIGHT(‘0’||CAST(CAST(CAST(FLOOR(MOD(“Service Request Facts”.”delai#1″ , 3600 ) / 60) AS VARCHAR(4)) AS INTEGER) AS VARCHAR(4)) , 2) ||’:’||
    RIGHT(‘0’||CAST(CAST(CAST(MOD(“Service Request Facts”.”delai#1″ , 60) AS VARCHAR(4)) AS INTEGER) AS VARCHAR(4)), 2)

    )

    ELSE ( RIGHT(‘0’||CAST(CAST(CAST(FLOOR(MOD(“Service Request Facts”.”delai#1″ , 86400 ) / 3600) AS VARCHAR(4)) AS INTEGER) AS VARCHAR(4)) , 2) ||’:’|| RIGHT(‘0’||CAST(CAST(CAST(FLOOR(MOD(“Service Request Facts”.”delai#1″ , 3600 ) / 60) AS VARCHAR(4)) AS INTEGER) AS VARCHAR(4)) , 2) ||’:’|| RIGHT(‘0’||CAST(CAST(CAST(MOD(“Service Request Facts”.”delai#1″ , 60) AS VARCHAR(4)) AS INTEGER) AS VARCHAR(4)), 2) ) END

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *


*

2014 Powered By Wordpress, Goodnews Theme By Momizat Team