Popular Tags
- OTBI 1,468
- Reporting 1,403
- FDI 1,174
- Fusion AI Data Platform 1,029
- Analysis and Data Visualization 1,000
- BI Publisher 870
- Analysis 686
- Oracle Fusion Analytics 604
- Administration 556
- OAC 507
- OBIEE 435
- Fusion HCM Analytics 421
- Analytics 416
- Fusion ERP Analytics 402
- BI Publisher Data Models 360
- Security 301
- HCM 274
- BIP 267
- Answers 265
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 236
- Data Modelling and Datasets 230
- ERP Analytics Content 216
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
10Ability to use Job manager and Catalog manager in Fusion SaaS OTBIDescription If users are able to use OBIEE client tools like job manager or catalog manager in OTBI then we can reduce many number of SRs related to OTBI agents and cata…User_B8VQC 251 views 7 comments 10 points Most recent by Chris Pfeifer Oracle Transactional Business Intelligence Idea Lab -
Bi Publisher Data model returning error when run, after using system variable in the sql query.We created a data model and defined a condition in the sql query using the system variable ':xdo_user_roles' (which fetches all roles of the session user) and using it, …Bishal Dutta 93 views 2 comments 0 points Most recent by Bishal Dutta Oracle Analytics Publisher Forum
-
Extracting all Columns from BIP Query without creating layout?Content Hi Guys I have to extract all the columns from 11 different tables for our finances guys to sift through and see what data they want. Some of these tables have 1…Aaron Leggett 212 views 4 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
2Adding PO Change History Information to either Procurement - PO or Configurable Acct AnalysisCurrently in FAW, there is no ability to track when a Purchase Order (PO) gets changed in the system. We would like to the Change Order on the PO and the amount change. …Juan Hurtado 11 views 0 comments 2 points Started by Juan Hurtado Oracle Fusion AI Data Platform Idea Lab -
Convert a number to a fraction BIP reportHi all, Is there a function sql to convert a number to fraction using a BIP report in Oracle HCM? For example if I have 0.25 FTE value, I want to print the fraction 1/4.…teresa.marciano 21 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
Report output require in one rowHello BI Expert, I have a problem with the output of the report. How can we obtain a single employee record in a row? If someone could help me with this, it would be gre…Saher 21 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
Reporting for the recruitment/hiring processI need to build a report for the recruitment process that includes YTD counts for candidate slates, candidates on shortlist, interview slates and candidates interviewed …JDCal 154 views 2 comments 0 points Most recent by JDCal Oracle Transactional Business Intelligence Forum
-
New value isn't visible in NotificationHi Expert, I need your help. Our requirement is to add two fields in 'Request New Position' notification, 1. 'NUMBER OF OPENINGS' and 2. 'Business Justification' field. …
-
BIP Report to Get Last 30 Days User Login DetailsThe Import User Login History Ess Job is scheduled and we tried ASE_USER_LOGIN_INFO table to fetch the last 30 days users login history but it only gives last login deta…Chainsyssupport 1.3K views 4 comments 0 points Most recent by Chainsyssupport Oracle Analytics Publisher Forum
-
The table used in the Change History using custom objects.We are using custom objects in the system and there is a Change History tab to audit the changes that happened on each custom objects. Is there a way to know the table n…Cristelle Rose Sampang 31 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion AI Data Platform Forum
-
Notification doesn't work anymore in Oracle Fusion?I have a notification in Oracle Fusion (Absence Approval Notification) i did the code and it was working fine but now the field i already put it in layout doesn't show a…Martin_Melek 11 views 1 comment 0 points Most recent by Martin_Melek Oracle Fusion AI Data Platform Forum
-
3Restrict the display of information from a custom report to specific users through data access.Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Aseguradora Aserta, S.A. de C.V. Grup…Fernando Ch 411 views 1 comment 3 points Most recent by Balasubramanian Oracle Transactional Business Intelligence Idea Lab
-
Date parameter not working to send Bursting emailHello All I am developing a parameterized report which has bursting logic to split and send the file to different emails for each project. The Bursting query is working …
-
Export Reports in Parquet File FormatHello, Is anyone aware of an ability to export data from OTBI or BI Publisher as a Parquet file format? We have a need to be able to define an export via OTBI and/or BI …Ryan Waller 41 views 1 comment 2 points Most recent by Abhishek Bajpai - CEAL Team-Oracle Oracle Fusion AI Data Platform Forum
-
23D has Broken All BI Report importingEver since 23D came along it has broken all BI Reports in multiple places. We first had an issue that views no longer respect languages see here: https://community.oracl…Paul Hassall 31 views 2 comments 0 points Most recent by Paul Hassall Oracle Analytics Publisher Forum
-
10Ability to Report on User Account Password Expiry DateDescription We are thinking of changing our password policy and would like to understand the impact of generating daily/weekly notifications, especially when the majorit…Brad Hughes 341 views 12 comments 10 points Most recent by Nikki K Oracle Transactional Business Intelligence Idea Lab
-
Extract data issue using BI ConnectorDear ALL, I am trying to extract data using BI Connector. 1-I added the role: OBIA_EXTRACTTRANSFORMLOAD_RWD, but still when I download sample csv file, I am receiving th…George Mattar 241 views 2 comments 0 points Most recent by Renuka Nuguru-Oracle Oracle Analytics Forum
-
OTBI - Tables for 'Output & Delivery' Data from BurstingCan anyone please provide the database tables where the OTBI 'Output & Delivery' data is stored? We have a requirement to monitor and audit this data to confirm email of…Charles Zorbach 51 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence Forum
-
Bi Publisher properties window is not visible while creating Offer letter templatesHI Team, I am facing an issue while creating the RTF template using BI Publisher to support offer letter templates. When I try to edit the existing offer letter template…Sanjay Kalingu 1 view 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
Export data from OTBI or BI Publisher as a Parquet file formatHello, Is anyone aware of an ability to export data from OTBI or BI Publisher as a Parquet file format? We have a need to be able to define an export via OTBI and/or BI …Ryan Waller 61 views 1 comment 1 point Most recent by JohnW-Oracle Oracle Fusion AI Data Platform Forum