Popular Tags
- Reporting 1,301
- OTBI 1,229
- Analysis and Data Visualization 816
- BI Publisher 689
- FDI 669
- Analysis 624
- Administration 516
- Oracle Fusion Analytics 474
- OBIEE 392
- BI Publisher Data Models 288
- Answers 253
- Analyses 247
- Developers 231
- Security 206
- Analytics 205
- Data Connectivity 198
- HCM 188
- Data Modelling and Datasets 187
- ERP Analytics Content 168
- Report Output 165
- BIP 153
- Agents 146
- BI Publisher Report Templates 143
- OAC 135
- Packaging and Licensing 128
OTBI
Discussion List
-
how to calculate Tenure dynamically (including for a historical date)Summary: I have an active HC report where I included a Tenure field using below formula however it is not good when we try to pull the report for a historical date. I am…Abhishek Bagh 64 views 0 comments 0 points Started by Abhishek Bagh Oracle Transactional Business Intelligence -
How to pull Spouse Date of Death in OTBI reportSummary: The requirement is to pull the Employee's Spouse's Date of Birth but the field should be left blank if the employee doesnot have a spouse or if the spouse is de…Iswarya Lakshmi Priya-Oracle 11 views 0 comments 0 points Started by Iswarya Lakshmi Priya-Oracle Oracle Transactional Business Intelligence
-
How to link Receivables - Customer Real Time and Receivables - Payment Schedules Real Time in OTBISummary: I am wanting to create a report with certain bill-to customer information that is not located within the Receivables - Payment Schedules Real Time subject area,…Georgina Sawyer 66 views 0 comments 0 points Started by Georgina Sawyer Oracle Transactional Business Intelligence
-
FTE Breakdown (last year of 2020 and 2021)Summary: I want to make a report showing FTE by worker category, department, legal employer... per end of a period like end of month, end of quarter and end of year. I t…
-
Add to briefing book option takes 10-15 Min to load on published Dashboard over homepageSummary: We have created a custom dashboard which contains multiple analysis, when we click on any analysis to Add to briefing books it takes around 10-15 mins to give t…Shubham Singh 22 views 0 comments 0 points Started by Shubham Singh Oracle Transactional Business Intelligence
-
Excel/Data Model only runs once then I have to close AnalyticsSummary: The help desk was trying to help me with the installation of the BI Publisher Template Builder for Excel and the Oracle ADF 11g Desktop Integration Add-in for E…
-
Group by Ethnicity and Headcount in AnalysisSummary: Issue in Analysis when count of ethnicty is added in Case statement Hi Team, I have taken the Employee Ethnicity Analysis from Line Manager Dashboard from the d…Darius Sunder 63 views 0 comments 0 points Started by Darius Sunder Oracle Transactional Business Intelligence
-
Communities in LearnSummary: Hi, I am working on LEARN report. I have to pull 'communities' field into my analysis can anyone provide me the specific Subject area and field name through whi…Praveen_Chouhan 1 view 0 comments 0 points Started by Praveen_Chouhan Oracle Transactional Business Intelligence
-
Missing fields in Subject Area Workforce Management - Worker Assignment Real Time?Summary: While attempting to add a field to the query, I found that I can't locate a couple of other fields that are already on the query Content (required): I am trying…
-
Consolidate MultiList values into single fieldSummary We need to be able to see all of the multi list values against a sku in a single field Content We have several MultiList fields in our sku attributes. When repor…ALASTAIR BURNS 12 views 0 comments 0 points Started by ALASTAIR BURNS Oracle Transactional Business Intelligence
-
Javascript in OTBI Analysis Narrative - OLCSummary Javascript in OTBI Analysis Narrative Content I've tried putting a statement together where a different background image is displayed depending on learning item …Alex Mackie 102 views 0 comments 0 points Started by Alex Mackie Oracle Transactional Business Intelligence
-
How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Summary How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area) Content Hi, I'm working to extract all Quotes and their respective Quote Line It…edpalomo 21 views 0 comments 0 points Started by edpalomo Oracle Transactional Business Intelligence
-
How to add a BI Report in Dashboard to a Briefing book?Summary I'm trying to add a BI report in Dashboard to a Briefing book,but it error'd out with following error. Content A fatal error occurred while processing the reques…Nithin Channa 22 views 0 comments 0 points Started by Nithin Channa Oracle Transactional Business Intelligence
-
Table Cell level BordersSummary How to change the border color to black Content In one of my analysis which is table layout i get the attached Output. I want to change the white color to black.…Jagdish Varadraj 54 views 0 comments 0 points Started by Jagdish Varadraj Oracle Transactional Business Intelligence
-
How to build an inventory analysis coupled with time constrained measure?Summary An analysis, contain info. on on-hand-quantity and open quantity, does not produce results after 15mins of run time. This happens when a time constrained measure…Jonathan Chan gmg 2 views 0 comments 0 points Started by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
OTBI Customer SurveyContent Oracle BI development is planning OTBI feature improvements. To better understand SaaS customers’ reporting needs, usage and requirement gaps, we are conducting …User720640-Oracle 21 views 0 comments 0 points Started by User720640-Oracle Oracle Transactional Business Intelligence
-
How to modify the content of a column through a result similar to RPADSummary How to modify the content of a column through a result similar to RPAD - we want to create a report that will need to have a specific lenght per column & wish to…
-
New features - BICCC 19A patchSummary Document for new features list in BICCC - 19A patch Content New features has been added to BICCC Application as part of 19A patch, it is very good, but it will b…Senthilrajan V 12 views 0 comments 0 points Started by Senthilrajan V Oracle Transactional Business Intelligence
-
To Extract Order Header and Line details using OTBISummary looking for Sample query that works to get Header and line details of available orders using OTBI Content Hi, Can someone please provide me working sample query …Shalindra Singh 46 views 0 comments 0 points Started by Shalindra Singh Oracle Transactional Business Intelligence
-
OTBI QuestionSummary Adding field, removes others Content Hi, I am brand new to OTBI and am having issues adding a field to my Received Not Invoiced report I am attempting to build w…