Popular Tags
- OTBI 1,393
- Reporting 1,362
- FDI 945
- Analysis and Data Visualization 935
- BI Publisher 814
- Analysis 660
- Administration 551
- Oracle Fusion Analytics 541
- OBIEE 420
- BI Publisher Data Models 335
- Analytics 335
- OAC 318
- Security 261
- Answers 260
- Analyses 253
- Developers 239
- HCM 233
- BIP 229
- Data Modelling and Datasets 215
- Data Connectivity 205
- ERP Analytics Content 196
- 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
OTBI
Discussion List
-
Usage of LAG function in Oracle BIP's child data set - Any Limitations?Summary Usage of LAG function in Oracle BIP's child data set - Any Limitations? Content Hello, I am trying to LAG function in a child dataset of Oracle BIP but it gives …SantoshKumarBhairi 31 views 1 comment 0 points Most recent by SantoshKumarBhairi Oracle Transactional Business Intelligence -
'Publish for Subscription' in OTBI AgentContent Hi, can anyone point me to any information on how to best utilise this feature within OTBI agents. Ideally I am looking to establish a way to set an agent to not…Linda Stelling-61686 75 views 4 comments 0 points Most recent by Linda Stelling-61686 Oracle Transactional Business Intelligence -
Export Analytic XML structure (not data) via analytics-wsSummary Back up analytics using analytics-ws Content I am wanting to do some partial automation with version control/backups using the analytics-ws. Does anyone know if …Wade Wilson 101 views 6 comments 0 points Most recent by Wade Wilson Oracle Transactional Business Intelligence
-
Customize the embalmed Dashboard page option(Hide Edit dashboard)Summary Customize the embalmed Dashboard page option(Hide Edit dashboard) Content Hi Team, I have created a Custom page and added a dashboard into this page. I am lookin…Murali Peddini 61 views 1 comment 0 points Most recent by [Deleted User] Oracle Transactional Business Intelligence
-
Oracle Fusion OTBI Direct Database Query/ReportSummary Querying Oracle Fusion OTBI feature is being deprecated for CLOUD environment from 19A releases Content Creating Reports with Direct Database Query in Oracle Fus…Senthilrajan V 383 views 9 comments 0 points Most recent by Senthilrajan V Oracle Transactional Business Intelligence
-
What is the privilege for "Create Direct Database Query" in OTBISummary What is the privilege for "Create Direct Database Query" in OTBI Content Dear All, I have a custom BI Role for Line Managers to access their BI Dashboard. Since …Adil Muhammad 81 views 6 comments 0 points Most recent by Senthilrajan V Oracle Transactional Business Intelligence
-
get greatest of two dates in OTBIContent Hi, I need to find greatest /least of two dates in OTBI using formula how can we do this in OTBI?Parthiban Vaithiyanathan-86705 71 views 6 comments 0 points Most recent by Prudence K Oracle Transactional Business Intelligence
-
Way to monitor custom scheduled BI Publisher report in the cloud?Summary Looking for way to monitor the status of scheduled jobs inside the fusion cloud environment Content We have multiple critical scheduled reports and process that …user10244390 199 views 6 comments 0 points Most recent by Wade Wilson Oracle Transactional Business Intelligence
-
Security Role allowing Mgmt to stop scheduled reports others have developedSummary Security Role allowing Mgmt to stop scheduled reports others have developed Content My reporting team has the following concern and would appreciate any advice. …Rich R 31 views 2 comments 0 points Most recent by Rich R Oracle Transactional Business Intelligence
-
Dynamic date variables using 'Between' calendar date promptSummary How do I set dynamic, default server variables on a calendar date that uses 'between' dates? Content Hello, I want to set a default date value on my dashboard da…slgott 51 views 2 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
OTBI: OTBI Agent with SFTP DestinationSummary How to Setup OTBI Agent to export report results to SFTP Server Content Hello All, I have a request to export the result output of an OTBI report to an SFTP serv…Fongang 883 views 3 comments 0 points Most recent by User_5NGE4 Oracle Transactional Business Intelligence
-
OTBI Agent with SFTPSummary Setting up an OTBI agent to invoke a server script Content Hello Everyone, Does anyone have a documentation on how to setup an OTBI Agent to send a report output…Alvaro Couto 191 views 7 comments 0 points Most recent by Fongang Oracle Transactional Business Intelligence
-
Move Export OptionsContent Hi - is there a way to move the export options from the bottom of the analysis to the top, similar to how we can move the paging controls?Prudence K 52 views 5 comments 0 points Most recent by [Deleted User] Oracle Transactional Business Intelligence
-
OTBI Analysis export Excel sheet renamingSummary Setting up Excel sheet name Content Hi All, Is there any trick to change Excel sheet name in OTBI? When we exported any analysis the sheet name is ‘Sheet1’. Can …Alvaro Couto 71 views 1 comment 0 points Most recent by Julian Challenger-Oracle Oracle Transactional Business Intelligence
-
OTBI - The specified criteria didn't result in any data. when adding department under workforce manaContent Hi, I've added the columns I need from the WORKER folder and the result come back nicely. As soon as I add a column from any other folder, no results are brought…King Jack 242 views 4 comments 0 points Most recent by [Deleted User] Oracle Transactional Business Intelligence
-
Is Orders data available through the OTBI layer in Order Management / SCM?Summary Is Orders data available through the OTBI layer in Order Management / SCM? Content Is Orders data available through the OTBI layer in Order Management / SCM? Rea…Shalindra Singh 51 views 1 comment 0 points Most recent by Shalindra Singh Oracle Transactional Business Intelligence
-
OTBI Report Date Format is not holding when exporting to ExcelSummary OTBI Report Date Format is not holding when exporting to Excel Content I have a report and the date format is set to the local time zone. The date is formatted c…Robin Friedberg O'Connor 432 views 5 comments 0 points Most recent by Julian Challenger-Oracle Oracle Transactional Business Intelligence
-
Any way to bypass the row LimitationSummary Bypass Row Limitation Content Is there anyway to bypass the row limitation? There are times I need to be able to analyze more than 25,000 rows of data. This is c…Robin Friedberg O'Connor 473 views 11 comments 0 points Most recent by Gustavo Erthal Oracle Transactional Business Intelligence
-
Current Timestamp Not Updating on OTBI ReportContent Hello, I'm currently building an HCM Report where it looks at the Timestamp of the change (Hire/Term/etc.) and subtract 1 minute from that timestamp. Then I was …Matthew Voss 364 views 8 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
OTBI Variable Presentation Date Prompt Format DD-MON-YYYYSummary Users need to be able to enter a date in DD-MON-YYYY format at the prompt Content Our date format changed to dd-MON-yyyy (15-MAY-2017), but the only way the repo…Brenda Jacks-49721 286 views 1 comment 0 points Most recent by RichardChan Oracle Transactional Business Intelligence