Popular Tags
- OTBI 1,401
- Reporting 1,365
- FDI 961
- Analysis and Data Visualization 953
- BI Publisher 816
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 543
- OBIEE 421
- Analytics 342
- OAC 336
- BI Publisher Data Models 335
- Security 271
- Answers 261
- Analyses 253
- Developers 240
- HCM 237
- BIP 232
- Data Modelling and Datasets 218
- Data Connectivity 205
- ERP Analytics Content 199
- 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
-
In OTBI How to set TIMEZONE using Data format setting properties?When we change the column properties in the Data Format tab regarding the TIMEZONE, it always reverts to the default setting. We cannot set the timezone as required. The…Vinoth Mounagurusamy 236 views 7 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence -
Migrating an OTBI Dashboard to another instances gives errorI have an OTBI dashboard that is working in an instance. However when I migarte to another instance I get lot of SQL errorrs. Some ofthe errors are Code: 43113. [nQSErro…Kavita Shah 51 views 7 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Oracle Transactional Business Intelligence
-
14Increased Maximum Scheduled Rows on Scheduled OTBI ReportOrganization Name Arcadis N.V. Description Currently the limit is 25k rows for scheduled reports regardless of file type. We currently have over 25k employees in our org…Matthew Voss 242 views 8 comments 14 points Most recent by Shivanshu Gupta Oracle Transactional Business Intelligence Idea Lab
-
3Reports can be moved from One folder to another in OTBIDescription Reports and can be moved from one folder to another folder. currently it is required to copy the report and then paste to the new location and then delete fr…Farooq H Syed 206 views 4 comments 3 points Most recent by User_4JTYZ Oracle Transactional Business Intelligence Idea Lab
-
Report UsageI've been tasked with establishing a report catalog for my company that shows reports used by the company and organized by functional area. I first need to identify repo…dperezichor 13 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Need help to pull Organization ID per Hierarchy LevelWe are looking to pull the Organization ID for each hierarchical level, specifically for Level 1, Level 2, and Level 3. Please see the attached screenshot for reference,…Rhai 35 views 3 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
Global DFF not showing in Receivables - Transactions Real TimeI have created a Global DFF against flexfield RA_CUSTOMER_TRX. The BI Enabled checkbox is ticked. I have populated transactions with data in the flexfield and have run t…John Wigston 304 views 11 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
Custom column to show salaries & compensationsHi experts, I'm trying to get an analysis to show the salaries and compensations of employees from SA "Payroll - Element Entries Real Time". My question is how can I sho…Steph Yeung 21 views 2 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
1Add Structured Payment Reference field in Subject Area Cash Management - Bank Statements Real timePlease consider adding this field. It is present in the UI and a field that our organization would benefit from having it available in a subject area analysis.MLawrence 1 view 0 comments 1 point Started by MLawrence Oracle Transactional Business Intelligence Idea Lab
-
Error in SQL query from a connection to Fusion ERPI established a connection with Fusion ERP, I want to make a manual query through SQL but when I try to do it I get the following message: "There was an unexpected error…SERGIO BARRETO 80 views 15 comments 0 points Most recent by SERGIO BARRETO Oracle Fusion ERP Analytics -
"Listing of question responses for qualification area" for a flagged internal survey not show result"Listing of question responses for qualification area" for a flagged internal survey qualification area is not showing results. However, when checking another qualificat…Warunyu.N34 21 views 3 comments 0 points Most recent by Warunyu.N34 Oracle Transactional Business Intelligence
-
How to group by based on 2 different values in 2 different subject areasHi, I need to create a formula from data fetching from below 2 subject areas. Workforce Management - Worker Assignment Real Time Workforce Management - Person Real Time …Hari S 23 views 1 comment 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
How can i do Join in this two suject areas Human Capital Mgmt – Transaction X Document of RecordsWe need the report to documents of records and datas about approvals in Console Transaction. We are using this subjects areas: Human Capital Management – Transaction Adm…AlexSantos 21 views 3 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Unable to add DFF PVO.We see that PVO is not available in BICC and unable to add DFF as mentioned in Oracle support page. Attaching screenshot for reference PVO: FscmTopModelAM.ReceiptRateAdj…
-
404 not found - Deeplink IssueHello everyone, I need your assistance. I'm working on OTBI deeplink and defined this deepline by using the following code. After defining this deeplink it's through me …Saher 27 views 3 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Oracle Transactional Business Intelligence
-
1Property or Option to Exclude a Field in the Data ModelThe requirement is when we are exporting a .CSV report, we wanted to have an option to select/deselect fields to be included in the export file. We have a case that ther…Ivony Ann Paula Salango 1 view 0 comments 1 point Started by Ivony Ann Paula Salango Oracle Transactional Business Intelligence Idea Lab -
Kaustubh Deshmukh 11 views 1 comment 0 points Most recent by gclampitt Oracle Transactional Business Intelligence
-
Which Oracle Fusion Cloud GL tables do I join to get YTD nominal balances?Trying to build an opex report but only getting the current period values not year to date. Do I have to add multiple rows of sql into the data model to add all the peri…Lynda G 74 views 7 comments 0 points Most recent by Lynda G Oracle Transactional Business Intelligence
-
Need to Use two subject areas together; Procurement and PayablesHello All, I hope all is fine with you. I have an analysis using the subject area "Procurement - Procure To Pay Real Time". Business wants a field to be added "Invoice R…Abhi_19 43 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
Time Card StatusHi everyone, I am trying to create a BIP report for Time Card Change History which includes both "Time Entry" and "Time Card Status". For Time Card Status, I am trying t…Candy Miles Domingo 158 views 1 comment 0 points Most recent by Kaustubh Deshmukh Oracle Transactional Business Intelligence