Popular Tags
- OTBI 1,392
- Reporting 1,362
- FDI 944
- Analysis and Data Visualization 932
- BI Publisher 813
- Analysis 660
- Administration 551
- Oracle Fusion Analytics 541
- OBIEE 420
- BI Publisher Data Models 335
- Analytics 335
- OAC 315
- 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
Reporting
Discussion List
-
Not able to Print Enterprise Contract Terms in Custom Report as ARTICLE_TEXT is HTML embeddedselect ch.contract_number, cab.label||''||caa.article_title article,fl.meaning,cab.document_id,cv.ARTICLE_TEXT from okc_k_headers_vl ch,okc_k_articles_b cab, okc_article…Snehashis_Santra 11 views 3 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher -
Help with Transaction History Report in OTBI (DUE DATE and OUTSTANDING BALANCE)I aim to generate a comprehensive report of transaction history. I need the fields DUE DATE and OUTSTANDING BALANCE of the transaction to be displayed in my analysis. Fo…Kauan_Bohn 36 views 2 comments 0 points Most recent by Kauan_Bohn Oracle Transactional Business Intelligence -
1Ability to use printer bursting logic for OIC (Web-Based) BIP ReportsWe have a business requirement to implement printer bursting logic for an OIC based BIP report, current functionality does not allow for printer bursting to be used in O…sabailey 14 views 0 comments 1 point Started by sabailey Oracle Transactional Business Intelligence Idea Lab
-
Want to customise Standard Oracle SalesOrder Report by adding new columnsI want to add few new columns in salesorder standard Oracle Report ,but unfortunately standard XML attached in the datamodel does not have the tags that I require , Is t…
-
1Ability to upload .xlsm (macro enabled excel) file in EPM CloudBusinesses extensively utilize Macro enabled Excel (.xlsm) for ad-hoc reporting. Integrating Excel with SmartView functionalities addresses numerous ad-hoc reporting req…Shivangini Kotiyal 32 views 0 comments 1 point Started by Shivangini Kotiyal Oracle Analytics Cloud and Server Idea Lab
-
BI Publisher PermissionsSummary BIP Security Permissions Content Hi, I have to setup permissions on a folder which holds several reports but as I add a Full access permission a folder icon appe…Barry Stamp-73691 352 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence
-
6Dynamically select your metric or dimension (column selector)Description I would like to have a list off metrics to show in my dashboard. Based on my selection you see this in a line graph or other type off graph. Some for the dim…User_7CMER 91 views 2 comments 6 points Most recent by User_ZHCT5 Oracle Analytics Cloud and Server Idea Lab
-
Can we print an image attachment from UCM in BIP reportWe have a requirement to print an image attachment stored in UCM in a custom BIP report. In order to print this image in BIP report, we need the base64 encoded image dat…Radhika Sharma 702 views 4 comments 0 points Most recent by User_ZICBC Oracle Fusion Data Intelligence
-
4Ability to set a custom width for a column in a table/pivotDescription A feature to control the width of columns in a table or pivot. Use Case and Business Need Some columns contain a larger amount of text in the header or textb…Eduard Paraschiv 31 views 3 comments 4 points Most recent by Marcelo G. Proaño Oracle Analytics Cloud and Server Idea Lab
-
28Add a Data Connector for Sharepoint Lists in Office 365Organization Name State of Maine Description State of Maine uses Office 365, and with the COVID-19 Pandemic a proliferation of MS Teams groups is happening. Each team co…Jeff Jordan 547 views 7 comments 28 points Most recent by Brett Wist Oracle Analytics Cloud and Server Idea Lab
-
7Native FCCS integrationRequest for a native Oracle integration of FCCS data into FDI, similar to that already setup for ERP. We're aware that this is possible via EPM Pipeline, but would like …Andrew at MKL 48 views 2 comments 7 points Most recent by Andrew at MKL Oracle Fusion Data Intelligence Idea Lab
-
8Ability to hide columns / attributes in data prep but still be able to use theDescription In data prep within a project I would like to be able to hide a column so it's not visible in report view but still usable for joins, calculations etc. Use C…Nina Asenbauer 61 views 4 comments 8 points Most recent by User_1VPJ8 Oracle Analytics Cloud and Server Idea Lab
-
3Add metric for "Oracle Fusion Transactional Business Intelligence Cloud Service" (B84576) to "ServicDescription We are unable to find metric B84576 (OTBI) on the "Metrics for Oracle Fusion Cloud Applications" document. This document lists following for example: -------…Shabnam Bombaywala 61 views 4 comments 3 points Most recent by Sam.T Oracle Transactional Business Intelligence Idea Lab
-
10Eliminate 'Ghost Nodes' in HierarchiesRequest to eliminate 'ghost nodes' caused by flattening of hierarchies in FDI as this causes significant confusion for end users.Andrew at MKL 61 views 4 comments 10 points Most recent by Andrew at MKL Oracle Fusion Data Intelligence Idea Lab
-
Having issue seeing the right numbers in FP&A classic BI dashboards & reports in FDIHi Team, Working on getting the right utilization figures to FP&A classic BI dashboards & reports on classic home of FDI Attaching the difference in figure on your left …akhilsaikaza 32 views 2 comments 0 points Most recent by akhilsaikaza Oracle Fusion Data Intelligence -
I need to Employee Signed Date and Manager Signed Date from the position description documenti need a SQL query to fetch the Employee digitally Signed Date and Managers digitally Signed Date from position description Document which is attached in DOR. Please let…Chetana2000 21 views 1 comment 0 points Most recent by RajeshPolavarapu-Oracle Oracle Fusion HCM Analytics
-
16REST API for Oracle Analytics CloudDescription OAC should have documented REST api interface that allows to do the following: * System Management: Take snapshots (complete/RPD only), store snapshots to ob…prakashj 404 views 12 comments 16 points Most recent by User_1VPJ8 Oracle Analytics Cloud and Server Idea Lab
-
Cells are not merged for formulasDear All, I have developed a custom OTBI report to retrieve data related to the payable module; however, invoice number and supplier number are merged when the data is e…George Mattar 31 views 3 comments 0 points Most recent by Regie Mercado Oracle Transactional Business Intelligence
-
BI Publisher download PDF on chrome is loading.htmlSummary When trying to download any report the name is xdo and it downloads as loading.html Content Hello Everyone, I am trying to download a report in .pdf format but t…Ulises Gutierrez-Guel 511 views 9 comments 0 points Most recent by Sandeep S. Chauhan-Oracle Oracle Analytics Publisher
-
BI Publisher Error - message39 - how do I fix?Summary BI Publisher Error - message39 - how do I fix? Content I have the most up to date version of OPA installed on my machine. I have also got BI Publisher installed,…Paul Howard-91740 448 views 5 comments 0 points Most recent by Pratiksha Govindwar Oracle Analytics Publisher