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
-
Transpose using SQL PIVOTContent I know you can transpose using SQL pivot. But to use PIVOT you need to use an aggregate. In some situations you dont want to use an aggregate. eg: what if you wa… -
Merged cell in Excel 2007 Excel ExportSummary Can you remove the merged cell in a 2007 Excel OBI export?Content Hello, When you export a large document from OBI to 2007 Excel, there is a merged cell that is … -
Help with a formula to capture # of career site postingsSummary Help with a formula to capture # of career site postingsContent Hello - I'm trying to create a few formulas to determine the following - How many requisitions ha…
-
User BI ReportSummary Report on Total UsersContent Wanting to run a report on Users only. Trying to produce a report on All Users in the All Users Group with details Username. First N…
-
Pivot Table PromptsSummary Multi-tab dashboard based off pivot table promptsContent I have a report that displays the market data based on a pivot table prompt. Problem being when there ar…
-
Days between Step/StatusSummary OBI Days between Step/StatusContent I am trying to create a custom calculations to show the number of days a submission remains in a particular step and status. …
-
Week Ending DateSummary Need SQL Expression to get Week Ending DateContent I am looking for an SQL expression that I could use to get the week ending date to display in a column on my r…
-
Issue in OBI Catalog with folders getting moved automaticallyContent Hi, We have seen a strange behaviour where sometimes any random folder in the catalog gets moved under another folder. This happens randomly without any intentio… -
Adding Filters to promptsSummary For you gurus out there, please I need a helpContent I always need to add recruiter name as a prompt but unfortunately we have so many recruiter records that are… -
Release 11 view issuesSummary Two views are not the same in Release 11 as they were in Release 10Content We recently were upgraded to R11 and I found two BI Answer views that are not the same… -
Dashborads are not populatedSummary Dashborads are not populatedContent Hi, After R11 upgrade ,we could not see dashboards in 'My Dashboard" UI.Also,properties got changed for dashboards.Please sug…
-
Anyone experience issues with Reporting using IE 11?Summary Anyone experience issues with Reporting using IE 11?Content I am running into problem when using my IE v11 browser in BI Publisher. All of a sudden buttons withi… -
Native Reporting for Performance - using Extended function to filter results in rtf templateSummary Extended function to create filters in rtf templateContent Hello, We are using the Oracle BI Publisher plug-in for Word to create rtf templates. We need to creat…
-
Able to change "Searching..." text?Summary Able to change "Searching..." text?Content Are we able to change the text on the "Searching..." pop up that appears when an analysis is loading? See attached. We… -
Days on Hold CalculationSummary Need a days on hold formula for Legacy environmentContent Hello - does anyone happen to have a days on hold formula for OBI in the legacy recruiting environment?
-
Max Export into Excel 2007 from OBISummary Wondering what the max export is into Excel 2007Content Hello, Does anyone know what the max number of rows you can export from OBI into Excel 2007? I have heard… -
Max Unposting DateSummary Using max to provide latest unposting dateContent I am using Max to provide the latest unposting date for requisitions. This is causing the number of completed s…
-
Scheduling Reports in OBIEE based on dynamic datesSummary Schedule report delivery on dynamic date parameter.Content Is it possible to schedule a report in OBIEE based on a dynamic date parameter via prompts built into …
-
How to add ESSAPP application role ESSAdmin to enable cloud extract for OTBI-ESummary How to add ESSAPP application role ESSAdmin to enable cloud extract for OTBI-EContent a. To access BI Cloud Connect Console we need to provision roles in APM, co… -
Having nested criteria or pairing fields within your filtersSummary Missing candidates that have multiple hires in the time frameContent Having a hard time correcting the current filters that limit the output to the most recent '…
-
Building a BO subquery in SQLContent Below mentioned are BO subqueries, need to use them in OBIEE. Can anyone list out anyway to do it..
-
Deep Linking URLSummary Open a candidate submissionContent Hello, I am trying to create an analysis with a deep linking URL to the candidate's submission. I am trying to use the URL pro… -
Using Parent-Child Hierarchy values defined for COA segments in OTBISummary Using Parent-Child Hierarchy values defined for COA segments in OTBIContent We have Parent- child hiearchies for the COA segment values especially for BSV, Natur… -
How do you make columns show distinct values in a table in BI PublisherContent I am creating a report in BI publisher and it shows duplicate values for employee ID's. Employee ID should be a distinct value and should not be returning duplic…
-
Error while running BIP report (0ORA-10260: limit size (1048576) of the PGA heap set by event 10261Content Hi, We are getting an below error while working on BIP report to fetch Person data in HCM module. Any idea what could be the cause..? Thanks! ORA-10260: limit si… -
Invalid characters error message wne loading csv or excel fileSummary Can't load csv or excel file into BI data modelContent Hi, When I try and load either csv file with comma separator or pipe or excel .xls file I get invalid char…
-
Drill down capability using hyperlinks to the transaction pagesSummary Drill down capability using hyperlinks to the transaction pagesContent Hi, I would like to know how we can build an OTBI report with an embedded link (url) that …Raghunathan Narasimhan-21427 83 views 4 comments 1 point Most recent by Raghunathan Narasimhan-21427 -
Can we add a filter where we can compare one Column with other 'Calculated Column'Summary Filter Based on Calculated ColumnContent Hi Experts, I have a OTBI Report where I am fetching the Person Details along with who columns. Also I am having a calul… -
Convert text field to date to use for calculationContent We have a UDF field which is populated by the candidate on the recruiting side in a form. The input is a DATE. There is no other choice on how to bring in the da… -
Adding Filters to a BIP reportSummary Adding Filters to a BIP reportContent Hi All, How do I add Filters to a BIP report? Regards, Yaniv