Hi N3FKO, Assume you may refer to field "Department" on an employee or contingent worker or pending worker or nonworker in HCM. In global header select Navigator, select Show More, in Me select work area Personal Information, select Employment Information. Expand section Assignment. View field Department? Here is the sql…

Hi, Assume this is for either 1) an analysis in OTBI 2) a report in OTBI with a data model with a data set type sql query with data source Oracle BI EE or data set type analysis that reference path to analysis in 1). HCM does have data roles. But because you said Business Unit then I will assume this is a subject area in…

Hi, It is not possible to deny something that is already denied. So ALL subject areas are already "denied" from BI Author Role. That is "denied" meaning that if you issue sql to query from that subject area, for example by open an analysis, you are denied by the system throwing database connection error. To understand this…

Hi, No problem. So you question is actually the classic when I build my analysis by picking attributes and measures from multiple subject areas how do we get the metadata repository database (RPD) data model to generate "good" physical SQL with the correct joins between the application tables and views so that we get the…

Hi Kauan, "Due Date" is not a calculated field. It is a data entry field entered into the system using a date picker when you save and close the payment schedule on the one or more instalment(s) on a receivables transaction. The default value may get calculated but you as a receivables specialist may add instalments and…

Hi, That is already how it is setup out of the box. Role BI Consumer does not have access to any subject areas. Role BI Author does not have access to any subject areas. If you create a custom role just with either of these roles you do not get access to any subject areas to execute a query. The subject areas that are…

Hi, Try the subject areas for Recruiting in Talent Management. Oracle Fusion Cloud Applications Content https://docs.oracle.com/en/cloud/saas/otbi/fa-index.html Oracle Fusion Cloud HCM Subject Areas for Transactional Business Intelligence in HCM G12536-01 24D…

Hi, Yes a receivables transaction does not have a due date but many dues date for each of its installment(s) so you can only have like an earliest or latest due date on the header transaction itself. As you say due date is an attribute of the child instalment, also known as, payment schedule. Then a transaction may also…

Hi, As per the user guide for subject area Workforce Performance - Performance Check-In Real Time Oracle Fusion Cloud HCM Subject Areas for Transactional Business Intelligence in HCM G12536-01 24D…

Hi, Yes this list of analytics and reports is on your documents https://docs.oracle.com/en/cloud/saas/otbi/fa-index.html For each "application" select link "Prebuilt analyses and reports" For example HCM https://www.oracle.com/docs/tech/hcm-reports.xls

Hi Faisal, For this use case you can perhaps as suggested by Praveen use the general ledger balances (cube) subject area or more detailed transactional balances subject area in OTBI.…

Hi, Yes you can do that. Whether a subject area is included in the list of values on create analysis is managed by role. As bi administrator go to page manage privileges /analytics/saw.dll?PrivilegeAdmin. Near the bottom are the roles that can select a subject area in the list of subject areas privilege "Access with…

Alternative you can edit the properties of the pivot table to "include columns with null values"

Hi, OK. So you agree that this issue has nothing at all to do with the mode you consume the analysis. If you edit the analysis view results tab or open a dashboard page with the analysis you get exactly the same results displayed in both cases if you use the same date range of 7 days YYYY-10-02 to 10-09. You looked at…

Hi, I think I have spotted the issue. Assume you are using the same user in the same browser with the same session in both cases. Assume the analysis and the analysis on the dashboard are the same analysis. But the difference is you are using different parameters. In one you are viewing January data and the other October…

Hi, Yes that is correct. Yes when you schedule a report in OTBI with a "Report Job" in OTBI you do have an option to send an notification by email on failure. But no when you schedule an analysis or dashboard page or briefing book in OTBI with an "Agent" (intelligence robot) in OTBI you do NOT have such an option for a…

Hi, Yes the output on an analysis will always be the same as the output of the same analysis on a dashboard. You must be running the analysis with different parameters or the analysis on your dashboard is a different analysis or is being run by a different user with different data security roles / data access for users. Go…

Hi Abhishek, Liwen, In the seeded analysis "Top 10 Spend by Suppler" in folder procurement/spend/transaction analysis samples/ this is a query from subject are "Procurement - Spend Real Time" with a calculated measure "Spend"."Addressable Spend" "Spend"."Non-Addressable Spend" on page manage sessions if you view log you…

Hi On the advanced tab is the logical SQL from above with the left outer join with the cols t and m from the select bit of that SQL on the criteria tab with the formula on col m on the fact measure string.

Hi, No. Technically yes you CAN use the given formula in the reported hours column "if reported hours exist show them but if not reported hours show string WO". So yes it is possible to satisfy the criteria using the case when statement on your fact measure. In the screen shot I showed above you see an example of an…