General Transactional Reporting (OTBI)
Discussion List
-
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…
-
Dashboard Prompt ScopeSummary Dashboard Prompt Scope for Multiple PagesContent Hello! I’m building a Dashboard that has 5 pages. I have a Dashboard prompt on page 1 that allows the user to se…
-
how to remove decimile from the chartSummary how to remove decimile from the chartContent Hi, In OTBI dashboards charts shows the values in fractions see the chart as attached, so how can we remove the frac…
-
Create a LDAP Data source for OTBISummary Need to be able to access LDAP folders from OTBIContent Hi, We have a need to verify the usernames in EPM to the LDAP account names. This is because we have inst…
-
BIP report date format is not working in Dashboard promptsContent Hi All, I have created a BIP report with date parameter and it is working fine. When I tried to apply dashboard column prompts on the same report data is not fet…
-
List of Tables and Fields in the OTBI Subject AreasContent Is there a list of all of the tables and fields that are included in the premade subject areas for OTBI? I notice that there is overlap between the Payables subj…
-
Reporting on Current Payroll Balances for a colleague i.e P60 Rate, Holiday Rates, Court Orders (othSummary Payroll Reports or Fusion pages that display the individual colleagues current BalancesContent Hello, Is anybody aware of a method in which we can view a colleag…
-
How to administrate BI PublisherSummary How to administrate BI PublisherContent Hello, I've installed Weblogic 12 and Forms&Reports12 now I've also installed BI Publisher. How can I find now the BI Pub…
-
Report not attached in email coming from agentSummary is there a size limit to the fileContent We currently have a scheduled agent for a report that comes out as a csv report. However, the report is not shown as an …
-
Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is used?Summary Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is used?Content Hi, Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is …