Pivote future is available in OTBI

vijay salve-151928

Summary

Pivote future is available in OTBI

Content

Hi All,ecause of 

I have the requirement to develop the exit clearance report using OTBI.In Current case i am getting 10 rows for 1 employee because of 10 task & task status.

I want output in single row. So pivote functionality is available in OTBI or not. If yes Please help.

Regards,

vijay

Version

19A

SantoshKumarBhairi

Hi Vijay, 

OTBI has all the functionality of regular OBIEE 11.1.1.9 version. So pivot is available too.

Thanks,

Santosh

vijay salve-151928

Thanks santosh for replay. Do you have any sample code for same. Please share

SantoshKumarBhairi

hi Vijay, I am afraid I dont have but can you search under 'Reporting Sharing Center' (https://cloudcustomerconnect.oracle.com/resources/dd487d65f8/summary)?

 

vijay salve-151928

will it be possible to use case statement in OTBI Report. If yes please share the syntax  

SantoshKumarBhairi

Yes. As I mentioned earlier, all features and functionalities of OBIEE are available within OTBI. I would suggest you to search for it - you will get umpteen results.