Hi Chris, Please review all the subject areas in HCM and verify which one suffices your requirment. If you want to verify which subject area contains a particular physical database column for OTBI reporting, then you may please refer to the data lineage document that contains OTBI Columns to Physical Column mappings Hope…

Hi RK, Please check the below : http://jde.suanfarma.com:9704/xmlpserver/help/en/htmfiles/bipoh/create_lay_tmpl.htm#pivot_table_le Hope it helps Regards Wasim

Hi Shiva, Automatic backup of catalog objects is not supported out of the box. Please note that taking a backup of the whole catalog is not advisable as it would slow down the process when archiving all the objects. Imagine some developers making changes to a few catalog objects when the archive is taken. As per the best…

Hi Vibha, Thanks for the update. You will not be able to Zip the output file in OTBI. This it not supported out of the box. Also FYI, there is no need to Zip the output file from the security point of view because any email going out of the Oracle CNS server will be encoded hence secure. Hope it helps Regards Wasim

Hi Vibha, By Default you will not be able to hide the options that come beneath the OTBI analysis. Once you place it on a dashboard as per the Oracle Best Practices, you can control a lot of settings that you won't be able to do on an analysis. This is a solution workaround for your requirment. Hope it helps you.

Hi Vibha, IN such cases, i would suggest you to review the datalineage document for the subject area to verify which physical table contains the respected column and you can then go ahead and create a custom BI Publisher report to suffice your requirment. Hope it helps you Regrds Wasim

Hi Vibha, Could you please share more details about your requirment so that we can review and see if there is any alternate workaround? Thanks Wasim

Hi Vibha, Please place your OTBI analysis on a Dashboard Edit the dashboard - the dashboard will be opened in an edited mode. Hope you have placed the OTBI report in a section and that section in a column in a dashboard. Click on xyz on the report - click on report links Here you can Select all the options that you want…

Hi Thanigainathan, You can create multiple sheets in same excel file to get more than 65000 rows . The following Note gives example on how to create such excel template : Note 1352000.1 : BI Publisher: How to create Multisheet in Single Excel file using Excel Template. Hope it helps you. Thanks

hcm-reports.xls Please find attached Excel doc displaying all the prebuild reports in HCM. This includes Analysis, Dashboards, Subject Areas and BI Publisher reports. Hope it helps. Thanks Wasim