OTBI
Discussion List
-
OTBI Usage and Performance Dashboard SampleSummary OTBI Usage and Performance Dashboard SampleContent Real Time OTBI Usage & Performance * Two subject areas are available in 20D to monitor OTBI usage and performa…Noelle Bartlam-Oracle 740 views 19 comments 18 points Most recent by Shanna Roy General Transactional Reporting (OTBI)
-
Adapting Previously Used SQLSummary: Amending a BIP Report we have that's not pulling the correct results back Content (required): Hi all, Apologies if this is the wrong place to ask. I've been ask…
-
OTBI Report with two subject areas that are not connectedSummary: I am trying to build a report that provides information on intercompany invoicing with details of the time entries, comments and costs associated with it. I am …Ravi Natarajan-240775 14 views 3 comments 0 points Most recent by Ravi Natarajan-240775 General Transactional Reporting (OTBI)
-
OTBI - Joins between Procurement and Payment related Subject AreasSummary: Content (required): Hi Team, There is an issue while joining two Subject Areas related to Procurement and Payment (trying to join below subject areas as in atta…Sridhar Gupta Yerram-Oracle 17 views 1 comment 0 points Most recent by Raghavan p-Oracle General Transactional Reporting (OTBI)
-
Communities in LearnSummary: Hi, I am working on LEARN report. I have to pull 'communities' field into my analysis can anyone provide me the specific Subject area and field name through whi…Praveen_Chouhan 14 views 2 comments 0 points Most recent by Ramzzz General Transactional Reporting (OTBI)
-
Scheduled OTBI report missing in month of first day but when manually extract that report no issueSummary: Hi Team, we have custom OTBI report, so we started scheduling to business with filter of April first on words only so when we scheduled that report April 1st mi…AjayKumar Maddipati 16 views 1 comment 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
How to add parameterized OTBI report on InfoletSummary: Hi Team, We have created parameterized OTBI Report and a dashboard with prompt. However when we add them to infolet , but infolet is not asking for parameter an…Nidhi Chhajed 13 views 1 comment 0 points Most recent by Raghavan p-Oracle General Transactional Reporting (OTBI)
-
How to create a flag field to know if a colleague is a Manager or not in OTBI report directly?Summary: In addition, wanted to understand if there's any in-built field present which can let us know whether listed Supervisor is in Active or Inactive status. If ther…Abhishek Bagh 14 views 6 comments 0 points Most recent by Abhishek Bagh General Transactional Reporting (OTBI)
-
How to default an OTBI SQL in a Data Model to Table View?Summary: How to default an OTBI SQL in a Data Model to Table View? Content (required): Does anyone know if it's possible to default the Data tab of an OTBI Data Model to…Mike Burnett 15 views 3 comments 0 points Most recent by Mike Burnett General Transactional Reporting (OTBI)
-
Recruiting: How to create a report to show the list of Offer approversSummary: Hi All, There have been many issues in 22B regarding (Recruiting) Offer approvals getting stuck, or not working the way they should be. It was just recently fix…Jessie Gee 12 views 2 comments 0 points Most recent by Jessie Gee General Transactional Reporting (OTBI)
-
Recruiting: How to create a report to show the list of Offer approversSummary: Hi All, There have been many issues in 22B regarding (Recruiting) Offer approvals getting stuck, or not working the way they should be. It was just recently fix…
-
Pie Chart does not return all itemsSummary: Table results not displayed in Pie Chart Content (required): We have a table that is ranked and everything ranked above 10 is grouped under the reason name 'Oth…Dawn Cawston - CPS 2 views 1 comment 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
In OTBI report each employee have getting two rows but businees need only one row?Summary: Hi Team, when i set order as per bussiness requiremnt i taken and suppress the columns then when i export into csv or excel and with out usiing formatted option…AjayKumar Maddipati 22 views 6 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
Multiple Filters/ Conditions in OTBI ReportingSummary: Hello, Does anyone know how I can create multiple conditions / apply multiple filters in a single OTBI Report? Thank you. Content (required): Version (include t…Lola Kassim 19 views 2 comments 0 points Most recent by Lola Kassim General Transactional Reporting (OTBI)
-
Field Location Help (License/Cert - Item Code )Summary: I am trying to add the 'Item Code' for license/certifications. I have gone through all the fields under Workforce Profiles - Person Profile Real Time related to…
-
Want to know the exact name and subject area in OTBI for adding 'Reference Number' fieldSummary: Hi Team, OTBI - Could you please suggest the correct subject area and field name for adding Reference Number field (Highlighted in Yellow below) available in th…Rahul Kumar Gupta.-Oracle 3 views 6 comments 0 points Most recent by Rahul Kumar Gupta.-Oracle General Transactional Reporting (OTBI)
-
Filter out Employee RatingSummary: I have created a report that has the field Rating Level Name but it includes both Employee and Manager Rating Level Content (required): I how do I identify whic…Dawn Cawston - CPS 2 views 2 comments 0 points Most recent by Dawn Cawston - CPS General Transactional Reporting (OTBI)
-
OTBI report and data role securitySummary: Should an OTBI report using General Ledger - Balances Real Time subject area (linked to the Essbase cube) inherit custom data roles configured in SaaS? Content …Craig Hevey 2 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
which subject Area need to take for Talent RatingsSummary: Hi team, we have new requirement on Talent ratings of employees So how can I go with and in which subject area below columns are available ? Talent ratings>care…AjayKumar Maddipati 22 views 5 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
OTBI: Getting Error: exceeded configured maximum number of allowed output rowsSummary: Have created an OTBI analysis on "Sourcing: Supplier Awards real time". It has a couple of graphs and tables. But when running for a Negotiation with around 250…Ashu Raj-Oracle 31 views 6 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Error while calling Oracle BI Publisher REST API in 22ASummary: Error while calling Oracle BI Publisher REST API in 22A Content (required): Hi Everyone, Tried calling REST API for Oracle BI Publisher from postman but got err…Shashidhar Goud 12 views 9 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
What controls access to "all job histories" versus "my job histories" in Report Job History?Summary: How do we grant a user access to see all job history not just their own? Content (required): We are trying to grant access a power user access to all job histor…Lisa G. 22 views 2 comments 1 point Most recent by Rajasekhar Bandaru-Oracle General Transactional Reporting (OTBI)
-
OTBI Analysis - Show Managers Direct and Indirect StructureSummary: OTBI Analysis - Show Managers Direct and Indirect Structure Content (required): I am looking to show a manager's indirect structure, for example, I like to know…Harminder Banga-283414 2 views 2 comments 0 points Most recent by Andrew_Schmitz General Transactional Reporting (OTBI)
-
The performance tile view is not refreshing for one user in PRODSummary: The performance tile view is not refreshing for one user in PROD Content (required): Hi experts, We have a case where the performance tile view is not refreshin…Volodymyr Faranosov 11 views 1 comment 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
Absence Balances ReportHello, We have been tasked to develop a report against the Absence records to find out the employee balances for each pay period. Can anyone please advise the subject ar…Harry Oracle 3 views 1 comment 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
How to view History of a scheduled AnalysisSummary: Content (required): Hi All, I have scheduled an Analysis to run every hr. There is no History option available in the analysis -->> More menu or the analysis sc…
-
Creating Custom Columns in OTBI ReportingSummary: I like to know who to create custom columns for reports and then call them in OTBI Analysis Save me updating individual reports as I am doing at the moment A us…Harminder Banga-283414 13 views 4 comments 0 points Most recent by Harminder Banga-283414 General Transactional Reporting (OTBI)
-
How to restrict the PPM contract data based on the roles of the user logged in in OTBI DashboardSummary: We are trying to restrict the data based on the roles available for the user logged in specifically Principal Investigator role (PI role). Content (required): V…Abhilash Karappankutty 2 views 4 comments 0 points Most recent by Abhilash Karappankutty General Transactional Reporting (OTBI)
-
Report containing all the agent(s) I have definedSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):User547534-Oracle 12 views 2 comments 0 points Most recent by User547534-Oracle General Transactional Reporting (OTBI)
-
Employee salary details not able to view through Compensation - Salary Details Real Time Subject AreSummary: We are trying to create a OTBI report for Employee assignment details with Salary details using Compensation - Salary Details Real Time % Assignment Real Time S…Srinivas Sakinala 5 views 3 comments 0 points Most recent by Srinivas Sakinala General Transactional Reporting (OTBI)