OTBI in general only gives you the current row data unless it is based on Events like Assignment Event Real Time Subject Area. So this either has to be a Event type Subject Area or best is to have a Dedicated Table created and then individuals can build a BI report as per there needs and that is if a seeded report is not…

I know that for some big customers they do arrange a Read Only SQL utility (something which requires security authentication and GoldenGate setups....). Also, most probably Oracle Support team members has access to query directly.

Please check attached document.

There is an alternative if we build a Report from Analysis, then one can password protect PDF and EXCEL o/p. Kind Regards Ashish

It would be great to have this kind of info.

This would be very useful. Has been an ask for long time now. Kind Regards Ashish

Well one can always use the auto-generated template in that case and make changes. I mean , I can understand that one option could be that all columns of a data model is selected and then the report owner (developer / creator) can remove the ones not required, but sometimes the number of columns are so large that…

Not sure if this report (below) meets the requirement completely but maybe would give some insights. Have a look: https://apps2fusion.com/oracle-fusion-online-training/fusion-applications/fusion-payroll/2336-bi-catalog-component-audit-report-a-custom-report-to-identify-bip-report-execution-details Kind Regards Ashish

Agreed! +1 Kind Regards Ashish

There used to be an option of auto-generate layout which would map all columns in same sequence automatically and if some one chooses excel as the default output then one will get report data in excel. However, in Release 12 i found that autogenerate option takes a lot of time and doesn't works sometimes Kind Regards…

Yes it took a lot of time to figure out workarounds. A simple straightforward solution would be really great. Kind Regards Ashish

hmmm. Cloud also has its own set of limitation. I mean it is a surprise that organizations wont implement HCM Cloud only because this feature is not there. Alternatively, you may use the SQL Builder option too. Note: My personal opinion.

Yes you may choose the language as SQL and try to paste the code in Textpad and Notepad++ and you should be good.

Wow. Do you have a worked out example you can share. Kind Regards Ashish

Please check this post ( this should take care of some of the fields and probably provide you a direction too): https://cloudcustomerconnect.oracle.com/posts/de43145427 Hope this helps! Kind Regards Ashish

Please check below link: https://cloudcustomerconnect.oracle.com/posts/a9ee75411c I have posted your Analysis XML there so you may post messages there Kind Regards Ashish

I tried running this and I could not find the Pivot Option.

Seems you have passed on the XML Data. I am looking for the XML Analysis (on Advanced Tab) On Advanced Tab under XML you would find corresponding XML version of the query which gets generated as a result of the OTBI Report created. Copy that same (save it in text file and send)

Please post your XML

Have you tried the pivot option suggestion mentioned in below link: https://cloudcustomerconnect.oracle.com/posts/a9ee75411c May you post the XML used and this screen-shot on above link Kind Regards Ashish