BI Publisher Data Models
Discussion List
-
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 3 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 21 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 11 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 1 view 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 1 view 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 1 view 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 1 view 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 24 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 17 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 11 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 30 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 12 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 10 views 3 comments 2 points Most recent by Arghyo Banerjee -Oracle 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 32 views 7 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 16 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 12 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 10 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…
-
BI Publisher Excel TemplateContent Hi All, We have a nested table and beacause of this we are receiving this row mark in front of the data Printing and Stationery" rowMark="2 Does anyone know how …Kunal Daya-76859 48 views 2 comments 2 points Most recent by _IshanAgarwal General Transactional Reporting (OTBI)
-
BI Published Report Date VariablesSummary Date variable for previous monthContent Hello, I was on this site: https://docs.oracle.com/middleware/12212/bip/BIPUG/GUID-BC0A8B60-1BB5-4D85-85BB-B199C1A5C418.h…Stephanie Gott 19 views 3 comments 0 points Most recent by Sahil Makhiza General Transactional Reporting (OTBI) -
Wrap Text in MHTML formatSummary Wrap Text in MHTML formatContent Hi All, While selecting mhtml as a default template, i am not able to wrap text few columns such as description column. User wan…VAIDIA 12 views 1 comment 1 point Most recent by SantoshKumarB General Transactional Reporting (OTBI)
-
What application do you use to write your SQLContent I'm very curious as to what other people use to write their SQL. Personally I am using NotePad++ (with the SQL language setting to help with syntax). I do feel t…MaartenDIF 66 views 16 comments 11 points Most recent by MaartenDIF General Transactional Reporting (OTBI)