Welcome to the Oracle Analytics Community

Popular Tags
- OTBI 949
- Reporting 844
- Analysis and Data Visualization 647
- Analysis 572
- BI Publisher 506
- Administration 499
- obiee 282
- reports 282
- Oracle Fusion Analytics 240
- Analyses 237
- Developers 223
- BI Publisher Data Models 213
- FAW 212
- Data Connectivity 184
- Data Modelling and Datasets 160
- OBI Answers 150
- security 143
- Report Output 133
- Agents 130
- Packaging and Licensing 124
- Home and Catalog 116
- ERP Analytics Content 109
- HCM 105
- OBIEE Answers 102
- Access and Manage Data 102
Report Output
Discussion List
-
6Addition of more columns/fields to Generate and Transfer XML Transactions programOur client requirement is to generate CMF xml with additional columns from other modules like OMS/Inventory through Generate and Transfer XML Transactions program. But c…RupaliGahalot 21 views 0 comments 6 points Started by RupaliGahalot Fusion Analytics Warehouse Idea Lab
-
BI Publisher Excel - How to get multiple horizontal repeating groups working?Content Hello There, I would like to know how can I get the below output using BI Publisher for Excel. I have three groups in the xml file. G_1 -> G_2 -> G_3 Below expec…Donald 160 views 6 comments 0 points Most recent by User_307T7 Oracle Transactional Business Intelligence
-
BI Publisher ReportDear All, I edited a BI Publisher report, but the modification appears only for the user who modified this report. What should I do to resolve this issue? Please advise,Georges Mattar 30 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Cloud and Server
-
Why export link is not available under dashboard report?Hi , I want to add Export link to a report in dashboard. I added export and refresh options from report link in the property icon of the dashboard. But only refresh opti…
-
Enabling multiple report layouts as Default layout.I know we can only set one layout as default layout in reports. If we can enable multiple report layouts as default layout then we can burst multiple reports in single s…
-
2Ability to Search ESS- Using Report parameterThere are standard or Custom Reports to be scheduled for autorun, and the output is being sent to the Printer or any other communication method. If there is a failure in…
-
Error while calling Oracle BI Publisher REST API in 22ASummary: Error while calling Oracle BI Publisher REST API in 22A Content (required): Hi Everyone, Tried calling REST API for Oracle BI Publisher from postman but got err…Shashidhar Goud 264 views 11 comments 0 points Most recent by Claudio Civati Oracle Transactional Business Intelligence
-
2Enhancements to APT Sync RequestAfter the APT Sync Process has been run, the results and messages can be viewed by using the "Go to APT Sync Request" link on the run control page. While the APT Sync Re…Ruhan Ferreira 11 views 0 comments 2 points Started by Ruhan Ferreira Oracle Analytics Cloud and Server Idea Lab
-
1BIP Report Output when there are no rows should return the expected headers, not DATA_DSWe currently schedule reports to output as a CSV to the UCM for import into our local data warehouse platform. This works very well except on the occasion that the repor…
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best Practice Content This white paper provides the best practices for working with BI catalog folders, and …User720640-Oracle 87 views 2 comments 0 points Most recent by SAHIL VASYANI Oracle Transactional Business Intelligence
-
3Specify csv delimiter in data visualizationHi. In Data Visualization, i'm using the csv option to export the data, but the separator is always: comma for browser in english language, semicolon for browser in ital…User_YBCVZ 12 views 1 comment 3 points Most recent by Marcelo Finkielsztein Oracle Analytics Cloud and Server Idea Lab
-
Person secured list in BI reportUsing an administrator user, how can create a BI report that extract data with the security visibility of another user, that is not an administrator? For example: as adm…Gian Luca Triglia 11 views 0 comments 0 points Started by Gian Luca Triglia Fusion Analytics Warehouse
-
How do we extract the rejection rule details for a PO which has been rejected by predefined BPM ruleWe are preparing a POET validation BI report for a PO which flows thru a set of predefined BPM rules. In case of auto rejected PO's we need to extract the details and pr…
-
Why does the contract analysis report not bring results to one user and to others?The roles assigned to the users were reviewed and they have the same ones, only some can execute the contract report and others cannot, what could be the cause of this? …Maresa 22 views 3 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Data Persistency in Oracle Cloud - how long will Request Ids, Output/log files be available?is there any time period for which the request ids, output/log files of Oracle ERP Cloud Process/Job/ESS requests are made available? Or Will these be available always w…
-
Why does the contract analysis report not bring results to one user and to others?The roles assigned to the users were reviewed and they have the same ones, only some can execute the contract report and others cannot, what could be the cause of this? …
-
In xsl template getting error like: sun.util.calendar.ZoneInfo cannot be cast to java.util.SimpleTimHi Team, Hope everyone is doing good! We have an requirement, where we have to use Current date condition in xsl template as mentioned below, but we are getting error li…
-
Archival Transaction summary attachments in the BIP reportHi Team, We need to pull the attachments from the archived transactions in the BIP report for the reporting and audit purpose. Is there a way that we can pull the attach…Abhinay Singh-Oracle 1 view 0 comments 0 points Started by Abhinay Singh-Oracle Fusion Analytics Warehouse
-
w ehave OTBi Report skills and certfications but it showing unparallely ?HI Team, We have report facing this is how can sorted . How it looks in the report How we need it to look like:AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
How to Fetch more than 1000 records with BIP or OTBI reportSummary: Fetch more than 1000 records with BIP or OTBI report. Content (required): Hi, How to fetch more than 1000 records with BIP or OTBI report. I tried with Paramete…Sudheer YN 215 views 6 comments 0 points Most recent by Rich Merkel Oracle Transactional Business Intelligence
-
we have developed new OTBI report but when we Export analysis issue is occuringSummary: Hi Team, when we Export analysis > data > excel we get each row have person number, name some columns coming each row. and we export another way like Export ana…AjayKumar Maddipati 107 views 5 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
OTBI Report Too Slow / Not Generating ResultsSummary: Have created a report to pull all roles for all users (Audit purposes), and admittedly there is an excessive amount of data to pull. That being said, when runni…User_DKPSX 342 views 10 comments 0 points Most recent by Vijay Ramani VJ Oracle Transactional Business Intelligence
-
ORA-03113: end-of-file on communication channel error - Please HelpContent Hi All, In last few months, for the second time we are facing one quite strange issue. Random users, with random reports (or some user with all reports) are faci…User_KOLMZ 102 views 3 comments 0 points Most recent by Aman Jain-Oracle Oracle Transactional Business Intelligence
-
Earliest Working Pattern RecordSummary: 52 week working pattern start date is not reportable at the moment. Content (required): Each time the employee changes to a zero hours week there is a new worki…Dawn Cawston - CPS 48 views 2 comments 0 points Most recent by Dawn Cawston - CPS Oracle Transactional Business Intelligence
-
How to default the method of opening for an analysis that has been favorited?I have an analysis with a filter marked as a Favorite. The issue I have is when I click on the analysis from the Favorites dropdown, it opens into edit mode. Is there a …Mike Burnett 136 views 10 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
we need every year annual review value in performance documentsSummary: Hi Team, We need every year annual review value in performance documents in OTBI in sunbject area of performance rating real time. EXample--FY2021 Employee Annu…AjayKumar Maddipati 46 views 1 comment 0 points Most recent by AjayKumar Maddipati Oracle Transactional Business Intelligence
-
We have set operations report but unable to reviewSummary: Hi Team, we have set operations report but I'm unable to find out applied filters and where we need to check . any one help me on how can we review for enchanem…AjayKumar Maddipati 46 views 2 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
we have questin text and answer report but all questions are coming in columnsSummary: Hi , we have questin text and answer report but all questions and answers are coming in columns. so we get multiple records for each employee i mean 7 questions…AjayKumar Maddipati 69 views 4 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
Report showing incorrect rolling monthsSummary: Hi Team, We have absence rolling report last 12months but only showing last 10 months data for country. i mean rolling need to Feb'22 to Jan'23 but its taking o…AjayKumar Maddipati 48 views 1 comment 0 points Most recent by Dhruvjoshi23 Oracle Transactional Business Intelligence
-
How do you convert UTC time to EST for transaction reportingSummary: Content (required): We are experiencing having issues with Oracle time zones defaulting to UTC vs EST for transaction reporting. Our client business operations …MBaze 253 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence