OTBI
Discussion List
-
Full-Time equivalent is not working within USING clause of a FILTER operator in OTBII have created an OTBI report using Subject area - Workforce Management - Employee Assignment real time and Full-Time equivalent i am fetching from the "Worker Assignmen…Utkarsh2602 25 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Can you get data from data model or report (not analysis) thought web service (XmlViewService) ?Summary: We need to get the data displayed in a data model or report in an web service (for further integrations). The web service is XmlViewService which allows Execute…maria.stanciu 51 views 3 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
How to count employees in department?Summary: Hi All, I am just wondering, how to count the employees in each department using OTBI. The scenario: I am building a dashboard and need to show the counts of em…Paul Younes 11 views 2 comments 0 points Most recent by Paul Younes General Transactional Reporting (OTBI)
-
OTBI Report Performance IssueSummary: Customer facing performance issue with the reports developed using OTBI Content (required): Customer developed some of the reports using OTBI reporting tool whe…Praveen Gollu-Oracle 11 views 1 comment 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
How to open OTBI on phone applicationDear All Kindly find the below: I have create an otbi analytic and dashboard but I want to link it to the phone application What is the name of the app ? How to link it?…mickel rmeily 31 views 5 comments 1 point Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI) -
Drill down from OTBI adhoc reports to PPMDear All How can I extract the drilldown hyperlink from PPM to OTBI ? I need the page that show the project financial settings structure Regardsmickel rmeily 21 views 6 comments 0 points Most recent by Rich Merkel General Transactional Reporting (OTBI)
-
Exclude one account from filterSummary: Looking to exclude a specific account from overall filter Content (required): Is there a way to exclude one account from a filter that suppresses accounts with …Ray Gupta 21 views 5 comments 0 points Most recent by Ray Gupta General Transactional Reporting (OTBI)
-
How to Fetch more than 1000 records with BIP or OTBI reportSummary: Fetch more than 1000 records with BIP or OTBI report. Content (required): Hi, How to fetch more than 1000 records with BIP or OTBI report. I tried with Paramete…Sudheer YN 41 views 6 comments 0 points Most recent by Rich Merkel General Transactional Reporting (OTBI)
-
we have two subject areas in ORC but unable to find Offer Extednded DateSummary: Hi Team, we have two subject areas recurting real time and recurting events real time we unable to find Offer Extednded Date -column how can we find that column…AjayKumar Maddipati 41 views 9 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI) -
Earliest Working Pattern RecordSummary: 52 week working pattern start date is not reportable at the moment. Content (required): Each time the employee changes to a zero hours week there is a new worki…Dawn Cawston - CPS 11 views 2 comments 0 points Most recent by Dawn Cawston - CPS General Transactional Reporting (OTBI) -
Embedding filters without converting to SQLSummary: Hello- Is there a way to embed a AND/OR statement into a filter without converting to SQL? Content (required): We are in need of a workaround that does not requ…Kielty Walsh 21 views 3 comments 0 points Most recent by Anirban Basu-133546 General Transactional Reporting (OTBI)
-
How to default the method of opening for an analysis that has been favorited?I have an analysis with a filter marked as a Favorite. The issue I have is when I click on the analysis from the Favorites dropdown, it opens into edit mode. Is there a …Mike Burnett 51 views 10 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI) -
Project Commitments Real Time - need current open PO balance by project OTBI analysisSummary: I am looking for a column for current open PO balance by project. I am currently using the "Project Costing - Commitments Real Time"."- Purchase Order Measures"…Alex Glose 21 views 9 comments 0 points Most recent by Rich Merkel General Transactional Reporting (OTBI) -
Rating level name showning in two rows one is emptySummary: Hi Team, we have performnce documet rating level name column but its shown as below, in single column shown as two rows of each employee . any one help on how t…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
How to build an Analysis on OTBI to show every colleague's default expense account?Summary: Need report to show all colleague's default expense accounts. Content (required): I need to create a report to show every colleague's default expense account so…
-
Data Security required for users to view data on subject area Procurement - Requisitions Real TimeSummary: When our users try to run reports created using the subject area 'Procurement - Requisitions Real Time' they return no data. Content (required): We have provide…K Fortune 31 views 4 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
we need every year annual review value in performance documentsSummary: Hi Team, We need every year annual review value in performance documents in OTBI in sunbject area of performance rating real time. EXample--FY2021 Employee Annu…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by AjayKumar Maddipati General Transactional Reporting (OTBI)
-
Finding the alphabets from a Alphanumeric in OTBI.Summary: I have a requirement to identify the alphabets (be it upper/lower case) from a string. The format of the sting is as follows: SSN: ****-XX-XXXX (112-10-1234) TI…satya_nvs 21 views 2 comments 0 points Most recent by Venkat Koduvayur-Oracle General Transactional Reporting (OTBI)
-
Any one help Skills ReportSummary: Hi Team, we need skills report in Bi or OTBI Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Count positive values and compare with total count to get the aggregated share of positive valuesSummary: How can I count the number of positive values in a column and compare with the total count to get the share percentage of positive values? Content (required): I…Stefan pettersson 31 views 3 comments 0 points Most recent by Stefan pettersson General Transactional Reporting (OTBI)
-
We have set operations report but unable to reviewSummary: Hi Team, we have set operations report but I'm unable to find out applied filters and where we need to check . any one help me on how can we review for enchanem…AjayKumar Maddipati 11 views 2 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
Turnover by Ethnicity - Report AssistanceSummary: We are currently running into issues creating a Turnover report by Ethnicity due to how ethnicity is handled in Oracle. This is causing employees to be duplicat…
-
we have questin text and answer report but all questions are coming in columnsSummary: Hi , we have questin text and answer report but all questions and answers are coming in columns. so we get multiple records for each employee i mean 7 questions…AjayKumar Maddipati 21 views 4 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
Displaying the Receipt Date for the Purchase Order in PO Details ReportSummary Displaying the Receipt Date for the Purchase Order in PO Details ReportContent Hi , I have PO Details Report with the following fields. PO Number, PO Date, PO St…Dharmendra Jha-160968 42 views 10 comments 1 point Most recent by Tracy C General Transactional Reporting (OTBI)
-
How to build an Analysis on OTBI to show cumulative totals over time?Summary: What is the function (or any way) of an Analysis report that shows cumulative totals over time, in the same way as it is displayed on attached file? For example…Wilromar Benevides 11 views 4 comments 0 points Most recent by Wilromar Benevides General Transactional Reporting (OTBI)
-
How to report Number of Performance Goals by employees (then broken up by categories) using OTBI ?Summary: Dear peers, My customer wants to report the no. of performance goals every employee has in their Goal Plan; Total and Category-wise (There are 13 custom categor…Shubham Shree 21 views 3 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
How do we build an OTBI report to see the ratings of a Business Unit head's organization?Summary: The client requires a report that can be run to fetch the Performance ratings of all the employees that fall under a particular Business Leader (direct as well …Shubham Shree 11 views 1 comment 0 points Most recent by Sovitendu Jalli-Oracle General Transactional Reporting (OTBI)
-
Data loaded to Assignment EFF through spreadsheet loader are not displayed in OTBI reportSummary: Data loaded to Assignment EFF through spreadsheet loader are not displayed in OTBI report Content (required): We have loaded assignment EFF attributes using spr…Brennan 31 views 6 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
Action Reporting - Promotions, Increases, DemotionsSummary: Action Reporting - Promotions, Increases, Demotions Content (required): Hi there. I'm wondering if there are any detailed process documents for how to create an…Kelly_at_D&R 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI) -
Unable to join Workforce Goals - Goal Status Overview Real Time and Workforce Performance - PerformaSummary: Hi Team, I have a requirement where I need to fetch goal plan details along with rating details for a specific goal plan for employees. I have included fact col…Khush Tiwari Credit Suisse 41 views 5 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)