Popular Tags
- OTBI 1,364
- Reporting 1,352
- Analysis and Data Visualization 898
- FDI 883
- BI Publisher 788
- Analysis 654
- Administration 542
- Oracle Fusion Analytics 535
- OBIEE 415
- BI Publisher Data Models 323
- Analytics 309
- OAC 270
- Answers 259
- Security 253
- Analyses 251
- Developers 234
- HCM 219
- BIP 213
- Data Modelling and Datasets 208
- Data Connectivity 205
- ERP Analytics Content 192
- Report Output 179
- BI Publisher Report Templates 178
- Agents 148
- Customizing Reports 141
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Analyses
Discussion List
-
Something off in SQL expression for criteriaSummary Trying to capture last month's data Content The report functions with the expressions below; however, It doesn't seem to actually capture the last day of the pre…Cassandra Kurth 51 views 2 comments 0 points Most recent by User_UEHCK 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
-
How To Find Advanced Custom Object Subject Area In OBIEESummary How To Find Advanced Custom Object Subject Area In OBIEE Content Hi, Where do I find the Advanced Custom Object Subject Area in OBIEE? I need to find Custom Obje…edpalomo 53 views 2 comments 0 points Most recent by edpalomo Oracle Transactional Business Intelligence
-
AR Aging Bucket (Fusion OTBI)Content I am facing a problem with OTBI. I need to create an analysis using a subject area for receivable aging bucket but there is no subject that is called aging I tri…Maram Abuzaid 531 views 1 comment 0 points Most recent by Sahil Makhiza Oracle Transactional Business Intelligence
-
set metric alert for dashboard or analysis (Fusion OTBI)Content Hello, I have a question regarding metric alert or email notification, let suppose there is KPI for total sales MTD (1M), I want to add a condition to alert the …Maram Abuzaid 41 views 2 comments 0 points Most recent by Maram Abuzaid 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 225 views 8 comments 0 points Most recent by CB 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
-
OTBI Outer Join Subject AreasSummary How to connect subject areas where I need to represent null for rows that are not existing in other subject area Content Hello, I am struggling with creating an …VipinSharma 1.1K views 12 comments 0 points Most recent by Syed Misbauddin-Support-Oracle 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 41 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Drill to another Compound LayoutSummary How can I let users drill into a number that takes them to a 2nd compound layout on an analysis? Content Hello, I have an analysis that I plan on making into a d…slgott 81 views 2 comments 0 points Most recent by MaartenDIF Oracle Transactional Business Intelligence
-
Calculated column not giving valuesContent I'm creating an AP dashboard where I want to combine the subject areas for AP invoices and payments to show in a single column whether an invoice is paid/unpaid …MaartenDIF 243 views 13 comments 0 points Most recent by MaartenDIF Oracle Transactional Business Intelligence -
How to add row number (fixed order) in analysis?Summary How to add row number (fixed order) in analysis? Content Hello Oracle Team, Is there a way to add row numbers in analysis? When I used RCOUNT(1), the row number …Jonathan Chan gmg 684 views 4 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
Steps to audit BI folder changes?Summary In what way can we identify what user moved heh folder in BI Catalog? Content In our PROD pod, we have several folders under the custom folder location that incl…User_VR8E0 311 views 4 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence
-
oracle transactional business intelligence cloud service documentationContent Hi Experts, Please can you share the oracle transactional business intelligence cloud documentation link. I am not able to find it. Best Regards ParmitParmit Choudhury-Deloitte 51 views 6 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence
-
1z0-591 OBIEE CertificationSummary Need assistance on preparation of 1z0-591 OBIEE exam Content Hi Experts, The course is all about 12 C and the exam is for 11 g.So can anyone help me how to prepa…priscilla balusupati 102 views 2 comments 0 points Most recent by priscilla balusupati Oracle Transactional Business Intelligence
-
Dividing MetricsSummary I am trying to divide two metrics -- Not working!! Content I am trying to divide two metrics and am not getting the results I need. Can someone help? The number …slgott 203 views 12 comments 0 points Most recent by Cyrille Saulnier-Oracle Oracle Transactional Business Intelligence
-
Can data model data be called out by infolets on Oracle Cloud/Fusion?Summary In addition to analysis data, can data model information be added to infolet on Oracle Cloud/Fusion? Content Hello Oracle Community, Is there anyway to post data…Jonathan Chan gmg 51 views 6 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
How to display count(new customer account opened) from lasy year's month-to-date in analysisSummary How to display the amount of new customer account opened in last year's month-to-date, together with this year's month-to-date data Content Hello Oracle Communit…Jonathan Chan gmg 71 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
How to create a prompt, Year-Month format, in analysis while not having a "Month" dimension?Summary The goal is to enable end users to look at an analysis by year-month periods (ex. YYYY-MM, 2020-01), but "Month" dimension is not available within the subject ar…Jonathan Chan gmg 222 views 6 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
Scheduled Report JobsSummary Deails of Scheduled Report Jobs Content Hi Experts, I would like to know is there any seeded report to pull the complete details of scheduled report jobs in BI o…Charan Kollipara 181 views 8 comments 0 points Most recent by Akshay Aiyer Oracle Transactional Business Intelligence