Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,086
- Analysis and Data Visualization 981
- BI Publisher 844
- Analysis 676
- Oracle Fusion Analytics 579
- Administration 555
- OBIEE 432
- OAC 426
- Analytics 395
- BI Publisher Data Models 350
- Security 291
- Answers 264
- HCM 257
- Analyses 254
- BIP 253
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Report Output 184
- Oracle Analytics Cloud 177
- Customizing Reports 159
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
-
CE_RECON_HISTORY_ITEMSHI, I'm looking for a way to export via the BICC ce_recon_history_items table. However, it doesn't seem to be available in BICC... Or I can't find it in Rel13_23D_BICC_F…Daniel Sobotka 1 view 0 comments 0 points Started by Daniel Sobotka Oracle Transactional Business Intelligence -
trying to report on ORA_HRX_MX_CFDI_CONTRACT_TYPE in OTBIWe have this SQL which pulls this information for employees: select hl.meaning from per_all_assignemnts_m paa , hcm_lookups hl where paa.asg_information1 = hl.hcm_lookup…Shawn Gertler 1 view 0 comments 0 points Started by Shawn Gertler Oracle Transactional Business Intelligence
-
Schedule OTBI reports to send to SFTPHello Raghu, First of all, thank you for all the content you have made available! I really appreciate your efforts. Perhaps you can respond to this question during the N…David Pearson 2 views 0 comments 0 points Started by David Pearson Oracle Transactional Business Intelligence
-
Transfer BIP report Extract to Microsoft share pointSummary: Hi All, We have a business requirement to transfer the BIP report extraction to Microsoft share point. Please let me know is it feasible by writing the bursting…Tauseef_Akram909 1 view 0 comments 0 points Started by Tauseef_Akram909 Oracle Transactional Business Intelligence
-
Questions on Line Manager Dashboard Prompt LOV restrictionsWe are currently looking for a way to utilize the existing Line Manager Dashboard, In that we could see that the prompt LOV values that are displaying is not limited to …User_7PNH1 1 view 0 comments 0 points Started by User_7PNH1 Oracle Transactional Business Intelligence
-
Oracle OTBI maps are displaying cities in incorrect countries.As shown in the image, the city is listed as Cambridge, but despite specifying the state as Ontario and the country as Canada, it is still defaulting to Cambridge in Eng…Syed Ahmed 2024 1 view 0 comments 0 points Started by Syed Ahmed 2024 Oracle Transactional Business Intelligence
-
How to enable Reminder notifications and Expiration rule for specific Approval rules under Tasks?Summary: Hi Team, We are facing an issue wherein we can't see the option to send the Reminder and Expiration notifications for a specific rule under a task in BPM Task C…Rakhi Sagar Gujarathi 1 view 0 comments 0 points Started by Rakhi Sagar Gujarathi Oracle Transactional Business Intelligence
-
Total After In pivot table Customize the Format labelI want to customize the auto total running in the pivot table to YTD Budget / YTD Expenditure / YTD Variance …. Does anyone knows how to make it Regards.Omran Zeaiter 1 view 0 comments 0 points Started by Omran Zeaiter Oracle Transactional Business Intelligence
-
Dates on Gigs within OTBII am starting to explore the usage of gigs within my company's scope. My initial thought is to use gigs to post for positions that need coverage and to track absences & …
-
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 1 view 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 1 view 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 1 view 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…