Popular Tags
- OTBI 1,468
- Reporting 1,403
- FDI 1,173
- Fusion AI Data Platform 1,028
- Analysis and Data Visualization 999
- BI Publisher 870
- Analysis 685
- Oracle Fusion Analytics 602
- Administration 556
- OAC 505
- OBIEE 435
- Fusion HCM Analytics 419
- Analytics 414
- Fusion ERP Analytics 402
- BI Publisher Data Models 360
- Security 301
- HCM 274
- BIP 267
- Answers 265
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 231
- 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
-
1'Reprinted' watermark in BI or OTBI report output format.Description Hello, We have a requirement in a BI report, wherein we can implement security measures while reprinting the report. Use Case and Business Need Test Case: Pa…Denis Prince-230911 71 views 1 comment 1 point Most recent by Mayur_Gidwani Oracle Transactional Business Intelligence Idea Lab -
What will be the approach to use where condition for two different scenarios?I am working on a report related to PO and PPM, for that I am using one condition that is identifying the Project Role Name this condition is working as expected for the…Yashdeep 11 views 1 comment 0 points Most recent by Sinduja Sekar-Oracle Oracle Fusion AI Data Platform Forum -
Lockdown Proprietary Data Model LogicWe have a custom report/data model we would like to use in future Oracle ERP implementations BUT we do not want anyone to have the ability to edit it or view the logic i…MDiRienzo 1 view 1 comment 0 points Most recent by Federico Venturin - Oracle Oracle Analytics Publisher Forum -
Parameter with Line break has no results in report but has results in Data ModelWhat can i do to fix this? Data Model can filter the output using a parameter which column data has a line break. Using the same data model with a report it returns with…User_J9G3N 11 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Oracle Transactional Business Intelligence Forum -
DFF Lexicals in a Non-Standard SQL DataModelHi, We have the requirement to write our data model using the 'Non-Standard SQL' SQL type because we need the use of CURSOR statements to return data back in a nested st… -
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 2.9K views 4 comments 0 points Most recent by SOUMYA PRIYA CHOWDHURY Oracle Transactional Business Intelligence Forum -
How can we suppress repeating master data in report output using RTF template?We have a BIP report with single data set. Each row of the dataset consists of header level and line level data. Suppose there are 3 lines to an invoice, the header leve…Brijesh Sharma 91 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum -
15Need PVOs for the tax tables "ZX_ACCOUNTS" and "ZX_REC_NREC_DIST"Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Orange Romania S.A. Description (Requ…Stéphane BALA-Oracle 111 views 1 comment 15 points Most recent by Stéphane Lamy-Bouchard Oracle Transactional Business Intelligence Idea Lab -
Hi, wanted to know if in W2 form we have any box id, if yes in which table it gets stored?I wanted information on if we have any box ids for W2 forms? If there are any such ids, in which table do they get stored? -
Hi, wanted to know if in W2 form we have any box id, if yes in which table it gets stored?I wanted information on if we have any box ids for W2 forms? If there are any such ids, in which table do they get stored?User_RH43L 1 view 0 comments 0 points Started by User_RH43L Oracle Transactional Business Intelligence Forum -
9Improve Archive/Unarchive function to keep the link between Report and Data ModelOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Epicenter Description (Required): Upg…Daan Beumer 171 views 3 comments 9 points Most recent by User_XN22W Oracle Transactional Business Intelligence Idea Lab -
In BI Publisher can you tell me how many emails produce per hour.We are scheduling a New BI Publisher report that has the possibility of producing ,as many as, 70K emails. Can you tell me how many emails will produce per hour? -
Creating Data Model Using SQL Querry is Causing Data Breach IssueDoes Anyone who has both HCM and ERP in same project have the concern if a user has access to create Data Models using SQL Querry?? That is, if a user account having acc…V P Aravind 81 views 2 comments 0 points Most recent by EzequielC-Oracle Oracle Analytics Publisher Forum -
5Allow Developers to write SQL and preview data on the same screenWhen creating an SQL Data Model, I have to write my SQL in the "Diagram" tab, close the window go into the "Data" tab to see a preview of the results. Realize the change…User_315WR 61 views 2 comments 5 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Transactional Business Intelligence Idea Lab -
2Date Parameter should show Hijri calendar instead of Gregorian calendarOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): AAIS Global Description (Required): F…Vaibhav DL 91 views 1 comment 2 points Most recent by Ahmed.Omara84 Oracle Transactional Business Intelligence Idea Lab -
In BI Report we getting dupicate recordsHI Team, we have exist interview status report but few days onwords we getting dupliacte reocrds nearly 700plus. how can shorted out the issue ? Thanks, AjayAjayKumar Maddipati 221 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum -
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 261 views 5 comments 0 points Most recent by PareshSharma Oracle Transactional Business Intelligence Forum -
How can restrict the data in reports?Hi Team, Can some one help me to understand, how to restrict the data in reports. For example we have one of the report called Leave Balance Report. It contains all empl…Malak 131 views 3 comments 0 points Most recent by Krithika Raghavan-Oracle Oracle Fusion AI Data Platform Forum -
1External data sources support in Fusion Application BI PublisherOrganization Name Willis Towers Watson Description In order to invoke webservice from SAAS to OIC we can configure it as external data source , this feature is currently…User_1W7KM 231 views 3 comments 1 point Most recent by Joydeb Saha-Oracle Oracle Transactional Business Intelligence Idea Lab -
BIP Security - Need to restrict user from modify and deleting the reports only in Shared FolderHello All We would like to restrict the users from creating, deleting and modifying the report from shared folders. I was able to do it but the issue is users are not ab…