Hey Eric, It does not execute queries directly against the database per se. But like the other tools that exist, it uses the BI web services to proxy the query through. I personally wouldn't recommend doing a large dataset like this query, but it will work. It just takes a while before returning data with this large of a…

I wrote a quick plugin for Sublime Text 3 (it will format and execute queries). So if anyone is using ST3 and has some Python 3 familiarity and wants to give it a go, I would be willing to share what I did.

Adding onto Stephanie's comment. I use this method when I need to troubleshoot something fast and it works well too. You will find that you can filter on any attribute of the analysis, but make sure to use ID (not number) where possible. Otherwise report performance can take a hit - it's a database thing...

Thanks! It's been mine since birth =) That's correct. We do the same thing for goals.

Hey Scott - one can also use the set operators, specifically difference (you take the full population minus those who exist with something). Here's an Oracle tutorial of union: https://www.youtube.com/watch?v=li_W-jBTSpo&index=22&list=PLKCk3OyNwIzsdkAOBq_dRtUQW_X8k8l53. Difference is very similar.

That's OAC. I'm sure Prudence was asking about her HR cloud which is a different product/version...

Gianni, we are on HCM Cloud, so I'm not sure if our BI instance will work with runcat. It looks promising. I have been trying to get the client tools installed on my Windows VM, but running into issues - the catalog manager just won't start - but the Admin tool will. Different issues on my Linux VM. I admit, I've wasted…

That's true. You are giving me something else to consider. One could just save off the entire top-level catalogObject, which would include ACL, owner, etc.

Thanks for confirming, Gianni! I had looked at this method previously, but missed the second '<sawsoap:catalogObject>' tag. SOAPUI displays the entirety of the XML payload on 1 line only, so I didn't realize that was what I needed. Cheers.

Manisha, are you able to view goal data without the Review Period column?

Hi - just talked to Julian at the Oracle CAB. He mentioned that I should create an idea, so please vote so we can attempt to get this functionality back.

Yup - the subject areas are riddled with issues and instability. In some cases, by the time my SRs are created and an OWC is ready, it just starts magically working. We've been replacing with SQL reports where possible.

Are the fields dates or timestamps? Either way, you should be able to use TIMESTAMPDIFF and some CASE statement. Pseudocode below: TIMESTAMPDIFF(SQL_TSI_DAY, TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE),TIMESTAMPADD(SQL_TSI_DAY, 0, CURRENT_DATE)) ... CASE when (above formula >= 0) then date on right of method ELSE date on…

Manisha, I've had this happen once before. I rebuilt the analytic and it started to work again. Or you can create a copy of your current analytic and remove fields until it starts working again (to find the offending field). If you added Person Email, you may need to filter on Email type as well.

Hey Manisha - have you added a fact from each subject area?

Hi Rohini, We don't have a great solution (imo), but we have a solution that works. I ended up using Nagios and Fusion SOAP Web Services to monitor our critical processes, extracts, and reports. The following WS are in use: * ReportService v2 * ScheduleService v2 I looked at using esswebservice for the ESS processes, but…

Hi, Here is a simple example with a pivot table using count on person number. You'll need to adjust the person number filters in the criteria tab. https://github.com/dbldub/oracle-hcm/raw/master/customer-connect/a9b94f4762/pivot-example.xml In the pivot table view, I edited the table and moved the count to the 'measure'…

Hi - are you using regular table or a pivot table? I recall having similar issues at one time and believe I resolved it somehow with a pivot.

Hey Alvaro, Yes, you will need to do this in the data model SQL. https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions191.htm

Hey Alvaro, Maybe check your data format. If it's alpha, the system won't be able to perform numeric operations. You'll be able to quickly tell by the icon under the data source section. Please see attached image. Thanks.