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
-
Sorting alphabetically on nameSummary Sorting alphabetically on nameContent Hello - I have a sort on Candidate Name and I realized that names that are in lower case and names that have special letter…
-
Agent LimitationsSummary Encountering limitations on the exports from agentsContent I am currently encountering an issue where exporting data through an agent is cutting off at 25,000 ro…
-
SQL IS NULL errorContent Hi We're trying to create multiple reports where we want to bring back a column with no data in (e.g. Missing Bank Details where the employee does not have a ban…
-
Format prompt selectionsSummary Add specific formatting to prompted selectionsContent Is there a way to format the selections that show for prompts? For instance i need to have a prompt that fo…
-
Using Subject Area for Report: "Unable to retrieve metadata from data model"Summary Attempting to use Subject Area "Payables Payments - Payment History Real Time" in an OBI report which I have used before. Now I get error when I attempt to edit …
-
StatsSummary Stat ReportContent is it possible to report where you have a count of the number of employees in a age range - the age ranges would be columns and then rows woul…
-
How to stop employees viewing reports in 'Custom'?Content Hi We're having some trouble with report access. We're testing our reports and came across an issue where accounts with just the employee role can run reports co…
-
SQL editor for Oracle BISummary What tools are people using to edit SQL in Oracle BI?Content Hi, as per title, I'm wondering what everyone is using to edit SQL in Oracle BI? Eg. for data model …
-
Link to DashboardSummary Looking to provide a direct link to our Recruiting Dashboard for users not logged inContent I'm trying to create a link to our Recruiting Dashboard to be include…
-
Terminated Line ManagerSummary Report on where an employee's Line Manager is TerminatedContent does anyone have a Report on where an employee's Line Manager is Terminated? This causes issues i…
-
Duplicates appearing - need true dataSummary I have one field that is pulling different dates - need true dataContent Hi Group, I'm having an issue getting a single date to pull in correctly in OBI. The fie…
-
Pushing Shortcut to Custom Folders to Users "My Reports"Content If we have a custom folder with many reports, I know that as a user, I can create a shortcut and have that in My Reports. Is there a way for an Admin to push the…
-
Pivot Table/Table Horizontal LayoutSummary Adjusting the layout of a pivot table or table from vertical to horizontalContent I need to change the layout of a sectioned Table from vertical to horizontal. I…
-
Need Help in Creating a OTBI Analysis from Simple Logical SQLSummary I am trying to create a Logical SQL which tries to identify all Person Records who have National Identifiers having more than one occurenceContent I have attache…
-
Limit of Number Of pages On rtf file?Summary I can affiche only 1500 pages on pdf output with rtf templateContent Hello, Is there a limit of number of pages when working with rtf template . I can visualize …
-
Candidate ID PromptSummary Adding required candidate ID prompt with text box entryContent Trying to add a prompt for candidate ID. I want users to be able to copy/paste or type into a text…
-
Using HR VP Data Visualization Content PacksSummary How can i use the Data Visualization Content PacksContent I have downloaded the HR+VP.zip file which has HR+VP.dva file. How can I import this into my cloud inst…
-
Sorting In a Pivot Table OBISummary How to sort on a measure within Pivot TableContent I have a measure called, # of Requisitions with Less Then 20 Apps none in BKG. This is by Recruiter. First I c…
-
Upgraded to 15B and now reports related to hires and offers are erroringContent We recently upgraded to 15B.2 and now reports related to job submissions are having errors. Lists of open reqs are working fine. We are going on week 3 and they …
-
Functional Documentation for seeded ReportsContent Hi, Is there any functional documentation for seeded Reports (Financials) ? Thank you,
-
BI Publisher Transfer file using WebDAVSummary Issue while transferring file using webDAV in Fusion BI PublisherContent Hi All, We are trying to transfer file from Bi Publisher using webDAV(SSL) option instea…
-
Adding new columns to a single view changes all viewsSummary Adding new columns to a single view changes all viewsContent Is there a setting that will stop this from happening? I have several reports that have multiple vie…
-
Any best practices for Security / User group setup?Summary best practice recommendations on security/user groupsContent We are looking at different options for security using User Groups to limit the requisitions that re…
-
Placement of Dashboard Report LinksSummary Can the Dashboard Report Links (e.g., edit, export, add to briefing book, etc.) be moved from the bottom of the page to the top?Content Is it possible to move th…
-
Change order of Pie Graphs and Legend itemsSummary I created a Pie Graph view and would like to specify the orderContent I created a pie graph view with multiple pie graphs and of course a legend. Is there a way …
-
Formula HelpSummary Need help developing formula for date rangeContent Hello All, I am looking for help developing a formula that will help me identify if the date in a column is wi…
-
OBI Self-Service Reporting (i.e. OBI Content View Only)Summary Have any customers been successful with launching OBI Self-Service?Content Oracle told us they do not have folder security permissions and Read-Only capability f…
-
HELP! Deletion, Merging and Incomplete SubmissionsSummary Any advise?Content Hi, We configured the system to hide incomplete submissions in recruiting and also perform data auto-deletion tasks/merging. We however notice…
-
Table View is missing from BIP Data Model in R11Summary Why was Table View taken away from BIP Data Model in R11 and how do we get it back?Content When editing a Data Model in R10, there was a link to View the data in…
-
Trending reports in Fusion HCMSummary Can we create trending reports in Fusion HCMContent I require to create turnover reports in Fusion HCM with data trending over the period of time. For eg, if I s…