General Transactional Reporting (OTBI)
Discussion List
-
Pass Groovy script variable to OTBI DashboardSummary Pass Groovy script variable to OTBI DashboardContent Hi All, I want to Pass Groovy script variable for OTBI Dashboard from fusion page to Dashboard (Dashboard pr… -
Pass Groovy script variable to OTBI DashboardSummary Pass Groovy script variable to OTBI DashboardContent Hi All, I want to Pass Groovy script variable for OTBI Dashboard from fusion page to Dashboard (Dashboard pr…
-
OTBI Analysis: How can we enable Multiselect for a table prompt?Content Hello, As you can see in my screenshot, I want to enable the multiselect for a table prompt. PS1: I can't use dashboard for my need. PS2: I can't use the Prompt …
-
CloudERP - Excel Desktop IntegrationSummary Issue in exporting data in Excel formatContent Unfortunately, this is not a bug. Rather, it is the result of a security fix that had to be implemented due to an …
-
Mobile App Designer (OTBI - Fusion Cloud)Content Hi, We are using Oracle BI HD app for viewing MAD Reports in Mobile IOS Device, We could not able to save username and password ,we tried using save password and…
-
OTBI - Disable auto runContent In OTBI analysis, how do you disable the auto run option ? I can see that option in BI report but not sure how to do in OTBI.
-
Is It Possible to Create a BI Report from RSS Feed in Oracle HCM CloudSummary Is It Possible to Create a BI Report from RSS Feed in Oracle HCM CloudContent Hi Experts, Can we create a BI Report from RSS feed. Any documents/pointers/insight… -
Candidate Drop off ReportSummary a report that gives details on when a candidate drops off at an application and doesn't complete/submitContent We have been working on building a candidate drop …
-
Audtit ReportingSummary Report that tell who has run which reportsContent Need a OTBI report or BIP that will tell us who has ran which report at what time and how many time. This will … -
Running into a problem using Pivot tables in Release 12Summary Running into a problem using Pivot tables in Release 12Content We upgraded to Release 12 on September 25, 2017. Prior to the upgrade, I was able to create pivot … -
Different report in same Excel file with differents sheetSummary Different report in same Excel file with differents sheetContent Hi Experts, I created 3 new reports as per our customer requirements. But they need all the repo…
-
Scheduler IssuesSummary Experiencing intermittent errors with scheduled reportsContent Is anyone else experiencing any issues with scheduled reports? In the last 24 hours, a couple of o… -
Editing Dashboard: Embedded ContentSummary I need to edit the embedded content on a dashboard but cannot - why?Content Hi all - our team copied reports from production to stage this weekend. I noticed tha… -
How to get roles assigned to BI ReportsSummary How to get the roles assigned to BI ReportsContent HiI need to a quick way (SQL or BI report) to get the roles assigned to reports (we have about 200 of them). I…
-
Length function issueSummary Please use CHAR_LENGTH instead of LENGTHContent In OBI, there is an issue with the LENGTH function where it causes the report to take up multiple times the norma…
-
Fetching last manager name and number for the terminated employees in sqlSummary Fetching last manager name and number for the terminated employees in sqlContent Hi, Anyone know how to fetch the manager name for the terminated employees? For …
-
Data model with parameter with "Select all"Summary Data model with parameter with "Select all"Content Hi, we created a data model based on several analisys and we want to add a parameter which filters by Employee…
-
Extracting all Columns from BIP Query without creating layout?Content Hi Guys I have to extract all the columns from 11 different tables for our finances guys to sift through and see what data they want. Some of these tables have 1… -
Restricting access to OTBI Subject area and data elements within a subject areaSummary How do we restrict subject area access to a user through security role?Content Subject area access is driven by duty roles. A duty role 'Workforce Transaction An…
-
Time in role reportSummary I need to create a time in role reportContent I need to create a time in role report. In our old system we had a calc which said minimum Effective Date for Emplo…
-
Dashboard ReportSummary Dashboard ReportContent Hi all, Can we able to make the Dashboard and Report width size equally while we are using 2 layouts? I have highlighted in yellow color,…
-
Bursting ReportSummary A report on Probation which bursts out to Line ManagersContent is there any example reports which look at Probation Period? Also sample reports for Bursting?
-
Access Denied for user to path..Summary Access Denied for user to path..Content Hi, I'm a super user and have high level of security, but in the Report when I select Admin View and look at specific use… -
Report Employee Photo in Custom DashboardSummary Is there a way to display an employee photo in a custom dashboard?Content We have a custom Talent Profile dashboard and I am wondering if there is a way to pull …
-
How to calculate subtotal of sectionSummary trying to get subtotal of section but it includes all dataContent Any suggestions on how to get the subtotals added to this report? Example below, want totals fo… -
How to schedule OBI Jobs using generic userContent Hi All, We have several reports in OBI which we schedule from our personal logic, but this is not correct we should have a capability to schedule them using a ge… -
Error occurs in query when we add one line in where conditionSummary Error occurs in query when we add one line in where conditionContent Hi, While adding this line in the existing query the below error occurs. Line used in where …
-
Syntax to converting 24 hour time format to 12 hour format in sqlSummary Syntax to converting 24 hour time format to 12 hour format in sqlContent Hi, Anyone know the SQL syntax to convert 24 hour time format(eg. 18:00 for 6:00 PM) to …
-
Missing Name Infomration in Subject AreaSummary Cannot find field for Preferred Name, Employee Salutation, etcContent I cannot find the following fields in the worker or any other subject area. Preferred Name,…
-
Conditional FormattingSummary Conitional Formatting is not working properlyContent I have created a report to help our teams identify at risk background checks. The report uses OBI conditiona…