Popular Tags
- OTBI 1,513
- Reporting 1,429
- FDI 1,344
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,024
- BI Publisher 908
- Analysis 699
- Oracle Fusion Analytics 641
- OAC 626
- Administration 568
- Fusion HCM Analytics 476
- Fusion ERP Analytics 473
- Analytics 465
- OBIEE 446
- BI Publisher Data Models 372
- Oracle Analytics Cloud 316
- Fusion Data Intelligence 314
- Security 312
- Fusion Data Intelligence FDI 307
- HCM 300
- BIP 275
- Answers 267
- Analyses 258
- Developers 251
- Data Modelling and Datasets 242
BI Publisher Data Models
Discussion List
-
BI Publisher Data Model completes with errorsSummary BI Publisher Data Model completes with errors Content Hi Everyone, I'm trying to create a BI Publisher report using HRC_TXN_HEADER and HRC_TXN_DATA tables. Here …Dhanuka Chamal 273 views 3 comments 0 points Most recent by Dhanuka Chamal Oracle Transactional Business Intelligence Forum -
2Ability to use REST API as data setDescription In BI Publisher it's possible to use SOAP web services as data sets. As REST API has more functionality it would be useful to have it available as data sets …Sergey Vasilyev 35 views 0 comments 2 points Most recent by Sergey Vasilyev Oracle Analytics Publisher Idea Lab -
6Ability to view Excel template reports on screen as well as downloadableOrganization Name GE Description Hi, As in normal BI reports, number formatting is not retained on number columns when report is downloaded as excel (Meaning : The repor…User_BHBTR 61 views 2 comments 6 points Most recent by Glen Ryen Oracle Transactional Business Intelligence Idea Lab -
1Provide documentation on the mapping of data from OBI fields to TCC fieldsDescription There are many reasons one may want to transition OBI reporting to TCC feeds including: * Different delivery options * Automated Integrations with other syst…Aaron Johnson-40082 23 views 1 comment 1 point Most recent by Frank Jordan Oracle Transactional Business Intelligence Idea Lab -
2Improve BIPublisher/SQL DataModel creation possiblitiesDescription We try to use OTBI subject areas as much as possible, but for some requirements we will need to create custom (SQL based) datamodels. Currently, we are 'crea…MaartenDIF 74 views 2 comments 2 points Most recent by David Wright - More4apps Oracle Transactional Business Intelligence Idea Lab -
BI Published Report Date VariablesSummary Date variable for previous month Content Hello, I was on this site: https://docs.oracle.com/middleware/12212/bip/BIPUG/GUID-BC0A8B60-1BB5-4D85-85BB-B199C1A5C418.…slgott 288 views 3 comments 0 points Most recent by Sahil_Makhiza Oracle Transactional Business Intelligence Forum -
What application do you use to write your SQLContent I'm very curious as to what other people use to write their SQL. Personally I am using NotePad++ (with the SQL language setting to help with syntax). I do feel t…MaartenDIF 629 views 16 comments 0 points Most recent by MaartenDIF Oracle Transactional Business Intelligence Forum -
Meaning of Oracle table name with and without "_" at its end?Summary What is the difference between Oracle tables named with and without "_" at the end? Content Hello Oracle Community, 1) What's the difference between Oracle table…Jonathan Chan gmg 851 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum -
How to correctly script the "OR" function in Group Filter section in Data Model in OBIEE?Summary In OBIEE, an error was prompted when I was scripting the "OR" function in Group Filter section of the Data Model interface. Content Hello Oracle community, In OB…Jonathan Chan gmg 141 views 4 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum -
How to pick mulitple fields into table box when buidling report using data model?Summary How to pick mulitple fields into table box when buidling report using data model? Content Hello Oracle Community, When building report using data model, in the "…Jonathan Chan gmg 396 views 14 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence Forum -
1Allowing selection of muliple and/or all columns to be moved from Data Models into BI Publisher RepoDescription Both the amount of man hour and risk of developing carpal tunnel syndrome would be tremendously reduced if multiple and/or all columns can be selected while …Jonathan Chan gmg 11 views 0 comments 1 point Most recent by Jonathan Chan gmg Oracle Analytics Publisher Idea Lab -
Steps to audit BI folder changes?Summary In what way can we identify what user moved heh folder in BI Catalog? Content In our PROD pod, we have several folders under the custom folder location that incl…User_VR8E0 571 views 4 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence Forum -
User Time-Zone in BI Publisher Excel TemplateSummary User Time-Zone Management in Bi Publisher Content Hi, I am creating a report which has to extract a field which is managed with TIMESTAMP. Since this report shou…Alberto Romani-Oracle 338 views 3 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence Forum -
BIP compress output prior deliverySummary Compress output prior delivery Content To divide the large data set in multiple data set in OTBI we have option to use bursting. By using bursting we have writte…Niketa Ashwini 975 views 9 comments 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence Forum -
1disable action for Reporting currency defined for Conversion Level BalanceOrganization Name M1 Services sal Description i would like to ask for an urgent ER to have the ABILITY TO DISABLE BALANCE LEVEL REPORTING CURRENCY LEDGER. Use Case and B…Kamal Aboudraa 11 views 1 comment 1 point Most recent by Kamal Aboudraa Oracle Transactional Business Intelligence Idea Lab -
Pivot table in rtf bi publisher 12cSummary Edit for-each to fetch on another for-each-group Content Hello developers, In pivot table, it fetch all empcode with respective to the cross table but in my cas…Osama Fawzy 21 views 1 comment 0 points Most recent by Osama Fawzy Oracle Transactional Business Intelligence Forum -
1Manipulating XSL templateOrganization Name District of Columbia Water and Sewer Authority Description We have developed Xsl template to extract XML output. The problem is we need to add an attri…User_9FFSB 1 view 0 comments 1 point Most recent by User_9FFSB Oracle Transactional Business Intelligence Idea Lab -
1Importing Data from Web Content CenterOrganization Name Stratview Description Hability to use an XML,dat or text file from Web Content Center to cross with HCM Tables and provide results. This functionality …Misael Gutiérrez-Oracle 67 views 4 comments 1 point Most recent by Misael Gutiérrez-Oracle Oracle Transactional Business Intelligence Idea Lab -
2Enhance BIP Content Server Data Source to pull XML FilesOrganization Name Ceridian Description The newly added, and Oracle configured & support BI Publisher ‘Content Server’ Data Source type can only pull text files from the …Mark Johnson 12 views 0 comments 2 points Most recent by Mark Johnson Oracle Transactional Business Intelligence Idea Lab -
1BI Report Output file renaming not reflecting in the Report Job History but reflecting in file nameOrganization Name JPMorgan Chase Bank, N.A Description Hello, SR 3-22818855591 The above SR was raised with Oracle, as when we are generating the report after scheduling…Ayushi Jetwani-224326 21 views 0 comments 1 point Most recent by Ayushi Jetwani-224326 Oracle Transactional Business Intelligence Idea Lab