Popular Tags
- OTBI 1,412
- Reporting 1,368
- FDI 993
- Analysis and Data Visualization 957
- BI Publisher 823
- Analysis 664
- Administration 553
- Oracle Fusion Analytics 552
- OBIEE 422
- Analytics 351
- OAC 345
- BI Publisher Data Models 335
- Security 274
- Answers 262
- Analyses 253
- HCM 240
- Developers 240
- BIP 234
- Data Modelling and Datasets 218
- Data Connectivity 206
- ERP Analytics Content 199
- BI Publisher Report Templates 185
- Report Output 180
- Agents 151
- Customizing Reports 149
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OTBI
Discussion List
-
Convert Date Field to "YYYY-Qx" FormatSummary Need to convert a date field from MM/DD/YYYY to "YYYY-Qx" format. Content Hi, I’m trying to convert a date field from the standard MM/DD/YYYY format into a "YYYY…User_TUN0Q 10 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications -
Why a new role cannot run OTBI reports but can run BIP reports when permissions are the sameWe have created a new role in oracle HCM. The user will be using this role for reporting needs. They can use BIP reports with no issues. But OTBI is causing problems. Th…Max W 3 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence -
Oracle Fusion OTBI and Data/Role SyncHi Team, I am a Oracle Security Specialist and often have to play with data sync and validate in UI and in OBI layer reporting. When I do a HDL to Bulk terminate users I…Nicolas Trojack 5 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
Looking for PO line quantity column in Purchasing Subject AreasHi, I am preparing an OTBI report for Purchase Order and looking for Line Quantity Column, i see Ordered Quantity column in subject area- Procurement - Purchasing Real T…Sudheer YN 14 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
1What happens to my OTBI Deeplinks when Redwood apps are activated?Hi, I have a tone of otbi reports that have deeplinks back to Work Orders, Purchase Orders and PO Receipts. What will happen to these links as the Redwood apps replace t…Hylton 13 views 3 comments 1 point Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab
-
Issue with developing analyses for requisition to purchase order cycle timeSummary: We are trying to create a custom analyses as per requirement of customer to analyze the purchase requisition to purchase order cycle time but not able to identi…JITHU JOSE 93 views 3 comments 0 points Most recent by Paula Dyason Oracle Transactional Business Intelligence
-
183Report that provides a list of permissions for all folders in BI CatalogOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Description (Required): There …Saloni Gupta-Oracle 3.8K views 98 comments 183 points Most recent by Ray Switzer Oracle Transactional Business Intelligence Idea Lab
-
86Detailed log for OTBI AgentOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): University of Northumbria at Newcastl…Bhaskar Konar 1.2K views 24 comments 86 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Idea Lab -
2ERP OTBI Archive / Unarchive ability in My Folders for UsersThis was originally reported in SR 4-0000680699. Oracle requested that we create an idea instead. Requirement: To enable the Archive / Unarchive option under "My Folders…Sam Heller 9 views 0 comments 2 points Started by Sam Heller Oracle Transactional Business Intelligence Idea Lab
-
17OTBI Link to Payables Invoice ImageOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Wincanton Description (Required): I a…DennisOliver 403 views 7 comments 17 points Most recent by Donna Biggs Oracle Transactional Business Intelligence Idea Lab
-
3View BI Data model query and results in one single editor like SQL Developer.Description Create a DM > Data set > Query > Enter your query > when you view data > you will not be able to see the query and results at the same time. Original Idea Nu…kmanda 138 views 12 comments 3 points Most recent by Wim vd Veer Oracle Transactional Business Intelligence Idea Lab
-
102Use .xlsx Excel templates in BI PublisherDescription Currently only .xls Excel templates are available. The idea is to support .xlsx Excel templates as well in BI Publisher. Use Case and Business Need If .xlsx …timvanlith1 3K views 52 comments 102 points Most recent by EEcob_HarrisFederation Oracle Analytics Publisher Idea Lab
-
How to identify missing Associations in a Taxable Benefits Calculation CardHi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been …
-
Delay in syncing data for OTBI real time usage subject area?I Have developed an OTBI report (Analysis) to get the Audit data like usage of OTBI reports in last 6 months using OTBI Real time usage subject Area. but to test that I …Asritha 33 views 4 comments 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence
-
ZMM Notes columns - SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID in Receivables - Transactions Real Time?Summary: Is anyone familiar with the subject area - Receivables - Transactions Real Time? I am looking for the equivalent of SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID column…Scott McAnally 2K views 5 comments 1 point Most recent by Vermaee Oracle Transactional Business Intelligence
-
Knowledge Management Article Views- Unable to view the data for Knowledge Article Status.Hello, I attempted to run an OTBI analysis using the 'Knowledge Management - Article Summary Historical' Subject Area to retrieve data on "# of Article Views," "# of Art…User_UE94E 20 views 3 comments 0 points Most recent by User_UE94E Oracle Transactional Business Intelligence
-
1Provide Total Pages option in OTBI HeaderWe are not able to print Page number (that is available) of Total pages (that is not available in Print & export options>Header). And this is a standard/vanilla need in …VDM_IM 4 views 0 comments 1 point Started by VDM_IM Oracle Transactional Business Intelligence Idea Lab -
How to access the link between OTBI column names to fields in the Oracle data tablesI'm designing reporting using OTBI, however there may be a requirement to query the tables directly using BIP. I would like to understand, where I am selecting columns f…User_BAITI 38 views 4 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
OTBI Logical SQL complex query assembler - Updated to 10 subject areasSummary Combine analyses from up to 10 different subject areas Content While building a report on OTBI, you will encounter some cases where the Subject Area will only pr…Maxime Pignot-Oracle 872 views 20 comments 2 points Most recent by Nidhi Chhajed Oracle Transactional Business Intelligence
-
Deeplinks why cant I get it to work with the record number as the Oracle SCM guide suggestsIm trying to open a work order edit screen from an OTBI report. the Oracle guides seem to suggest that the number can be used as the objKey Or in my case the work order …