Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
General Transactional Reporting (OTBI)
Discussion List
-
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 … -
Using an SQL Date Formula in OBIEE ReportSummary How do I display previous 30 days of dataContent Could someone please show me how to tweak the below formula. I’d like to pull data from the previous 30 days; ho…
-
Hired Candidates from the Cleared ListContent Dear All Is there a way I can add a subquery in one the columns of the report to indicate a if the cleared candidate has been hired for another position ? Thank …
-
OTBI: Ability to utilize a prompt for sorting purposes?Content Hello Customer Connect community, Does OTBI have the ability to prompt for a sort on a dashboard? For example, I have a costing report consisting of employee det… -
Agent parametersContent Hi While running agent can we pass any parameters as the OTBI analysis which is added to agent require variable prompt as parameter ? After running agent,email i…
-
BIP reports on DashboardSummary BIP reports on DashboardContent Hi All, I am fairly new to OBI , so kindly excuse my ignorance. I have two BIP reports.Attaching layout for one of the report alo…
-
Password Protected Excel OutputsSummary Password for OTBI and BIP Excel ouputsContent Hi Team, I learnt from another post it is possible to protect PDF outputs for BIP reports. However, I wonder if you… -
XSLT Template - FunctionsSummary Would like to use "functions" in XSLT template for BI reports, but it's not workingContent I'm trying to use functions available in XSL and using the below names…
-
Need to Add more Information from Seeded Data ModelSummary We've successfully customized an AR Invoice Print Layout, but we need more information that the Seeded Data Model Does not ProvideContent Hi, we're in the middle… -
How to remove underline shown for Title in PDF View of DashboardSummary HTML View and Printable PDF View look different since PDF view underlines TitlesContent Please refer to the attachment.
-
Hide "Reports Job" under New Menu in Analytics pageSummary How to hide "Reports Job" under New Menu in Analytics pageContent Hello, I am trying to hide "Reports Job" under New in analytics page (highlighted in the screen…
-
How to add the number in BarChart in OTBISummary How to add the number in BarChart in OTBIContent I have created the Graph in OTBI, Pie chart and barchart but values is not showing on the charts . Like attached…
-
Can we have a OTBI analysis based on a BI Publisher Report's output?Summary Can we have a OTBI analysis based on a BI Publisher Report's output?Content Can we have a OTBI analysis based on a BI Publisher Report's output? Regards, Rashmi -
Terminations ReportContent Hi I am currently trying to create a terminations report. I cannot find the following: - Termination Action - Termination Reason I am using the Workforce Managem… -
How to display values in bargraph_vertical in BI Publisher RTF TemplateSummary How to display values in bargraph_vertical in BI Publisher RTF TemplateContent Hi, Can anyone help on how to display values in the Bargraph in RTF template. I ha…
-
Customizing a Seeded Report - Editing the Data Model and using PackagesSummary The Payable Invoice Aging Data Model uses package AP_APXINAGE_XMLP_PKG. I could use instructions on how to interact in SQL with this package.Content I am searchi… -
OTBI Reports - Disable Excel optionSummary Can we hide 'Excel 2007' option under Export for OTBI reportsContent Hello All - We have an issue with downloading OTBI reports to Excel. it doesn't download all…
-
Employment Position History ReportSummary Grouping dataContent I am creating a BI Report that basically lists out all the Jobs an employee has had during their employment, so of course my initial groupin…
-
Restoring a deleted folder in catalogueSummary Accidently deleted a folder. Is there a way to restore the folder?Content Hi I accidently delelted a folder in the fusion OBI catalouge. Is there a way to be abl…