OBI Answers
Discussion List
-
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) -
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticeContent This white paper provides the best practices for working with BI catalog folders, and s…User720640-Oracle 108 views 1 comment 9 points Most recent by HarishVummidi General Transactional Reporting (OTBI) -
Table name to capture reverse termination date & its details for reverse terminated employeesSummary Table name to capture reverse termination date & its details for reverse terminated employeesContent Hi All, In which table I can find the reverse terminated dat…Nirmal Kumar L 20 views 1 comment 1 point Most recent by Parag Hiremath General Transactional Reporting (OTBI) -
Repeat Column Headers in BI Publisher Excel TemplatesSummary Repeat Column Headers in BI Publisher Excel TemplatesContent Hello Everyone, I have a requirement to repeat column headers in BI publisher excel templates when t…Dhanuka Chamal 40 views 5 comments 2 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI) -
OTBI: Find the number of Working/Business Days between two dates and exclude Public HolidaysSummary OTBI: Requirement to find the number of Working/Business Days between two dates, therefore the calculation must exclude days that fall on Weekends or Public Holi…Richard Beet 157 views 5 comments 0 points Most recent by Venu Kumar General Transactional Reporting (OTBI)
-
OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directoSummary OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directory.Content Hi, I have an OTBI Report running into error when …Aloka Bhattacharya 15 views 5 comments 2 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI) -
Text AnalyticsSummary step by step procedure to proceed Text Analytics in OBIEE 11gContent Hi, I need step by step procedure to proceed Text Analytics in OBIEE 11g. I'll be happy to r…Andrews J Stanley 21 views 2 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI) -
Query to find the HRBP Representative of an Employee in HCM DatabaseSummary: Find a 'HR Business Partner' of an Employee in HCM Database - to create a report on Employee and his/her 'HR Business Partner Representative' details. Content (…User_H69RU 251 views 1 comment 0 points Most recent by Vijay Ramani VJ General Transactional Reporting (OTBI)
-
Selecting the latest Order revisionSummary Need to retrieve the latest Orders revisionsContent Hi, While creating an Analysis to retrieve the Sales Orders details we need to show only the latest revision …Mr H 22 views 8 comments 1 point Most recent by Andrew_Schmitz General Transactional Reporting (OTBI)
-
Add to briefing book option takes 10-15 Min to load on published Dashboard over homepageSummary: We have created a custom dashboard which contains multiple analysis, when we click on any analysis to Add to briefing books it takes around 10-15 mins to give t…Shubham Singh 1 view 0 comments 0 points Started by Shubham Singh General Transactional Reporting (OTBI) -
Group by Ethnicity and Headcount in AnalysisSummary: Issue in Analysis when count of ethnicty is added in Case statement Hi Team, I have taken the Employee Ethnicity Analysis from Line Manager Dashboard from the d…Darius Sunder 1 view 0 comments 0 points Started by Darius Sunder General Transactional Reporting (OTBI)
-
How to run an OTBI Analysis and save output without having it deliveredSummary How to run an OTBI Analysis and save output without having it deliveredContent Currently in Schedule option of of OTBI analysis , there is option to deliver to e…Shivaji Muttarapu 24 views 8 comments 0 points Most recent by Shivaji Muttarapu General Transactional Reporting (OTBI)
-
Fusion Dashboard AuditSummary: Fusion Dashboard Audit Content (required): Hi Team, We have requirement to extract the list of HCM dashboard name, dashboard path and how may user has ran the d…[Deleted User] 1 view 2 comments 0 points Most recent by Srinivas Pendyala-Oracle General Transactional Reporting (OTBI)
-
Need to find where the Certificate Number is in the Subject AreaSummary: Need to retrieve the Certificate Number under Licenses and Certifications for an employee "- All Profile Content"."Content Type" = 'Licenses and Certifications'…PamS 11 views 15 comments 0 points Most recent by Mandeep Gupta General Transactional Reporting (OTBI)
-
Custom column in OTBI analysis with case statement is not displaying data in graphSummary I have created an analysis with one of the columns using case statement to derive the status of the performance document based on certain conditions. The graph d…Harpreet Shergill 23 views 4 comments 0 points Most recent by Harpreet Shergill General Transactional Reporting (OTBI)
-
OTBI: Diff of Two dates to get Age is rounded to next highest valueSummary OTBI: Diff of Two dates to get Age is rounded to next highest valueContent OTBI: Diff of Two dates to get Age is rounded to next highest value Example: If differ…Srinivas Challa 77 views 3 comments 1 point Most recent by Matthias Ludewig General Transactional Reporting (OTBI)
-
As Of Date Report Not Pulling Current Row if Ethnicity Is Included In OutputContent The report below is an "As Of" dated report. The issue i am seeing is that if ethnicity is included in the output of the report multiple rows are pulled for asso…User_EQ8R5 4 views 2 comments 0 points Most recent by User_EQ8R5 General Transactional Reporting (OTBI)
-
How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Summary How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Content Hi, I'm working to extract all Quotes and their respective Quote Line Ite… -
OAC/OBIEE and Hyperion Planning PBCS integration questions about RPD and about reportingContent We have two Oracle Cloud Services: OAC and Hyperion PBCS. My questions about general integration between these two. OBIEE and OAC works the same way, that is why…
-
Is it possible to do map visualisations in OTBISummary Is it possible to do map visualisations in OTBIContent Hi, Using only Oracle Transactional Business Intelligence (OTBI) with all the limitation of old Oracle Bus…Nathan CCC 17 views 2 comments 1 point Most recent by Nathan CCC General Transactional Reporting (OTBI) -
BI Publisher Data Model completes with errorsSummary BI Publisher Data Model completes with errorsContent Hi Everyone, I'm trying to create a BI Publisher report using HRC_TXN_HEADER and HRC_TXN_DATA tables. Here I…Dhanuka Chamal 26 views 3 comments 3 points Most recent by Dhanuka Chamal General Transactional Reporting (OTBI)
-
BI Publisher Excel Report Fails With Error "java.lang.OutOfMemoryError: Java heap space"Summary BI Publisher Excel Report Fails With Error "java.lang.OutOfMemoryError: Java heap space"Content Hello Everyone, We are on Oracle Cloud Application 20B. I was try…Dhanuka Chamal 20 views 4 comments 2 points Most recent by Dhanuka Chamal General Transactional Reporting (OTBI)
-
Presentation Variable Prompt causes Error on Results tab, but not in Open linkSummary AsOfDate prompt causes errors OPR4ONWY:U9IM8TAC:OI2DL65PContent I added the follow prefix to my analysis: SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}'; Then I…Brenda Jacks-49721 83 views 8 comments 0 points Most recent by CB General Transactional Reporting (OTBI)
-
BI Publisher Excel - How to get multiple horizontal repeating groups working?Content Hello There, I would like to know how can I get the below output using BI Publisher for Excel. I have three groups in the xml file. G_1 -> G_2 -> G_3 Below expec…
-
BI Publisher Excel TemplateContent Hi All, We have a nested table and beacause of this we are receiving this row mark in front of the data Printing and Stationery" rowMark="2 Does anyone know how …Kunal Daya-76859 47 views 2 comments 2 points Most recent by _IshanAgarwal General Transactional Reporting (OTBI)
-
Run OTBI Report in previous Accounting PeriodSummary Run OTBI period in previous Accounting PeriodContent I have a OTBI Report with Accounting Period as input parameter. Requirement is to run the report for current…Vinod Kumar Mohanraj 19 views 2 comments 0 points Most recent by Vinod Kumar Mohanraj General Transactional Reporting (OTBI)
-
Getting error in BICC while running the DOO Line DetailSummary BICC job is failing while running the DOO Line DetailContent BICC job is failing while running the Line Detail. Attached is the log file. Please help Table name:…vijayakrishna 15 views 2 comments 2 points Most recent by vijayakrishna General Transactional Reporting (OTBI)
-
How to version OBIEE report output sent to webcenter content serverSummary OBIEE reports are scheduled to send to WCC but getting "file already exists"Content We have several scheduled reports in OBIEE that are configured to send to the…John Stinnett 16 views 5 comments 2 points Most recent by Christian Berg-0racle General Transactional Reporting (OTBI) -
Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataSummary Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataContent Hi, We need to fetch the pending transaction Transfer details like New Loc…Nirmal Kumar L 23 views 1 comment 1 point Most recent by User_OWH0W General Transactional Reporting (OTBI)
-
Scheduled Report JobsSummary Deails of Scheduled Report JobsContent Hi Experts, I would like to know is there any seeded report to pull the complete details of scheduled report jobs in BI or…Charan Kollipara 54 views 8 comments 1 point Most recent by Akshay Aiyer General Transactional Reporting (OTBI)