Hi Ivony Ann, You need to share the logical SQL, as text not as an attachment because people cant trust strangers on the internet, if you want a better chance of getting some help. Is it just this particular query from this subject area that is slow or all queries from this subject area? Does you query include fact number…

Hi, Here is your user guide. This tells you how to create a column filter in your analysis in OTBI. Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition 12.2.1.3.0 E80922-02 November 2017 Filtering and Selecting Data for Analyses Creating Column Filters…

Hi, To know what job roles are in play for a subject area go to docs.oracle.com. For example, shows us that for subject area Compensation - Workforce Assignment Salary Real Time the job roles are Compensation Analyst Compensation Manager Human Resource Analyst Line Manager Next for the job role you are using as IT Security…

Hi, Or perhaps the subject areas DO show data! But it no longer shows data for your user with your roles with your setup by security context in manage data access for users and/or you security profile in a data role. To view the data security go to page issue SQL then manage sessions to view log to read the where clause…

Hi Simon, As Nikki said you can add a dashboard prompt. For that to work the column in the dashboard prompt must be set to a presentation variable with the same name in same case as the parameter in your data model. So SPECILIZATION_NAME. I am confused with you other parameter because you are using a list of values rather…

Hi Yes, You can schedule a dashboard using delivers by creating an intelligence robot Agent in OTBI. Or the same way if you schedule an analysis with filters is prompted then you can add parameters in the agent For more information read your user guide Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence…

Hi WJOEV, You cannot add custom column to a subject area in OTBI. Oracle Transactional Business Intelligence (OTBI) is packaged up in Oracle Fusion Cloud Applications hosted as a Software as a Service. Our vendor Oracle does not give us the administrator privileges to edit the subject areas in the metadata repository…

Becca, The links were to a chapter/section inside older the 22b version of document FAHCA "Administering Analytics and Reports for HCM". But this stale link has taken you up to the "title" page of latest version 24C of the same document in this case 24C. So the good news is you are in the correct document. Just search for…

Hi, If you use web service Oracle Enterprise Scheduler Service (ESS) Web Services Description Language (WSDL) Extended Markup Language (XML) /bi/ess/esswebservice?wsdl When you invoke you have a boolean option Do you want to configure this as a callback invoke? No or Yes Inside your flat wsdl file you have 2 services…

Hi Harishma, In my humble opinion there can be no "technical" answer to this question. Solution designers use replication technologies like "golden gate" etc to get transactions out of the logs before it is even written to disk for for use cases that require "real time" databases for analytics and reporting. But if you…

Hi Umer, So you will get a count of the distinct work orders that are completed and end is today. Maybe if you post what is your actual result versus what is your expected result. Use the simplest set of data you can. If data security is an issue then change the values to "Apples" and "Oranges". Looking at your formula to…

Hi Regie, The system is working as expected. That is not an error. That is the expected result when surpress = True. Facts already surpress by default. Your calculated total is a yellow fact measure column. So by default as expected it is already suppress to the grain of your query based on the dimensions you have include…

Hi, Yes if you view log I think you will confirm that it is getting the assignment current where sysdate between effective_start_date and effective_end_date I think you will need to also query the assignment subject area. In your user guide for this subject area Workforce Management - Worker Assignment Real it tells you…

Hi Regie, I am assuming the 2 columns in your sum are the 2 columns we can see in your table column header "Item Name" is "Inventory Material"."Material Name" (you renamed the column header?) and column header "Required Quantity" is ("Material Usage"."Required Quantity"? Assume you therefore expected work order 652…

Hi Kevin, Thanks. So your document does NOT quite conclude what you assert in your question (at least not all cases) "don't see any option to export in .xlsx only .xls the older format has been blocked for use now on our systems, we can't open the files" - this is not true for all layouts in all reports (only some of them…

Hi, Yes here is your user guide Oracle Fusion Cloud HCM Subject Areas for Transactional Business Intelligence in HCM F97517-02 24C Workforce Management - Reported Time Cards Real Time Workforce Management - Processed Time Cards Real Time Workforce Management - Historical Reported Time Cards Real Time Workforce Management -…

@Kevin M Storrie Hi Kevin, No you can export as XLSX for both analysis AND reports in OTBI. Sorry but I think another internal communication issue on your side. " it is BIP only that can't export to .xlsx" I think no that is not true either. With a publisher report in OTBI too you can export as XLSX. Here on our example…

Yes you can show hide a dashboard based on role. But you can also show hide a page or sections on a page using permissions by role. So possibly a page/section for each? Alternative… If your analytics and repots are on dashboards then you can add a condition to each section on a page. show if query return rows, hide if no…

Hi Parvathi, Which subject area are you using? Are you using (Full) "Name" not "Display Name"? Assume this is not your query because this subject area has the fields you need? select all "Person Names (Global)"."Full Name" s , "Person Names (Global)"."Last Name" , "Person Names (Global)"."First Name" , "Person Names…

Hi Kevin, 1. The Oracle Business Intelligence (suite Enterprise Edition) OBI (suite EE) platform is the product inside Oracle Transactional Business Intelligence OTBI in Oracle Fusion Cloud Applications (FA). The EE is in brackets because Standard Edition (SE) of the suite was retired many many years ago. As a platform…