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
-
Is it true that oracle is planning to deprecate webservice datasets from BI Data Model?Is it true that oracle is planning to deprecate webservice datasets from BI Data Model? and if its true, what are all the dataset types that will be retained in the futu…Abhilash K - Deloitte USI 41 views 3 comments 0 points Most recent by Federico Venturin - Oracle Oracle Analytics Publisher Forum -
Bursting with logo in body and file attachedGood evening, I need to send emails using bursting in Oracle HCM. These emails must include the Excel output of the report as an attachment and an email body formatted w…Guido Masciello 85 views 1 comment 0 points Most recent by MandeepGupta Oracle Analytics Publisher Forum -
3Restrict BIP access (table access) for person, sensitive dataWhen creating or editing a data model it should be possible to restrict data access to certain tables that contain person sensitive data such as Ethnicity etc. The secur…Vina Vyas 101 views 3 comments 3 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab
-
How to confirm if email was successfully sent using BIP Bursting.We are looking at possible options available in Oracle Fusion to confirm if the email was successfully sent to recipients using BIP Bursting. This is from an audit stand…Suprit 63 views 1 comment 0 points Most recent by MandeepGupta Oracle Business Intelligence Applications Forum
-
14User Role Usage ReportOrganization Name GE Digital Description Ability to run a report that lists active users , the key privileges they have access to ( key privileges that drive subscriptio…User_9SEAD 543 views 9 comments 14 points Most recent by Priya_Ananda Oracle Transactional Business Intelligence Idea Lab
-
How to embed parameters from data model in a dashboard (OTBI)?Hi, I am creating a report in OTBI using data model and I have established the RTF file for the report. But I am not able to make the RTF for the parameters to work.Ivony Ann Paula Salango 91 views 3 comments 0 points Most recent by Ivony Ann Paula Salango Oracle Transactional Business Intelligence Forum -
1SR 3-38319042191 : Oracle Time and Labor table HWM_TM_REC - DELETE_FLAG fieldIn Oracle ERP Cloud I want to use the table HWM_TM_REC to expose a report in my BI to Oracle Analytics Cloud. However, I have seen that for some employees the table HWM_…Marina Chiovato 32 views 0 comments 1 point Started by Marina Chiovato Oracle Fusion AI Data Platform Idea Lab
-
Is it possible to create a data set using REST API as a data source in oracle fusion cloud?Please suggest solutions to set up an REST API as a data source for a data model in Oracle Fusion. instead of sql query as a data set we need to pull data from rest api …Prakash B Roy 315 views 10 comments 1 point Most recent by MandeepGupta Oracle Analytics Publisher Forum -
How to add a parameter when calling a function from the trigger sectionI have a parameter that I pass directly to the data model - RDATE, and this parameter is automatically added to the triggers section. I get an error when calling the fun…Vitalii_Alliance_dgtl 123 views 8 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher Forum
-
Field is in DM but not showing on BI Publisher to add to templateI'm trying to add a field to a BIP report and the field is included in the DM. When I open the template and access BIP and select field to add it to the template the fie…Sean-B-01 572 views 9 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher Forum
-
Not able to Print Enterprise Contract Terms in Custom Report as ARTICLE_TEXT is HTML embeddedselect ch.contract_number, cab.label||''||caa.article_title article,fl.meaning,cab.document_id,cv.ARTICLE_TEXT from okc_k_headers_vl ch,okc_k_articles_b cab, okc_article…Snehashis_Santra 21 views 3 comments 0 points Most recent by Kevin M-Oracle Oracle Analytics Publisher Forum
-
'Print Receivables Transactions' Data Model does not return any Sample Data.The underlying data model for 'Print Receivables Transactions', ' Transactions Print Data Model', does not return any sample data. I would need this to get a sample XML …Reena Agrawal 61 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
Want to customise Standard Oracle SalesOrder Report by adding new columnsI want to add few new columns in salesorder standard Oracle Report ,but unfortunately standard XML attached in the datamodel does not have the tags that I require , Is t…
-
How to access PaaS table or external database through BI PublisherWe have a PaaS solution where we have created a custom screen and stored the data in the custom table(DBCS), and we have another DW system as well; we want to build a re…DKR 862 views 3 comments 0 points Most recent by Ali Mostafa_connect Oracle Analytics Publisher Forum
-
Pivot row header nameI am trying to do a Pivot but the name is not appearing for the header. I am also trying the same in Pivot for bi publisher but not sure how to do it XML is attached. Co…Dhevina 12 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Oracle Transactional Business Intelligence Forum
-
How to disable pdf attachment while bursting in Oracle Fusion HCMGiven 'FALSE' as parameter6 in my bursting query. Still attachments are triggering. Suggestion PLEASESai Krishna Chelikani 423 views 5 comments 0 points Most recent by Sumanth V -Oracle Oracle Analytics Publisher Forum
-
1Allow Ability to Restrict Data Model Creation in OACCurrently there is no role in OAC which restricts users from creating Data Models in the Published Reporting section of OAC. This is an issue because it allows all Conte… -
Query to get fetch Archived Transaction Summary dataHi Expert, Does anyone have a query to fetch the Archived Transaction Summary data? I would really appreciate it if you could share a BI query here. Thank you in advance…Saher 109 views 3 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
SQL code runs fine in SplashBI SQL Connect tool but times out in Oracle BIP Data ModelHi all - I have a SQL query that runs within a few seconds in my Splash BI (SQL Connect) query tool, however when I use this same code in the Oracle Data Model in BIP it…KDR 83 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
2How to restrict the data access for different users on BIP reportsWe developed some custom BIP reports in our system, and by default, BI consumer role is taking the read access, thus, most of our users who have the BI consumer role wil…Jay0089 111 views 0 comments 2 points Started by Jay0089 Oracle Transactional Business Intelligence Idea Lab