BI Publisher Data Models
Discussion List
-
How do we customize pre-defined reports to add more parameters and display fields on OTBISummary: Trying to add more parameters for a custom AR aging report Content (required): Accounts Receivable Aging Report Version (include the version you are using, if a…Abhinav Gaddipati 46 views 6 comments 0 points Most recent by Abhinav Gaddipati General Transactional Reporting (OTBI) -
How can I find all reports using the same BI Publisher Data ModelSummary I need to be able to identify all the reports that are using a Data Model before I make changes to the DM.Content Bi Publisher Data Model has been created, I now…Sarah Munro 12024679 40 views 8 comments 2 points Most recent by Frank Davidson General Transactional Reporting (OTBI) -
View/Table details for Data SecuritySummary: Hi Everyone, We have built some custom pages and are looking to apply Fusion security on those pages. In order to do so, we require the Secure View/ Table detai…Maruvada Sanat Kumar-Oracle 14 views 2 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
SQL/report to get the list of consultants (not having Person ID)We are looking for a user/role report that list users firstname/lastname/email and roles. The report we have only lists if they are linked to a person record. We have co…Vijay Ramani VJ 12 views 4 comments 0 points Most recent by Vijay Ramani VJ General Transactional Reporting (OTBI) -
Adapting Previously Used SQLSummary: Amending a BIP Report we have that's not pulling the correct results back Content (required): Hi all, Apologies if this is the wrong place to ask. I've been ask…
-
Hide Seeded Folders from Reports and AnalyticsSummary: We are able to hide customs Folders by Using Shell role and and Permission feature. However While trying the same with Seeded Folders or the folders within them…Shashank Verma-Oracle 2 views 3 comments 0 points Most recent by Shashank Verma-Oracle General Transactional Reporting (OTBI) -
Invalid date in BIP report for some usersHello, We have an issue where some of our users are seeing invalid dates in the BIP report. e.g. actual date in table (at db level) is 15-Nov-21 but certain users are se…User_ZTN0B 23 views 5 comments 1 point Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
Hide Seeded Folders from Reports and AnalyticsSummary: We are able to hide customs Folders by Using Shell role and and Permission feature. However While trying the same with Seeded Folders or the folders within them…Shashank Verma-Oracle 12 views 1 comment 0 points Most recent by Priscila Terazawa-Support-Oracle General Transactional Reporting (OTBI)
-
Text AnalyticsSummary step by step procedure to proceed Text Analytics in OBIEE 11gContent Hi, I need step by step procedure to proceed Text Analytics in OBIEE 11g. I'll be happy to r…Andrews J Stanley 22 views 2 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI) -
No. of rows in the CSV output file of ESS job in Oracle CloudSummary: Hi, We are seeing the below error in the CSV output file of an ESS job in the Oracle Cloud. Flatten data truncated due to MaxRows=2000000 has been reached. Is t…User_MN9VB 2 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
ESS Schedule Process ID into OTBISummary: Obtaining ESS Schedule Process ID into OTBI data model Content (required): Hi all, Has anybody every seen or done getting the ESS “Scheduled Process” request ID…
-
Query to find the HRBP Representative of an Employee in HCM DatabaseSummary: Find a 'HR Business Partner' of an Employee in HCM Database - to create a report on Employee and his/her 'HR Business Partner Representative' details. Content (…User_H69RU 38 views 1 comment 0 points Most recent by Vijay Ramani VJ General Transactional Reporting (OTBI)
-
How can I turn an analysis already created in a report? and put the information in a templateSummary: I created an analysis using the correct columns and some prompts, so what I want now is from the analysis create a report which has a template. Content (require…
-
Users are unable to create new Analysis Reports in the Transactional Business Intelligence windowSummary: Content (required): Users are not able to see any option in the "New" tab in Transactional Business Intelligence window to create OTBI reports (Analysis/Data Mo…Dian Minshan 2 views 4 comments 0 points Most recent by Dian Minshan General Transactional Reporting (OTBI) -
Excel/Data Model only runs once then I have to close AnalyticsSummary: The help desk was trying to help me with the installation of the BI Publisher Template Builder for Excel and the Oracle ADF 11g Desktop Integration Add-in for E…
-
Changing date format to remove comma - OTBI ReportSummary: Been working on an Absence Calendar for a Dashboard and the prompt for Year dislays as '202,0'. Is there a way to change the format so it displays as '2020'. Co…User_DKPSX 2 views 4 comments 0 points Most recent by User_DKPSX General Transactional Reporting (OTBI) -
How to run an OTBI Analysis and save output without having it deliveredSummary How to run an OTBI Analysis and save output without having it deliveredContent Currently in Schedule option of of OTBI analysis , there is option to deliver to e…Shivaji Muttarapu 27 views 8 comments 0 points Most recent by Shivaji Muttarapu General Transactional Reporting (OTBI)
-
Subject Area for Area of Responsibilities (AOR)Summary: I am looking to see if it is possible to build a custom Subject Area for the AOR I know that the AOR doesn't already exist in the Subject Areas but we have many…
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 18 views 2 comments 4 points Most recent by Srinivas Pendyala-Oracle General Transactional Reporting (OTBI)
-
How to create a report containing past, current and future approvers of purchase requisitions?Summary: I would like to create a report with the summarized version of Purchase Requisition's Action Detail that contains all the stages and participants/approvers from…Joan Fabi 12 views 1 comment 0 points Most recent by Mahendran General Transactional Reporting (OTBI)
-
OTBI REPORTING CAPABILITYContent Can we do all sort of reporting with otbi or do we need bi publisher for customizable reportingChes-Oracle 31 views 6 comments 0 points Most recent by Arghyo Banerjee -Oracle General Transactional Reporting (OTBI)
-
Issues in creating dynamic hyperlink and passing parameter from BI Publisher RTF templateSummary BI report parameterContent Hi, Would like to pass parameter from BI publisher report to another BI report using hyperlink. the parameter is called "parc" in the …Khalil Ferhat 13 views 1 comment 0 points Most recent by Pulkit Kumar Jain General Transactional Reporting (OTBI)
-
How to fix an RTF report related error in OBIEESummary In OBIEE, an error was reported when opening a RTF report produced from a Data Model. What is the solution to fix the errorContent Hello Oracle Team, In OBIEE, w…Jonathan Chan gmg 11 views 3 comments 2 points Most recent by Arghyo Banerjee -Oracle General Transactional Reporting (OTBI)
-
Embed BIP Report with URL on page (HTML) and have parametersSummary Embed BIP Report with URL on page (HTML) and have parametersContent Hi, I've embedded my BIP Report on the Purchase Requisitions page succesfully using an iframe… -
Is there a way to include Prompt Description in BI Publisher?Summary Looking for insight on how to include custom help tips on BI publisher prompts for user to understand what the prompt isContent When creating a report in OTBI, y…Jacob Thompson 17 views 2 comments 1 point Most recent by Jacob Thompson General Transactional Reporting (OTBI) -
How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Summary How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Content Hi, I'm working to extract all Quotes and their respective Quote Line Ite… -
How To Find Advanced Custom Object Subject Area In OBIEESummary How To Find Advanced Custom Object Subject Area In OBIEEContent Hi, Where do I find the Advanced Custom Object Subject Area in OBIEE? I need to find Custom Objec…edpalomo 13 views 2 comments 0 points Most recent by edpalomo General Transactional Reporting (OTBI)
-
Extracting Goal SuccessCriteriaText from hrc_txn_data that is greater than 4000 Characters using OraSummary Extracting SuccessCriteriaText for Performance Goals in Draft or Pending Approval from hrc_txn_data using SQL when SuccessCriteriaText is having more than 4000 C…Ravindra Paidiparthi 11 views 0 comments 0 points Started by Ravindra Paidiparthi General Transactional Reporting (OTBI)
-
BI Publisher Data Model completes with errorsSummary BI Publisher Data Model completes with errorsContent Hi Everyone, I'm trying to create a BI Publisher report using HRC_TXN_HEADER and HRC_TXN_DATA tables. Here I…Dhanuka Chamal 27 views 3 comments 3 points Most recent by Dhanuka Chamal General Transactional Reporting (OTBI) -
BI Publisher Excel - How to get multiple horizontal repeating groups working?Content Hello There, I would like to know how can I get the below output using BI Publisher for Excel. I have three groups in the xml file. G_1 -> G_2 -> G_3 Below expec…