Hi Prudence, I think you have used = operator in he data model SQL.. change it to IN operator and it should work. On the second query, there is no option to set the default o/p type globally and moreover the o/p options depend on the template that has been uploaded, there are different o/p options for diff templates rtf,…

Hi Helen, Please refer to the below thread for similar kind of info. https://cloudcustomerconnect.oracle.com/posts/d8b5455320 The requested details are not available in Fusion_HCM schema, so you need to configure BIAudit as data source and then query those tables to get these details. SM

Hi Tito, In such case, you can use the Logical SQL to modify the OTBI analysis to get the meaning by joining the tables. Please refer to the below thread for more info on Logical SQL: https://cloudcustomerconnect.oracle.com/posts/be69d9f14b…

ok sure.. no issues. 

There should be an option to mark the answer as correct.. so you can click that to the comment which answered your question and resolved your issue.

That's great.. Please mark this thread as complete so that it will be helpful for others.

Hi Rebekah, You can ignore my earlier comment. I searched for this info on Oracle Support and looks like this feature is available from BI Publisher Version 5.6.3 Please refer to Doc ID 1112344.1 In the from email PARAMETER3, please mention the email id as "Anthem Human Resources <***@***.com>" Thanks, Sricharan

As far as I know we cannot mention any alias while setting up the bursting sql to change the alias of from email address. Let's wait for reviews from reporting experts. * Sricharan

This can be done using bursting feature only. There is no other go on it. - Sricharan

Hi Ramesh, If you are asking about report having multiple layouts and then the user wants to select the layout and run it, then we can use the bursting feature for it and dynamically pass the layout as input parameter and then deliver the file to ftp/email by creating dummy bursting key. Let me know if you need any help in…

okay cool.. good that the issue is resolved.

I think it can be done by creating new role. I will check with the security team and get back.

Hi Rajmohan, Did you try the detail report directly for that UNION and were you able to get the output? Also did you setup the site as prompted in the detail report? Thanks, Sricharan

Are you asking that if there are multiple report layouts for a report, you want to choose the report layout dynamically and run the report?