Like this?

Hi Fiona, Yes that is exactly what we did. That custom "XX Project Manager Read Only" role in the screen shot is a real role we have live in production. It only has the transaction analysis duty roles for the subject areas we use in OTBI - all other roles and function privs removed - but the data security privs were…

Hi Fiona, Think of it a bit like pruning a tree. You can only cut the branches at the trunk. Not any branches or leaves any higher up. But if you cut it at the bottom you remove all the branches higher up. The way I make sure of that is to use the filters in Query By Example. For example, if you copy "Project Manager" as…

If your layout is type RTF ? then in your "Template builder for word" add in menu "BI Publisher" after you have upload your sample.xml use the button "Conditional Format" which will add C EC for the start ad end of an if.

NOTE null is 'All' only is you have a lov and you tell it do do so Yes you can do that either in your data model or in each layout using a condition (if). In data model for example by adding a column to your data model with a calculation for example if physical sql where parameter is text (if number or date then cast to…

Try this pattern for multiple value parameters if data set is physical sql data source ApplicationDB_ FSCM/HCM/CRM select all … where 1=1 and (coalesce(null,:p_batch_name) is null or glb.name in (:p_batch_name)) if data set is logical sql data source Oracle BI EE select all … where 1=1 and ((case when ('null' in…

Hi Giorgia, The application user interface work area "Process Requisition" is not a page in Oracle Transactional Business Intelligence. Assume you need the help of the application implementation consultants for business process Manage Purchase Requisitions in To Pay (2P) of application Procurement in ERP/SCM. Please ask…

As a solution all I can think is that you add n mutually exclusive buttons one link to production others with link to non production then some sort of condition to show or hide based on if you can test what environment you are in?

Hi, I think this is a generic internet protocol not specific particularly to OTBI or even Oracle Fusion Cloud Applications just about being a relative path so dot dot ".." means go up one folder in the path in OTBI you are always 1 folder down in analytics/ so .. takes you back up to the root of your url like…

gclampitt Yes you are correct. You still need the filter in the analysis to to have a default to return no rows if prompt before opening is False.

Hi, Another solution is to make at least 1 prompt "Required" but with default no value. Apply button will be greyed out. The user must select a value to apply the prompt to fetch results.

Hi Rama, "How to get the current assignment status of worker"? It is already getting all the "current" assignments. To get the current assignments you need to do nothing. If you view log you will see this subject area default is the effective as at today. So unless you have changed the session variable you are already…

Hi Liwen, To work it out get your query from your analysis then go to page Issue SQL or Manage Sessions to View Log. In the log find the physical SQL to understand the difference between the 2 environments. For example has the metadata repository database added extra where clauses in production to implement data security.…

Hi, Here you go. For your analysis in OTBI or report in OTBI build a query using this subject area. It includes the status of both the header and the line on a purchase requisition. It also has the distributions. Procurement - Requisitions Real Time…

maybe (edit the ifnull if you want some value when hours is null) select all case ("Reported Time Entry Details"."Payroll Time Type Name") when 'Public Holiday IN' then 'PH' else CAST(ifnull("Reported Time Cards"."Reported Hours",null) AS CHARACTER) end as s from "Workforce Management - Reported Time Cards Real Time"

Hi Hari, Yes you can either use use the out of the box dashboards for example "Line Manager Dashboard" or build one using the subject areas https://docs.oracle.com/en/cloud/saas/otbi/fa-index.html Workforce Management - Worker Assignment Event Real…

Hi, Why is the out of the box difficult to understand? Maybe you can provide using some sort of image editor an example of what the output might look like if it were "better". With some notes at to why. Is it the layout? maybe it is the colours you do not like? Or is it the data? Maybe you want some extra columns on the…

Hi Luis, What does your data look like for these 2 projects as a normal table not pivot table. That is what does your data look like in the XML from your data model before you do any data visualisation. For example, if you download your report as output format data CSV. What is the grain of your query? Is it 1 row per…

Hi, You can convert it to a string so it is not a datetime?

Hi, For a list of all out of the box prebuilt analytics and reports by application use https://docs.oracle.com/en/cloud/saas/otbi/fa-index.html To get usage of analysis, prompts, dashboards in OTBI (blue) - but NOT reports in OTBI (orange) you can use "OTBI Usage Real Time"…