Popular Tags
- OTBI 1,492
- Reporting 1,414
- FDI 1,255
- Fusion AI Data Platform 1,047
- Analysis and Data Visualization 1,015
- BI Publisher 888
- Analysis 696
- Oracle Fusion Analytics 626
- OAC 570
- Administration 561
- OBIEE 443
- Fusion HCM Analytics 440
- Analytics 437
- Fusion ERP Analytics 433
- BI Publisher Data Models 366
- Security 311
- HCM 294
- Oracle Analytics Cloud 272
- BIP 272
- Answers 267
- Analyses 257
- Developers 249
- Fusion Data Intelligence 242
- Data Modelling and Datasets 237
- ERP Analytics Content 221
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Report
Discussion List
-
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 88 views 2 comments 0 points Most recent by Kauan_Bohn Oracle Transactional Business Intelligence Forum -
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 51 views 0 comments 1 point Most recent by Shivangini Kotiyal Oracle Analytics Idea Lab -
5Custom labels for bars visualizationsIn the current version we are not able to customized measure labels as it's possible in i.e. Pivot Tables with Custom Headers. Possible in Pivot Tables… …but not possibl… -
How can I possibly embed a report created from a data model in a dashboard?I am currently having performance issues when using 'Sales CRM - Customers' subject area when creating an analysis in OTBI. I am thinking to do a workaround by creating …Ivony Ann Paula Salango 14 views 1 comment 0 points Most recent by Alexandru Burcea-Oracle Oracle Transactional Business Intelligence Forum -
Why does the subject area 'Sales - CRM Customers' is not showing results promptly?Maybe you can help me identify the reason why the subject area for accounts is so slow at showing results. Or is it better to create a custom subject area?Ivony Ann Paula Salango 61 views 6 comments 0 points Most recent by Ivony Ann Paula Salango Oracle Transactional Business Intelligence Forum
-
Pivot row header nameI am trying to do a Pivot but the name is not appearing for the header. I am also trying the same in Pivot for bi publisher but not sure how to do it XML is attached. Co…Dhevina 15 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Oracle Transactional Business Intelligence Forum
-
Oracle Analytics BICC vs BIPFrom Oracle documentation I understand that BI Publisher (BIP) and BI Cloud Connector (BICC) is used for exporting bulk data from ERP Cloud I have used BIP in the past a…JoyP 2.8K views 4 comments 1 point Most recent by C. Joseph Oracle Business Intelligence Applications Forum
-
How to call BIP report using REST API?Hi all, we want to call BIP report using rest api service, we were able to call it using soap using the Basic Auth however when using the rest api it's saying 404 not fo…mayank_tripathi 907 views 4 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher Forum
-
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 31 views 1 comment 0 points Most recent by RajeshPolavarapu-Oracle Oracle Fusion Data Intelligence Forum
-
OTBI Report : Department level DFF issueWe have an OTBI report which pulls the employment level details and department level details of an employee. We would like to pull certain detail of the departments base…Amulya Kadiyala 21 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
Excel is not considering my date value as date even after I tried many formatting? Need suggestionI am creating a XML publisher report where the date in the excel output should be in 'MM/DD/YYYY' format. Here I am able to achieve this format in excel however my excel…User_90781 73 views 2 comments 0 points Most recent by Nehemias-Oracle Oracle Analytics Publisher Forum
-
What is the difference between Refresh Data and Reload Data within the functional areas?I would like to know the difference between these two options within the functional areas, because we made an update in the financial categories of the accounts but the …SERGIO BARRETO 105 views 1 comment 1 point Most recent by Sumanth V -Oracle Oracle Fusion Data Intelligence Forum -
Can you reference other parameters in the initial value's logical SQL?For our projects report, we'd like to create a project manager parameter where we set the the project manage equal to the display name so that when project managers acce…Caroline Blanchard 90 views 5 comments 1 point Most recent by David Saggioro Oracle Fusion Data Intelligence Forum -
2Not able to calculate aggregated amounts for 'Discount' Column in Purchase Order Line Detail FolderWe have a requirement to generate reports in FDI that display the following metrics for Purchase Orders (POs): PO amount before discount Discount amount PO amount after …
-
Bursting ReportHi everyone, I need your help regarding bursting report. I created two Data models G_1 and G_2. In G_1, The query fetches the list of employees whose probation is about …
-
Try to find in which table I can find Default Expense Account discerptionHello everyone, I am working in BI Report and I am trying to find Default Expense Account discerption. I found the code but I could not find the discretions. the code fo…Khalid Aldosari-Oracle 162 views 5 comments 0 points Most recent by Gianni Ceresa Oracle Transactional Business Intelligence Forum
-
recruiting - recruiting real time Candidate AttachementHi Experts, I'm trying to fetch candidate attachment files/URLs by using this recruiting - recruiting real time OTBI. Unfortunately, I can't see any attachment files or …Saher 21 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
Custom report to monitor login activityLeadership would like a custom report to monitor login activity. We'd like to know which users logged in last week and which application/function they used. Sample outpu…SUSAN SANDIFER 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence Forum -
Pulling Employee Balance Result value in Person Result.Hi Experts, I have a report requirement that needs to pull the value from 'Person Result > Calculate Quickpay > Balance Result > Value'. Is there any sample query that I…
-
Prevent merged rows in xpt template when there are line breaksSummary: I run into a problem when generating a report where a field contains line breaks. The row expands to the number of line breaks present in the field. I can't fin…Edisson Gabriel López 192 views 1 comment 1 point Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum