Popular Tags
- OTBI 1,451
- Reporting 1,395
- FDI 1,132
- Analysis and Data Visualization 988
- BI Publisher 861
- Analysis 683
- Oracle Fusion Analytics 595
- Administration 555
- OAC 470
- OBIEE 433
- Analytics 404
- BI Publisher Data Models 359
- Security 296
- HCM 271
- BIP 265
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 211
- ERP Analytics Content 210
- Oracle Analytics Cloud 209
- BI Publisher Report Templates 205
- Fusion Data Intelligence 193
- Report Output 184
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher Data Models
Discussion List
-
Can Someone help with table and column details for the Manager performance check-in feedback columnHi, we have OTBI report developed for check-in details summary information. As this is hitting performance issues very often and taking very long time to run. we are con…User_LEKDP 25 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence -
Repeating Footer on Invoices Report Output and print ContinuedThe request here is for the footer to display (repeat) on every page of a multi-page invoice. On all pages apart from the LAST page, the footer should repeat with the wo…Pooja K-Oracle 87 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI Oracle Analytics Publisher
-
14Ability to extract all ESS job and job set name via Manage Enterprise Scheduler Job for HCM/Fin/CRMOrganization Name Department of Treasury and Finance Description Hi Team, Per Oracle Fusion product limitation, The Jobset and Job Definitions are not stored in any DB t…Akash Gupta 475 views 4 comments 14 points Most recent by Emiliano R Oracle Transactional Business Intelligence Idea Lab
-
Is it possible to run the procedure in Oracle BI Publisher ?Hello everybody Is it possible to perform the procedure before generating a report in Oracle BI Publisher, when creating a Data Model ? I have reports that are executed …Vitalii_Alliance_dgtl 257 views 4 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher
-
"Not Enough Memory to open this page" -BI ReportHi Folks, We have a report which generates assignment details, we are able to export the report in xml format, but while running in HTML format , first it takes time to …Sushant95-Oracle 79 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher
-
How to add Rerun option to generate BI report for incremental dataHi, We want rerun option for regenerating previously scheduled report to get incremental data. Currently we are not able do the same, every time we have to run option to…Jeetesh Singh 16 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
How to add Rerun option to generate BI report.Hi, We want rerun option for regenerating previously scheduled report to get incremental data. Currently we are not able do the same, every time we have to generate the …
-
BIP After entering all parameter we click on "Apply" button and we change prompt of "Apply" button?BIP After entering all parameter we click on "Apply" button can we change prompt of "Apply" button as "Generate" ? Also how can we change font and size of parameter prom…
-
Bursting BIP report to different emails by respective business unitsHello guys, am super new to bursting. I am facing an issue with bursting an excel attachment which has 3 tabs (a detailed report, +2 summarized tables by buyer name). Th…
-
How does CD_TRX_AMOUNT xml tag is getting generated "Create Customer Statements" report ?I am trying to customize the "Create Customer Statements" report in oracle fusion, for which I needed to add one column in "G_LINE_CLUSTER" group. As soon as I am editin…
-
Print Receivables Transactions : Provide Confirmation of Invoice Email DeliveryHi Team, In AR Invoice Printing process, After sending the invoice copy to customer is there a way to access the .msg files send to customers as proof of delivery. We ne…
-
ORA-00939: too many arguments for function error when used substr in SQL Query in DataModelHi, I have created a DataModel using below query : select HZP.PARTY_NAME, HZP.PARTY_NUMBER from HZ_PARTIES HZP where 1=1 AND HZP.PARTY_NAME IN (substr(:P_STRING1,:P_STAR…Shashidhar Goud 302 views 7 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Issue with rounding in RTF Template FormulaIn my RTF template, the formula rounds values to 2 decimals by default. For example, if INVL_UNIT_PRICE_VARIANCE is 0.006 in the data model, the output becomes 0.01 aft…Pooja K-Oracle 506 views 6 comments 0 points Most recent by Pooja K-Oracle Oracle Fusion Data Intelligence
-
Dynamic column names and column value for BI reportI am creating custom report, in that we have to get column names and their respective values dynamically. Like this I have data, I have to get output like in this format…Rahul K-Oracle 88 views 2 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion ERP Analytics
-
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…dbudd 481 views 3 comments 0 points Most recent by Neha_Naik004 Oracle Transactional Business Intelligence
-
Dynamic column names and respective column values for BI reportI am creating custom report, in that we have to get column names and their respective values dynamically. Like this I have data, I have to get output like in this format…Rahul K-Oracle 31 views 1 comment 0 points Most recent by Sathyaprakash M Oracle Fusion ERP Analytics
-
BI Publisher Report not returning SOME values for a column - data exists in the sample data.https://us.v-cdn.net/6037859/uploads/VM7Z1JMDBZ6T/datawithvalues.xml https://us.v-cdn.net/6037859/uploads/YG9WZPN1S8E9/outputfrominternaltemplate.xlsx We have a BI Pub r…
-
2Dialog box or an indicator while deleting a folder from BI catalog to show the progress of deletionHi Team, While working on BI catalogs, if we want to delete or move any folder, there should be an indicator or a dialog box provided to show the progress. This will off…Lucky Sharma 24 views 0 comments 2 points Started by Lucky Sharma Oracle Transactional Business Intelligence Idea Lab
-
Repeating headers within a loopHello All, I am currently facing an issue with repeating headers within a loop using the and tags. Despite implementing these tags, the headers are not repeating as re…Bhavani Rikkula 55 views 4 comments 0 points Most recent by Sumanth V -Oracle Oracle Analytics Publisher
-
1How to show Dynamic decimal formatting of Amount in BIP Report excel(*.xlsx) format using RTFExpectation is to show the value to number decimal based on CCY value in Excel(*.xlsx) report format. E.g. if CCY = CAD then number decimal value should be #,##0.00 else…Anil Pandey-Oracle 119 views 2 comments 1 point Most recent by Anil Pandey-Oracle Oracle Transactional Business Intelligence Idea Lab