I actually got confirmation a couple months ago (after the SR ran for over a year) that this functionality is not currently in the application. We're using Fusion, currently on 23D.

How does this have only 2 votes with so many comments? Very much needed to add this feature to the application. The current way of combining subject areas inside the application is way too volatile and error-prone and the logical sql combiner is not suitable for 'regular' users in my experience.

We'd like to have this implemented as well. This saves clicks by analysts and development time. My current workaroudn is to add a static part to the report with the URL of the report. Analysts will click it to go to the report online, apply filters to the report if necessary and then they can use the deeplink.

We would like to have this field included so that we can do health checks before sending out big payment batches and prevent any errors downstream.

@User_FX4J2 It is attached to the Knowledge base item that's mentioned in the update: Oracle Fusion Transactional Business Intelligence and BI Cloud Connector Performance Recommendations (Doc ID 2679006.1)…

We need tools to automate our backups for our entire Reporting suite. ERP and HCM and anything to come.

Read the update on this status as: We're not going to implement this, so just hit them with a 40+ page pdf file.

Hi Jessica, From your requirements, I read that you want to use the advanced SQL in Agent prompts. This is also something our business requires.We need to be able to schedule a report based on the SYSDATE (e.g. end of current month). Currently, we're forced to run a dashboard manually every week - as it is possible to…

If not within the UI, at least let us schedule the reports to exceed the limits - same as with regular BI Publisher reports which exceed their limits.

Hi Joshua, This might be too little too late, but did you find this: Access To SOA BPM Tables In BI Publisher (Doc ID 2275088.1) Hope this helps you. I'm also looking for relevant OBIEE subject areas, as opposed to pulling from SQL. I cannot find them and there's also no idea yet, so I've created one:…

This would help us create queries way more easily and without errors. Current options are only to write in Notepad with no system help / validation whatsover. Would prefer not only HCM but all of Oracle's suites to be added.

Hi Paola, Direct Database Query reports bypass any data access rules. This might be a solution for you in this case, although I do understand that it can be inconvenient as you'd have to create / maintain a new report. Kind regards, Maarten

Still have this requirement. Is there anyone that has a solution for this?

Hi Noelle, Tested running this as another user, but it is still delivered to me as my user is defined in Run as specified user. I would want the condition analysis to be run as the logged in user and not mine. I found this document https://docs.oracle.com/cd/E15586_01/fusionapps.1111/e20836/variables.htm#BABCCIAB. It also…

Hi Matt, Are you able to connect to the cloud application with SQL Developer? Or have you loaded the schemas manually? Is there anything you can share on how you've set this up? Kind regards, Maarten

Hi Wade, That looks quite neat. I don't have any Python experience but I can at least read some code. Would this be easy to set up? I'd use this mostly to see whether my query even executes and if it does, get ~ 100-200 lines of data to see whether the data I've gotten makes any sense at all. This solution would definitely…

Above solution works if you have two separate analysis. Is it possible to use an action link to a different view (including the passing of parameters to prompt) within the same analysis, in a dashboard? My use case is same as OP, I have an analysis with two views. One is the pivot and other is the detailed view. I want…

Thanks for your input Jon, but unfortunately not the solution yet. Also missing the IN after the NOT statement ;) Kind regards, Maarten

Thanks for your input Jon, but unfortunately not the solution yet. Also missing the IN after the NOT statement ;) Kind regards, Maarten

Hi Ashu, I do not understand. Where should I put this code? Kind regards, Maarten