Popular Tags
- OTBI 1,509
- Reporting 1,428
- FDI 1,330
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,023
- BI Publisher 907
- Analysis 699
- Oracle Fusion Analytics 639
- OAC 615
- Administration 568
- Fusion HCM Analytics 463
- Analytics 463
- Fusion ERP Analytics 461
- OBIEE 446
- BI Publisher Data Models 372
- Oracle Analytics Cloud 312
- Security 309
- Fusion Data Intelligence 298
- HCM 297
- Fusion Data Intelligence FDI 280
- BIP 274
- Answers 267
- Analyses 258
- Developers 250
- Data Modelling and Datasets 241
Reporting
Discussion List
-
Number columns are in text format in Excel exportHi, when our users export the data from Business Intelligence Publisher report to Excel, they want to perform additional analyses. Hence, they need to perform calculatio…Ante Obradović 806 views 2 comments 0 points Most recent by Ante Obradović Oracle Transactional Business Intelligence Forum -
The columns like BANK_NAME and BANK_BRANCH_NAME are blank in iby_ext_bank_account tableWe have a requirement to generate a report retrieving the details of changes made by an employee to their bank details in the payment methods page. We have created a use…Anusha B S 75 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence Forum -
11OTBI Audit ReportsDescription We need reports for auditing modifications to OTBI reporting components. Only mod dates show, so we have no visibility into which user made the change or wha…Jeff Rich-Terillium 1.5K views 42 comments 11 points Most recent by Parag Hiremath Oracle Transactional Business Intelligence Idea Lab -
ReplaceI am using the measure specified below to replace '-' for '/' in string. CASE WHEN "Input Value"."Input Unit of Measure"='D' THEN REPLACE(CAST("Element Entry Value"."Dis…Julia Kiszelewska1234 21 views 0 comments 0 points Most recent by Julia Kiszelewska1234 Oracle Transactional Business Intelligence Forum -
Calendar table in ODVHello , I have a question with ODV. Is it possible to create a custom calendar table in ODV ( with spreadsheet or sql query) and then link it to a report dates columns i…User_RS68A 243 views 5 comments 0 points Most recent by Federico Venturin - Oracle Oracle Analytics Forum -
Can we run the OTBI Analysis from Scheduled Processes?Hi Folks, Is there any way to make the OTBI Analyses available under Scheduled Processes so that it is easy for all users to run them straight from the Scheduled Process…Saahil Umratkar 777 views 4 comments 0 points Most recent by Saahil Umratkar Oracle Transactional Business Intelligence Forum -
Catalog Object Links in OAC dashboardHi all, We are migrating OBIEE 12c reporting to OAC. In OBIEE, some PDF, XLS files were kept in res/s_Alta directory. These files could be opened from dashboards by addi…Debadrita Ghosh-Oracle 286 views 8 comments 0 points Most recent by Federico Venturin - Oracle Oracle Analytics Forum -
BI Publisher Data Model - Is there a way to configure a parameter to accept multi-line free texts?Users can only input single line of texts on a Free text field parameter.JFabroada 706 views 1 comment 1 point Most recent by Simonab-Oracle Oracle Analytics Publisher Forum -
BI Publisher Interactive Output VERY WEIRD behavior. Inbuilt total characters per row restriction ?I've written a BIP report and am using the interactive output. I noticed it was only bringing back about 95 of my 3000 rows that the data model retrieved. I used a param…ScottHillier 183 views 4 comments 0 points Most recent by ScottHillier Oracle Analytics Publisher Forum -
How to add Refund amount column in Refund listing report in OTBI report in oracle fusion.Could you please help us of how to add Refund amount column in Refund listing report in OTBI report in Oracle fusion Receivables.SAITEJA_01 11 views 0 comments 0 points Most recent by SAITEJA_01 Oracle Transactional Business Intelligence Forum -
How to display one record in two different languages in OTBIHi everyone, I created an OTBI report and clients want to view the output in two different languages. For example: a client creates a job request and that job is shown i…Saher 12 views 0 comments 0 points Most recent by Saher Oracle Transactional Business Intelligence Forum -
I'm trying to use a formula that results in a percentage, but instead i'm getting a integer numberHello Oracle Community, This is the formula, that I'm using, (Value A * Value B) / (Value C * Value D) The selected column is the final result of that formula: But, the … -
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,George Mattar 93 views 4 comments 0 points Most recent by Simonab-Oracle Oracle Analytics Publisher Forum -
How to know if FAW for HCM is available/enabled in our system?I'd like to know if FAW for HCM is available/enabled in our system. Is the any documentation related on how to enable FAW? Is the subscription different from Oracle Anal…Welsey 22 views 2 comments 1 point Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion Data Intelligence Forum -
Oracle R12.1.3 XML Publisher XLS TemplateSummary Oracle R12.1.3 XML Publisher XLS Template Content Hi, We have patched Oracle R12.1.3 to allow XML Publisher XLS Template. And followed BI Publisher: How to creat… -
1Documents of Record Real Time: Get a column to see the DOR attachment link?I would linke to see the link of the DoR attached per employee in OTBI report, so I have all in once place. I can see this information per user in Mass Download DoR so i…Amandine Corbel 1 view 0 comments 1 point Most recent by Amandine Corbel Oracle Transactional Business Intelligence Idea Lab -
8Exporting DV Canvas via dashboard is currently not supportedOrganization Name : UF Health Jacksonville Description (Required): In order to to schedule a Dashboard to email out, I had to create same DV in self-service and same con… -
Data refresh "Workforce Management - Documents of Record Real Time"Hi everyone, We created a BIP using "Workforce Management - Documents of Record Real Time" subject area. The purpose of this report is to display the documents uploaded …Ruchi Shivhare 84 views 3 comments 0 points Most recent by Renuka Nuguru-Oracle Oracle Analytics Publisher Forum -
3OTBI - New feature "Print Entire Dashboard" to print an Entire Dashboard (with all pages) to PDF.OTBI Dashboard - It would be nice and useful to have a feature/option to print an Entire Dashboard (with all pages) to PDF. Currently, don't have any option to print an …Harish Malik 21 views 0 comments 3 points Most recent by Harish Malik Oracle Transactional Business Intelligence Idea Lab -
Oracle Fusion OTBI > Ability to Rotate Rows Into ColumnsHello, We would like to design a report where the columns ‘Date’, ‘Time Entry Start Date and Time’, and ‘Time Entry End Date and Time’ are rotated. Please find below scr…Bernard T 3 views 0 comments 0 points Most recent by Bernard T Oracle Transactional Business Intelligence Forum