General Transactional Reporting (OTBI)
Discussion List
-
CORS: Setting Access-Control-Allow-Origin header values for BI AnalysisSummary How to set the Access-Control-Allow-Origin for BI analysis.Content Hey, I am working with BI analysis (Sales Cloud Reports and Analytics) in Oracle Sales Cloud. … -
get greatest of two dates in OTBIContent Hi, I need to find greatest /least of two dates in OTBI using formula how can we do this in OTBI?
-
Way to monitor custom scheduled BI Publisher report in the cloud?Summary Looking for way to monitor the status of scheduled jobs inside the fusion cloud environmentContent We have multiple critical scheduled reports and process that d…
-
Security Role allowing Mgmt to stop scheduled reports others have developedSummary Security Role allowing Mgmt to stop scheduled reports others have developedContent My reporting team has the following concern and would appreciate any advice. C… -
-
Dynamic date variables using 'Between' calendar date promptSummary How do I set dynamic, default server variables on a calendar date that uses 'between' dates?Content Hello, I want to set a default date value on my dashboard dat… -
OTBI: OTBI Agent with SFTP DestinationSummary How to Setup OTBI Agent to export report results to SFTP ServerContent Hello All, I have a request to export the result output of an OTBI report to an SFTP serve… -
OTBI Agent with SFTPSummary Setting up an OTBI agent to invoke a server scriptContent Hello Everyone, Does anyone have a documentation on how to setup an OTBI Agent to send a report output … -
Move Export OptionsContent Hi - is there a way to move the export options from the bottom of the analysis to the top, similar to how we can move the paging controls? -
Performance Review Manger and Worker RatingSummary Performance Issue - Please helpContent Hi All, I have built "Performance Review Manger and Worker Rating" report which was working fine till yesterday but today … -
Oracle BI Report Excel Output IssueSummary Oracle BI Report Excel Output Marge CellContent Hello, BIP report when ran in excel it is splitting a column value into multiple cells instead of one single row …
-
How to wrap text after comma in a cell in rtf template,used for BI reportSummary Trying to wrap text for column /cell in rtf template that we are using in our BI reportContent Hello, Can anyone please advise/guide me how to wrap text in a col…
-
OBIEE and Smart viewSummary Downloading Dashboard to Excel via Smart ViewContent Hi, I was able to set up smart view to access OBIEE. There is already a dashboard created in OBIEE and the d…
-
OTBI Analysis export Excel sheet renamingSummary Setting up Excel sheet nameContent Hi All, Is there any trick to change Excel sheet name in OTBI? When we exported any analysis the sheet name is ‘Sheet1’. Can w…
-
BIP Number FormatContent Hi all - I have a BIP report we use for absences. An employee can have absence duration, for example, of 1 or .015 (depending on how they are taking their time).…
-
OTBI - The specified criteria didn't result in any data. when adding department under workforce manaContent Hi, I've added the columns I need from the WORKER folder and the result come back nicely. As soon as I add a column from any other folder, no results are brought… -
To Extract Order Header and Line details using OTBISummary looking for Sample query that works to get Header and line details of available orders using OTBIContent Hi, Can someone please provide me working sample query f…
-
Is Orders data available through the OTBI layer in Order Management / SCM?Summary Is Orders data available through the OTBI layer in Order Management / SCM?Content Is Orders data available through the OTBI layer in Order Management / SCM? Reas…
-
BI Publisher PermissionsSummary BIP Security PermissionsContent Hi, I have to setup permissions on a folder which holds several reports but as I add a Full access permission a folder icon appea… -
Generate .DAT output file from an OTBI ReportSummary Generate .DAT output file from an OTBI ReportContent Hello All, We have got a requirement to generate .DAT as a output file format for an OTBI Report. Can you pl…
-
OTBI Report Date Format is not holding when exporting to ExcelSummary OTBI Report Date Format is not holding when exporting to ExcelContent I have a report and the date format is set to the local time zone. The date is formatted co… -
Any way to bypass the row LimitationSummary Bypass Row LimitationContent Is there anyway to bypass the row limitation? There are times I need to be able to analyze more than 25,000 rows of data. This is ca…
-
Current Timestamp Not Updating on OTBI ReportContent Hello, I'm currently building an HCM Report where it looks at the Timestamp of the change (Hire/Term/etc.) and subtract 1 minute from that timestamp. Then I was … -
BI Publisher Report as Cloud Data Extract engineSummary Use of Report as Cloud Data Extract engine and keep track of extracted data/ recordContent Cloud Integration process where data is extracted and sent via FTP to …
-
How to include the XML Record without a subgroup data when filter on Subgroup is placed?Summary I want to include the All the Records without subgroup and with subgroup having some filter on it.Content Below is the sample XML Data: 008611 123456789 01067…
-
Remove duplicate values in OBIEEContent Hi All, Is it possible to remove duplicate values in OBIEE? In my report, columns A and B have unique values per line for an employee, however, column G is all t… -
OTBI Variable Presentation Date Prompt Format DD-MON-YYYYSummary Users need to be able to enter a date in DD-MON-YYYY format at the promptContent Our date format changed to dd-MON-yyyy (15-MAY-2017), but the only way the repor…
-
Start DatesSummary Accurate start dates in my reportContent I've created a report to list all the new hires starting on the following Monday and I'm tried using both hire start dat…
-
Error exporting report to ExcelContent Hi, We have a custom HCM OTBI report that those users that have row level security access (limited to geographical area) are getting error when trying to export …
-
How to combine results from two AnalysisSummary How to combine results from two AnalysisContent Hi All, I have to combine the results of two analysis into one. Please find the details of input Analysis A and A…