Thanks Kevin, that was helpful, we will explore the FTP route for delivering encrypted BIP reports.

Thanks Kevin, I see the PDF output has option for encryption, we are using excel output, is there a way to apply/extend the encryption on excel output of the BI Publisher report ?

Hi Riyaz, so it worked, we got the output as URL, but this setting will affect the delivery across the board for all jobs, though it is preferable than attachment but needs buy-in from leadership & communication to user groups, before enforcing the change.

Thanks Riyaz, we have tried all options to reduce the size of the report. We found an option that we were looking for at xmlpserver : Administration > Delivery: Delivery Configuration > Email Output as URL, applied that and testing to see if that delivers the output as URL (as oppose to compressed file).

Thanks Gianni, I can use three agents (as I already have three reports listing one email id each, I can use them for recipients for the three agents). Thanks again, much appreciated.

Thanks Gianni, (sorry for responding late, was working on logistics for testing as the alert in non-prod env, as it is flagging ~50k records identifying ~800 email recipients). Anyway, so I have the report (to be sent out) and it has last three columns as 'X Email ID', 'X Email ID', 'Z Email ID' (such as for director,…

Thanks Christian for your attention, we are using regular OAS 7.0 analytics report running off of a subject area (not BI Publisher or Direct Database Query or Ext Data source based report). And we are trying to create an agent for this report. Thanks RAM, as this column (with email Ids or rather a report based on this…

Thanks Gianni, we will examine the schedular tables by creating a test agent and make changes to it to see the effects on the tables and accordingly rehears the updates in lower environment after taking backups, BAR export, OAS shutdown. Thanks again, much appreciated.

Thanks Gianni, DV>Content Management and Change ownership method won't be efficient for us as we have over 7k users which are no longer with company, so we are going updating BIPLATFORM table route. As it is unsupported activity, what would be the safest way to stop these obsolete agent from running ? Set the 'DELET_FLG'…

Thanks Gianni, TOPN("your table"."lead_rank", 1 by "your table"."department") approach worked, the example you provided was very helpful, thanks again.

Thanks Gianni, I tried the solution you suggested, the function allowed in OAS report is TopN(expr, integer) or BottomN(expr, integer) and does not loop though records for each department. So what it does is returns all rank 1 records and drops the department where lead_rank is not 1 (i.e. departments headed by lower level…

Thanks for responding, we have OAS7.0, OBIA7.6.4, EBS12.2 and we don't want to go BI Publisher route for this report as all the attributes are in one subject area. We have added a derived column as lead_rank populating 4 for VP, 3 for Director, 2 for Mgr and 1 for null. Now we just want to filter one record for each…

Thanks Gianni, I will have this approach with changing ownership, tested out and let you know.

we are using OAS 5.9, it is a varchar150 datatype containing YYYY/MM/DD HH:MM:SS at the source. It is being converted to date as CAST (LEFT ("XYZ Date",10) AS DATE) in the analysis, in the session log it comes as : cast(substr(XYZ Date , 1, 10) as DATE ) and errors out for ORA-01861: literal does not match format string.

This resulted in from running the migration utility to convert 11g artifacts to 12c, the pivot tables are still normal in 11g instance, no other changes, or any custom style/skin were applied to the catalogs.