Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi @Azul250, We use this technique extensively in our dashboard and report prompts, as we have multiple Legal Entities and BU's in the same Fusion instance. As Bhaskar said in the note above, you would use SQL in the Column Prompt. In the screenshot below I have used it to select the BU for the Default Selection, but you…
-
Hi Pretti, It looks to be a simple conditional colouring, for example if the value in the segment is >=95% then its green, if it's between x% and 95% then it's amber/yellow.
-
Hi Alan, I have similar requirements for DBS Checks and Work Permits, but I use RANK instead of MAX. I have a calculated column called 'Rank of Renewal Date' with the following formula: RANK("Workforce Management - Documents of Record Real Time"."Document of Record Details"."PER_DOCUMENTS_OF_RECORD_DFF_RENEWAL_DATE_" BY…
-
Hi Oriana L. Yes that's correct, though when I now look at extracts taken this time last year they show the black cells in the first column only. I'm not aware of any settings that can be changed I'm afraid. Hopefully your SR may shed some light on the issue. Good luck, Richard.
-
Hi @Oriana L. Interestingly I also get this on heatmaps in the OTL subject area when tracking claimed hours per week. I had assumed it was an issue with excel as when I used to export the heat map to a version of excel pre 365 it was fine, but since we moved to Office 365 the issue started occurring. However, we only get…
-
Hi Claudia, This would go in your Filter. See my example below:
-
Hi Claudia, Glad it worked. Getting data out of our employees for things like Qualification Start Date is always an issue as sometimes they can't remember and leave it blank. You may want to add an OR statement in your filter, so something like: RANK("Workforce Profiles - Person Profile Real Time"."- Degrees"."Start Date"…
-
Hi Claudia, This will work for you if you apply the rank formula to your fields. I was giving an example of how I use it with Document of Records. So in your case, you would add a second column for Degree Start Date, then edit the Formula to something like : RANK("Workforce Profiles - Person Profile Real Time"."-…
-
Hi Claudia, Try using a RANK BY PersonNumber on the start date field then filter to select the First Ranked row. However, this will not work if you have two qualifications with the same start date should you have these type of scenarios I use the RANK By to select the latest DBS Check recorded in Document of Records as…
-
Hi Sushant, It could be you need to filter for the particular Role responsible for the Task. There are 3 Roles (Manager, Employee, Participant). When I want to report on Performance Task Status, I specify the Role. See Screenshot below. In your case you would need to specify the Role as Employee.
-
As Bharat mentioned, setting permissions at the Folder level is much more efficient. It becomes an administrative nightmare trying to manage individual report permissions, especially when migrating catalogs between environments. An alternative option is to create a Dashboard with links to individual reports. You can…
-
Hi Scott, We've experienced exactly the same issue when trying to use the facts in the Workforce Trend Real Time Subject Area. The facts are based around the Effective Start Date of the employee's assignment for the entry after their termination - see screenshot below as an example. This example assignment is counted as an…
-
Hi JobDeLuna, Would the following work: (("Time"."Date" > (TIMESTAMPADD(SQL_TSI_MONTH, -12,TIMESTAMPADD( SQL_TSI_DAY , -1, TIMESTAMPADD(SQL_TSI_MONTH, 0, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE)))))) AND ("Time"."Date" <= (TIMESTAMPADD( SQL_TSI_DAY , -1, TIMESTAMPADD( SQL_TSI_MONTH ,…
-
Hi, I have created just such a report using "Workforce Management - Worker Assignment Real Time" subject area, as Praveen mentioned above. See attached XML. You will need to remove some of the fixed values in the filters to run with your data.
-
Hi Helen, No problem. I've even used Logical SQL in the prompt SQL Results field to retrieve a default value. It's an easy way to control the values available to the report users.
-
Hello Helen, We do this for our common reports where we want to limit the data for a particular user based their BU. The easiest way is to set a report prompt and then in that prompt you select the Default BU to be retrieved based on the users Session Username. I use the following SQL: SELECT "Business Unit"."Business Unit…
-
This would allow us to rapidly identify fields which may be impacted by a Quarterly Release change. It would also allow us to identify fields being used which need modification e.g. through the use of formulas, or removing and replacing with a different field. Our dashboards may be built up with hundreds of individual…