BI Publisher Data Models
Discussion List
-
Drill down from OTBI adhoc reports to PPMDear All How can I extract the drilldown hyperlink from PPM to OTBI ? I need the page that show the project financial settings structure Regardsmickel rmeily 21 views 6 comments 0 points Most recent by Rich Merkel General Transactional Reporting (OTBI) -
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticeContent This white paper provides the best practices for working with BI catalog folders, and s…User720640-Oracle 108 views 1 comment 9 points Most recent by HarishVummidi General Transactional Reporting (OTBI) -
Report Location of following seeded reportsHello - We are having a request to implement/customize the following reports but will have to analyze first the complexity of each report. Unfortunately, we are unable t…ZenG 21 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI) -
Table name to capture reverse termination date & its details for reverse terminated employeesSummary Table name to capture reverse termination date & its details for reverse terminated employeesContent Hi All, In which table I can find the reverse terminated dat…Nirmal Kumar L 20 views 1 comment 1 point Most recent by Parag Hiremath General Transactional Reporting (OTBI)
-
We have Connect Conversation Questionnaire below in Performance mgmt how can we extract the reportSummary: we have Connect Conversation Questionnaire below in Performance mgmt how can we extract the report in below questions and answers filled by emps. Performance >>…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by AjayKumar Maddipati 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…
-
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 41 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 32 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 11 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 11 views 4 comments 0 points Most recent by Vijay Ramani VJ 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 1 view 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-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 21 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 251 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 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 31 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 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 21 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 20 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 16 views 2 comments 1 point Most recent by Jacob Thompson General Transactional Reporting (OTBI)