Popular Tags
- OTBI 1,417
- Reporting 1,378
- FDI 1,013
- Analysis and Data Visualization 967
- BI Publisher 830
- Analysis 668
- Oracle Fusion Analytics 563
- Administration 554
- OBIEE 426
- OAC 375
- Analytics 365
- BI Publisher Data Models 340
- Security 284
- Answers 264
- Analyses 253
- HCM 246
- Developers 240
- BIP 237
- Data Modelling and Datasets 220
- Data Connectivity 206
- ERP Analytics Content 200
- BI Publisher Report Templates 192
- Report Output 181
- Customizing Reports 153
- Agents 151
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Answers
Discussion List
-
Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is used?Summary Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is used? Content Hi, Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is…Aloka Bhattacharya 331 views 5 comments 0 points Most recent by Aloka Bhattacharya Oracle Transactional Business Intelligence -
Finding the alphabets from a Alphanumeric in OTBI.Summary: I have a requirement to identify the alphabets (be it upper/lower case) from a string. The format of the sting is as follows: SSN: XXX-XX-XXXX (112-10-1234) TIN…satya_nvs 187 views 2 comments 0 points Most recent by Venkat Koduvayur-Oracle Oracle Transactional Business Intelligence
-
How to Dipslay Total at the Top of Stacked Vertical Bar ChartSummary Need to know how to Dipslay Total at the Top of Stacked Vertical Bar Chart Content While representing data as vertical bar chart (due to groupings used/needed) I…Krishnaraja Nelli-47394 91 views 4 comments 0 points Most recent by Noelle Bartlam-Oracle Oracle Transactional Business Intelligence
-
Table name to capture reverse termination date & its details for reverse terminated employeesSummary Table name to capture reverse termination date & its details for reverse terminated employees Content Hi All, In which table I can find the reverse terminated da…NIRMAL KUMAR L 393 views 1 comment 0 points Most recent by Parag Hiremath Oracle Transactional Business Intelligence
-
Is there possible to create prompts in combine resultDear , i have otbi report which showing result based on two criteria means combine and now i want to click on colleague name and opens new report based on that name so i…Mirza_Adeel 61 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directoSummary OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directory. Content Hi, I have an OTBI Report running into error when…Aloka Bhattacharya 102 views 5 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
Text AnalyticsSummary step by step procedure to proceed Text Analytics in OBIEE 11g Content Hi, I need step by step procedure to proceed Text Analytics in OBIEE 11g. I'll be happy to …Andrews J Stanley 52 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
How to run an OTBI Analysis and save output without having it deliveredSummary How to run an OTBI Analysis and save output without having it delivered Content Currently in Schedule option of of OTBI analysis , there is option to deliver to …Shivaji Muttarapu 1.1K views 8 comments 0 points Most recent by Shivaji Muttarapu Oracle Transactional Business Intelligence
-
Fusion Dashboard AuditSummary: Fusion Dashboard Audit Content (required): Hi Team, We have requirement to extract the list of HCM dashboard name, dashboard path and how may user has ran the d…Community DW Integration 61 views 2 comments 0 points Most recent by Srinivas Pendyala-Oracle Oracle Transactional Business Intelligence
-
Need to find where the Certificate Number is in the Subject AreaSummary: Need to retrieve the Certificate Number under Licenses and Certifications for an employee "- All Profile Content"."Content Type" = 'Licenses and Certifications'…PamS 3.3K views 15 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
OTBI Report Date Format changes when exporting to ExcelContent We are trying to change the formatting of a column in OTBI report by changing the column properties of each date columns. We are using the following format: Date…ZenG 939 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Run an analysis (agent) as target user, but deliver to proxy userContent We have some sensitive data which are automatically shielded off through HR roles in the BI Catalog because they are obiee analysis in hcm subject areas. We have…MaartenDIF 74 views 3 comments 0 points Most recent by MaartenDIF Oracle Transactional Business Intelligence -
Custom column in OTBI analysis with case statement is not displaying data in graphSummary I have created an analysis with one of the columns using case statement to derive the status of the performance document based on certain conditions. The graph d…Harpreet Shergill 71 views 4 comments 0 points Most recent by Harpreet Shergill Oracle Transactional Business Intelligence
-
OTBI session and repository variables full listContent Hi, could anyone provide the full list of session variables and repository variables available in OTBI Regards, AlbertoAlberto Boccato 570 views 6 comments 0 points Most recent by mgoswami Oracle Transactional Business Intelligence
-
OTBI: Diff of Two dates to get Age is rounded to next highest valueSummary OTBI: Diff of Two dates to get Age is rounded to next highest value Content OTBI: Diff of Two dates to get Age is rounded to next highest value Example: If diffe…Srinivas Challa 700 views 3 comments 0 points Most recent by Matthias Ludewig Oracle Transactional Business Intelligence
-
As Of Date Report Not Pulling Current Row if Ethnicity Is Included In OutputContent The report below is an "As Of" dated report. The issue i am seeing is that if ethnicity is included in the output of the report multiple rows are pulled for asso…User_EQ8R5 41 views 2 comments 0 points Most recent by User_EQ8R5 Oracle Transactional Business Intelligence
-
BI Publisher Data Model completes with errorsSummary BI Publisher Data Model completes with errors Content Hi Everyone, I'm trying to create a BI Publisher report using HRC_TXN_HEADER and HRC_TXN_DATA tables. Here …Dhanuka Chamal 202 views 3 comments 0 points Most recent by Dhanuka Chamal Oracle Transactional Business Intelligence
-
Is there a way to specify new default colors in OTBISummary Overwriting Default Colours for bar graphs and Pie Charts Content Hello Everyone, I'm looking for a way to overwrite the default colors for graphs. I know that I…Rob F 125 views 5 comments 0 points Most recent by SantoshKumarBhairi Oracle Transactional Business Intelligence
-
BI Publisher Excel Report Fails With Error "java.lang.OutOfMemoryError: Java heap space"Summary BI Publisher Excel Report Fails With Error "java.lang.OutOfMemoryError: Java heap space" Content Hello Everyone, We are on Oracle Cloud Application 20B. I was tr…Dhanuka Chamal 383 views 4 comments 0 points Most recent by Dhanuka Chamal Oracle Transactional Business Intelligence
-
Smart view no longer connect to OBIEEContent Hi, I have installed the latest smart view and now found out that the private connection to obiee is no longer provided. below is the screenshot of old smart vie…Jenny Tan 33 views 1 comment 0 points Most recent by [Deleted User] Oracle Transactional Business Intelligence