Popular Tags
- OTBI 1,401
- Reporting 1,365
- FDI 961
- Analysis and Data Visualization 953
- BI Publisher 816
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 543
- OBIEE 421
- Analytics 342
- OAC 336
- BI Publisher Data Models 335
- Security 271
- Answers 261
- Analyses 253
- Developers 240
- HCM 237
- BIP 232
- Data Modelling and Datasets 218
- Data Connectivity 205
- ERP Analytics Content 199
- BI Publisher Report Templates 184
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Answers
Discussion List
-
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 384 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 101 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 51 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 63 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.2K 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 928 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 71 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 73 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 528 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 691 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 201 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 123 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 371 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 31 views 1 comment 0 points Most recent by [Deleted User] Oracle Transactional Business Intelligence
-
Presentation Variable Prompt causes Error on Results tab, but not in Open linkSummary AsOfDate prompt causes errors OPR4ONWY:U9IM8TAC:OI2DL65P Content I added the follow prefix to my analysis: SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}'; Then …Brenda Jacks-49721 221 views 8 comments 0 points Most recent by CBeks Oracle Transactional Business Intelligence
-
BI Publisher Excel TemplateContent Hi All, We have a nested table and beacause of this we are receiving this row mark in front of the data Printing and Stationery" rowMark="2 Does anyone know how …Kunal Daya-76859 21 views 2 comments 0 points Most recent by _IshanAgarwal Oracle Transactional Business Intelligence
-
Display photographs in OAC AnalysisSummary Display photographs in OAC Analysis Content Facing a strange issue in OAC while displaying photos. Customer is capturing photographs of readings. These photos ar…SaurabhJaiswal-Oracle 42 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence