Popular Tags
- OTBI 1,369
- Reporting 1,352
- Analysis and Data Visualization 901
- FDI 896
- BI Publisher 792
- Analysis 655
- Administration 542
- Oracle Fusion Analytics 536
- OBIEE 415
- BI Publisher Data Models 324
- Analytics 308
- OAC 274
- Answers 259
- Security 254
- Analyses 251
- Developers 235
- HCM 225
- BIP 214
- Data Modelling and Datasets 209
- Data Connectivity 205
- ERP Analytics Content 193
- Report Output 180
- BI Publisher Report Templates 178
- Agents 148
- Customizing Reports 142
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OTBI
Discussion List
-
Unable to use Heat matrix on fusion OBISummary error in using heat map view (invalid view type) Content Hi I am unable to use Heat map visualization for HCM fusion OBI. I am gettign an error "Invalid view typ…Mohit Gupta-45440 31 views 1 comment 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence -
Custom PO Print - Text Attachment Content on BI Publisher ReportSummary We are creating a custom report where we need to display the Content of Text attachment for a Purchase Order. This information is not being stored in seeded Docu…Rahul L 321 views 2 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence -
VO for ASE tablesContent Hi, are there VO for ASE tables like ASE_USER_LOGIN_INFO to extract data other then using BIP I would like to do scheduled extract to load into ADW for reporting…Mawahid 224 views 2 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence
-
HCM BI Report - how to know who deleted BI reportSummary HCM BI Report - how to know who deleted BI report Content Hi, I wonder if there is any way to know who deleted BI Report from catalog. I have full path and name …Suyoung 231 views 9 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
-
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 201 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
-
BIP Report created from OTBI AnalysisSummary Passing parameters to BIP Report created from OTBI Analysis Content How do we pass input parameters to BIP Report created from OTBI analysis?Vinod Kumar Mohanraj 41 views 3 comments 0 points Most recent by SantoshKumarBhairi Oracle Transactional Business Intelligence
-
Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataSummary Syntax to fetch pending transfer details from Data_cache column in hrc_txn_data Content Hi, We need to fetch the pending transaction Transfer details like New Lo…Nirmal Kumar L 51 views 1 comment 0 points Most recent by User_OWH0W 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 221 views 6 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
Publish Agent for SubscriptionSummary I need to know the limits of the functionality Content I used several OTBI Agents to deliver some OTBI Analysis to users. To avoid them to create their own agent…Emmanuel Baillieu 22 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle 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 182 views 8 comments 0 points Most recent by Akshay Aiyer Oracle Transactional Business Intelligence
-
Hidden fields in OTBISummary Need to find fields selected as 'Hide' as system default in column properties Content We have recently had an issue where one of our users has hidden a couple fi…Ruthie 231 views 5 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Need a SQL query to list all the scheduled OTBI Analsis and dashboardsSummary We need to review and track all the OTBI reports that are scheduled via agents Content Having the ability to query this out helps us understand who all have sche…Vishal Gala 201 views 2 comments 0 points Most recent by Akshay Aiyer Oracle Transactional Business Intelligence
-
Extract first sets of integer from entriesSummary How to extract the first sets of integer from entries in "New Calculated Measure" Content Hello Oracle Community, In "New Calculated Measure" in Analysis, how ca…Jonathan Chan gmg 121 views 8 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
Rows overcounting in AnalysisSummary How to only count the number of rows showing in an analysis Content Hello Oracle communities, When I attempt to display the total number of rows shown in an anal…Jonathan Chan gmg 91 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
Hide Set at Default button under column propertiesSummary Hiding Set as default button under column properties in an Analysis Content Is it possible to hide the 'Set as Default' button under the column properties in an …Ruthie 41 views 3 comments 0 points Most recent by Ruthie Oracle Transactional Business Intelligence
-
SQL to Query Report Library - OTBI CatalogSummary Looking for SQL or tables to report a list of all reports, properties and folder location Content Does anyone have a SQL or know the tables that would contain th…Lisa G. 763 views 4 comments 0 points Most recent by Lisa G. Oracle Transactional Business Intelligence
-
Error when using TODATE(REVENUE, YEAR) Oracle SQL functionSummary TODATE function resulted in error, what are possible alternatives to get the needed results? Content Hello Oracle Community, The below error (per enclosed 2 scre…Jonathan Chan gmg 163 views 7 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence