Popular Tags
- OTBI 1,456
- Reporting 1,398
- FDI 1,146
- Analysis and Data Visualization 991
- BI Publisher 865
- Analysis 684
- Oracle Fusion Analytics 597
- Administration 557
- OAC 480
- OBIEE 434
- Analytics 410
- BI Publisher Data Models 359
- Security 297
- HCM 269
- BIP 265
- Answers 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 219
- ERP Analytics Content 215
- Data Connectivity 211
- BI Publisher Report Templates 205
- Fusion Data Intelligence 196
- 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
-
Query to fetch employee's eligibilty for performance document.Hi, I want to create a report of eligibility of all performance document for all employees available in system but currently I can only fetch data for any one user in OT…Shubham Patil29 31 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence -
Default Package name for HCM pl/sqlI want to add an event trigger based on an pl/sql function on the HCM table in BI data model. Where can I find the package names?
-
6Ability to segregate create and migrate functionality via the BI Admin RoleThere should be a separate privilege to provide the create BIP/Data Model vs Migration of data models. This will help to support the segregation of duties as there are u…
-
invalid relational operator errorHi - I am trying to write a query to pull report parameter value in report layout, however due to system limitation whenever my default selection for any parameter is Al…
-
How to implement Bulk invoice download in BIPHi, We have created a BIP report to get IDR links attached to invoices and by clicking on the link given by the report we can download only one invoice at a time. Is it …User_8OVHZ 21 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
1Ability to report on User Account last loginOrganization Name Debenhams Description The requirement here is to have the ability to accurately report on a User Account's last login date and timestamp. The FND_SESSI…Mike Royle 51 views 4 comments 1 point Most recent by Sidney Mori Oracle Transactional Business Intelligence Idea Lab
-
How send two file-excel multi. templateGood day everyone! Is it possible to send several files in one letter using bursting? I have a report and there are two templates in it, how should I send them to the ma…
-
1Uninvoiced Receipt accrual report showing amounts in scientific notationUninvoiced Receipt accrual report showing amounts in scientific notation like Report is showing 6.12890000000000000000000000000000000001E02 Amount on UI is 612.89Himanshu M 11 views 0 comments 1 point Started by Himanshu M Oracle Transactional Business Intelligence Idea Lab
-
Put instructions on Parameter pageIs there a way to put a text box with instructions/comments/directions on the parameter page?Jill Larson 41 views 5 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
Is there a way to pull the email status for Bursting logic in BI fusion OracleIs there a way to Oracle fusion has a table or report to pull all the bursting email status for Bursting from BI report?DharaniR 11 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
Code Working in SQLdev but not BI PublisherHello, The below code is working in SQLdev, and will read in to BI Publisher. However, when I go to view data I am getting a 'SQL or ORA exceptions caused due to invalid…
-
Is there a role in Oracle Fusion BIP catalog, that allows users to view data model and not edit itI would like to know if there is a role in Oracle Fusion BIP catalog, that allows users to only view data model query but not give users the access to edit it.Anil Bathula 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Oracle Analytics Publisher
-
How to calculate the amount of data in the summary ?Hello everybody) I send the report via bursting to the mail. Is it possible to include as many lines in the file as possible in the message? Can we count such a number?Vitalii_Alliance_dgtl 41 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
Extract the parent BU of a specific Department in BIHow can I extract the parent BU of a specific Department in BI?Gian Luca Triglia 11 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher
-
How to create your report execution schedule Oracle Bi PublisherIn the report execution schedule there is execution, daily, monthly, every time, can I somehow specify that my report should be executed from the 1st to the 10th of ever…Vitalii_Alliance_dgtl 61 views 3 comments 0 points Most recent by Vitalii_Alliance_dgtl Oracle Analytics Publisher
-
How do I convert the date format this 2024-03-07T00:00:00.000+00:00 into 7-Mar-2024 as data datatypeI want to convert the date format this 2024-03-07T00:00:00.000+00:00 into 7-Mar-2024 as when I use trunc() function even then it returns the same and I dont want to conv…
-
1Parameter anomalies when setting a filter in the BIP reportSummary There was an anomaly with the report parameter. The scenario is that when the set parameter option in the report is set to "ALL" it works fine, it can generate d…
-
3"Refresh other parameters on change" option for Date parametersDescription We are looking for a way to have an option for refreshing other parameters with Date type Prompt. Use Case and Business Need We have a requirement that needs…
-
10Ability to use Job manager and Catalog manager in Fusion SaaS OTBIDescription If users are able to use OBIEE client tools like job manager or catalog manager in OTBI then we can reduce many number of SRs related to OTBI agents and cata…User_B8VQC 251 views 7 comments 10 points Most recent by Chris Pfeifer Oracle Transactional Business Intelligence Idea Lab
-
Bi Publisher Data model returning error when run, after using system variable in the sql query.We created a data model and defined a condition in the sql query using the system variable ':xdo_user_roles' (which fetches all roles of the session user) and using it, …