Category 115
Discussion List
-
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 query fusion tables in SQL developerSummary: We have a data model to select the email_address_id from fusion.PER_EMAIL_ADDRESSES but we want to be able to query this table or data from this table (or IRC_C…maria.stanciu 31 views 2 comments 0 points Most recent by maria.stanciu General Transactional Reporting (OTBI)
-
Can we change the color of Graphs?Summary: I've created a custom OTBI report in Graphical form as follows: Is it possible to change the cylinder "Employee with Goals Created" (Blue currently) to Green an…Shubham Shree 21 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 31 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)
-
General question have if I move any another orginaizationSummary: Hi Team, If future chance to move other organization from current one, how can i access my current cloud customer connect beacuse i have login through my curren…AjayKumar Maddipati 11 views 2 comments 0 points Most recent by Mandeep Gupta 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…
-
update on subtemplateSummary: 1- i update on Award Approval Notification Report. 2- has template AwardApprovalNotificationBodyReport.rtf. 3- in this template i have multiple subtemplate like…ghrbia 21 views 4 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
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)
-
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)
-
Clean up html formatting stored in table columnWe are using notes to store data in an application table (Oracle Cloud PPM, Project setup); users are copying and pasting data from an html page and inadvertently pastin…erp_expert03 21 views 3 comments 0 points Most recent by Venkat Koduvayur-Oracle General Transactional Reporting (OTBI)