GDunlap, Here is a query to get are all the query that were executed from subject areas in the metadata repository database from analysis or prompts etc that included in their query a particular presentation column from a particular subject area. select all 0 s_0 , "OTBI Report"."Report Name" as object_name , "OTBI…

Hi, NO you cannot connect to a network drive outside your cloud. Oracle Fusion Cloud Applications is SaaS. Your host has chosen to make it so many of the features are disabled in SaaS. You cannot connect to a network drive using OBI in OTBI in SaaS like you can when you use OBI in PaaS/on-premise. But included in your…

Hi Anjan, "I have converted varchar to date by using the code" You have NOT converted a string to a date. You have converted some unknown thing X "base_tran_dff_start_date" to a string then converted that string to a date. It makes no sense to me that you are casting a column to a string and then that string to a date.…

Hi The source of information for each release is your readiness guides on the site or app The list of analytics and reports are here. So this tells you if some content is added or removed. It wont tell you if something was updated. For HCM To understand what a dashboard does you do not need a technical design document.…

But then you need to do nothing. The subject area already provides you with a column for that. User interface column "Total Hours" = subject area presentation column "Reported Time Cards"."Reported Hours" ?

Hi JA1, No. Everything you do in OTBI to get data is SQL. All analytics and reports in OTBI query the databases using SQL. Either A) logical SQL like this to query using subject areas from the metadata repository database RPD either i) in an analysis in OTBI or ii) in a report in OTBI with a data model with a dataset using…

To add 2 numbers together from 2 fact columns use operator "+". for example select all 0 s_0 , "Reported Time Cards"."Absence Hours" as fact_1 , "Reported Time Cards"."Labor Hours" as fact_2 , ifnull("Reported Time Cards"."Absence Hours",0.0)+ifnull("Reported Time Cards"."Labor Hours",0.0) as fact_total from "Workforce…

Hi, Here is a list of the analytics and reports out of the box in Oracle Fusion Cloud Applications. Financials View Financials anlayses and reports and for many of these additional descriptions in the user guide on how to run them for each area Oracle Fusion Cloud Financials Using Analytics and Reports for Financials…

Hi, Unfortunately the out of the box OTBI roles BIAdministrator, BIDataModelDeveloper, BIAuthor, BIConsumer, unlike other job roles, they do not have any "inherited roles" or "function security policy" privileges in them that you can edit in a custom version in security console like the other job roles to change behavious.…

Hi Isa, Good News "The language the user will see for multi lingual data fields is governed by the settings" If you ignore reports for a moment many of the "names" and "descriptions" in the application tables and views have a multiple values in a child table with language code added to the unique identifier in a…

Hi, Here is your subject area guide and data lineage guide. This tells you what a subject area does and what is mapped to each subject presentation columns. In your browser go to then select "Review … Subject Areas" Oracle Fusion Cloud HCM Subject Areas for Transactional Business Intelligence in HCM F92793-01 24B "Review…

Hi, First question "column prompt, I got the error" Was the column in your column prompt the same column from the same subject area as that selected in the sql in the variable prompt? I assume not so the first column may be from a different subject area for which your user does not have a job role that inherit the duty…

Hi, You can get this database error ORA-01555 whether a query is generated from OTBI or not. You typically get this error because a query must be "read consistent". So it must answer the question using a snapshot of the state of the data as at a single point in time. If transactions are commit while the query is running…

Hi CYW5R, Of the 2 options the recommended option is to use the function rather than format using word. You will see this option used in many of the out of the box layout rtf templates of numbers and dates and amounts of money in the reports in OTBI. Remember never to use both methods. So use Field Browser then instead of…

Hi VFHNI, The list of analytics and reports in your catalog in OTBI is available for each application on your documents pages as a sheet to download. For example Financials then . This is not stored in a database table. You can get the list of things that were run (but not the list of things that were not run) To get the…

Hi, The best way to understand it is to view the session logs. In the log you can view the clauses added at runtime by the metadata repository database to implement the data security for that user with their data access setup. So ask you bi administrator to grant to your user or a role your user has privileges Issue SQL…

Hi, If a field is mandatory then it cant be missing. So consider making your required fields mandatory. Here is the list of analytics and reports in HCM. You may find something you can use in here.

Hi Shivam, Not out of the box since the vendor cannot know which optional fields you consider "required". But to find the exceptions you can write your own custom query from a subject area in OTBI. select all t.p from t where (t.x is null or t.y is null or t.z is null) Nathan

Here is the data lineage for the subject areas in HCM data lineage 24B

Hi, In your filter dialog Edit Filter. Delete SQL Expression. Put any value in Value. Then select "convert this filter to SQL". Then update the value with CURRENT_DATE.