Popular Tags
- OTBI 1,428
- Reporting 1,383
- FDI 1,062
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 407
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 247
- Developers 243
- Data Modelling and Datasets 223
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 168
- Customizing Reports 156
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Analytics Community
The Oracle Analytics Community helps connect with Data, Analytics, and AI experts, explore forums, events, user groups, idea labs & share data visualizations.
Discussion List
-
How can I get a notification on failed scheduled OTBI Job?Summary: The request is to recieve an email notification if the OTBI Job is failed. I know the option is available for BIP but how I can accomplish that for OTBI? Conten…
-
How to get the active encumbered amount in Oracle Fusion BIP reportSummary: How to get the active encumbered amount in Oracle Fusion BIP report In EBS we used the below Package to get the active encumbered amount, How to get the same in…Raoof Ahmed 1 view 0 comments 0 points Started by Raoof Ahmed Oracle Transactional Business Intelligence
-
SQL Query Support Request: Payroll Run Results with Payment StatusHi, I'm using a data model to query payroll run results, but I'm only interested in the calculated amounts that were processed to payment. I'm struggling to link the res…Alex_of_Wincanton 6 views 0 comments 0 points Started by Alex_of_Wincanton Oracle Transactional Business Intelligence
-
Service type in OTBI reportI have disabled/removed service type under lookup code and removed in template, but when I run the report in OTBI for the same template It still shows the service type n…Sreekar Raghava-Oracle 1 view 0 comments 0 points Started by Sreekar Raghava-Oracle Oracle Transactional Business Intelligence
-
Need to Set Consistent Diagonal Label Alignment for X-Axis in BIP XPT Template Bar GraphsHi, We are currently creating bar graphs using the BIP XPT template and would like to know about adjusting the alignment of labels on the x-axis. At present, the label a…
-
Secured List Views and AORThe customer has a report that displays the total number of records per table. When a logged-in user views the report, they should be able to see the count of records th…Philip Espia 3 views 0 comments 0 points Started by Philip Espia Oracle Transactional Business Intelligence
-
How to create Country Specific Context in DFF?Summary: We need to enable few fields only for Swiss Employees using a DFF and need to create Context Sensitive segments as well under the Context Value. Currently syste…Rakhi Sagar Gujarathi 1 view 0 comments 0 points Started by Rakhi Sagar Gujarathi Oracle Transactional Business Intelligence
-
Person Legislative Information Field Teacher Reference Number no longer showing dataSummary: After 24c was implemented on our Production environment we noticed that one of the fields in the subject area was no longer producing any data. The field in que…Mark Stoker 1 view 0 comments 0 points Started by Mark Stoker Oracle Transactional Business Intelligence
-
OTBI: Replace Line Feed characters from CLOB columnCLOB column contains line breaks in html. We tried following function which works only if CLOB column character length is less than 4000. REPLACE(REPLACE(REPLACE(CAST("P…Harshal Sarode-Oracle 3 views 0 comments 0 points Started by Harshal Sarode-Oracle Oracle Transactional Business Intelligence
-
subject area to fetch Assignment status all column details in OTBIHi, I am looking for subject area which can be used to fetch the details available w.r.t assignment status under "Workforce structure".the details should be like the all…
-
Report with Question and answer of candidates. Source of JobSummary: We have partners whom we asked to do job scraping from our own orc career sites. We are not using the delivered Source Section to identify the source of the can…
-
Scheduled agents are not runningHello Experts, Hope someone can help me here. We have couple of agents scheduled and were running successfully, all of the sudden we got emails from business saying none…
-
create cross subject areas analysisHello, Re: Combining Two Subject Areas in a Report In the Stuck Termination report, we would like to include the NAME, Person Number and Manager Name. The required field…Ingrid McFarlane 1 view 0 comments 0 points Started by Ingrid McFarlane Oracle Transactional Business Intelligence
-
Is there any way can we Unarchive the OAC file to BIP AnalysisHi Team, I have the dva file from OAC, is there anyway can I import the same in BIP analysis and view the output using OTBI analysis. I tried changing the file extension…
-
Compare different position attributes for two different points of timeClient needs to compare attributes related to "Workforce Management - Position Real Time" from two different points of time including an indicator of whether there was a…
-
Query Sharing: Share query with multiple users (may improve performance after initial run)Good Day Experts, In OTBI Analysis, Advanced > Query Performance and selecting 'Share query with multiple users (may improve performance after initial run)' option. Do t…
-
How can I call a rest api from an bip data modelHi, The test case is spcific, but the question is general We have a report and we want to add the item cost we found the API /fscmRestApi/resources/11.13.18.05/itemCosts…
-
OTBI Analysis Pivot vs Table View PerformanceGood Day Experts, Is there a difference in terms with the report performance when using Pivot view vs Table view in OTBI analysis? Is Table view faster to load than Pivo…
-
Link Produce Costing Setup Details with Assignment DataSummary: I am trying to link data from the following two subject areas:- "Payroll - Payroll Costing Setup Details Real Time" "Workforce Management - Worker Assignment Re…Mark Stoker 1 view 0 comments 0 points Started by Mark Stoker Oracle Transactional Business Intelligence
-
Audit Report for all Leave plans-Hi, We need to create an analysis for the following four areas. Could anyone please advise on how to calculate each of these as i did not find these values directly in a…Mr. Kumar 1 view 0 comments 0 points Started by Mr. Kumar Oracle Transactional Business Intelligence