Popular Tags
- OTBI 1,468
- Reporting 1,403
- FDI 1,176
- Fusion AI Data Platform 1,030
- Analysis and Data Visualization 1,001
- BI Publisher 871
- Analysis 686
- Oracle Fusion Analytics 605
- Administration 556
- OAC 509
- OBIEE 435
- Fusion HCM Analytics 422
- Analytics 416
- Fusion ERP Analytics 402
- BI Publisher Data Models 360
- Security 301
- HCM 275
- BIP 267
- Answers 265
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 237
- 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
-
2Display Custom text message for Errored out Ess JobOrganization Name JCI Description We have a requirement where we want to display a custom message when the Ess Job is Errored out and we have to error out the report bas…User_KIM9L 31 views 1 comment 2 points Most recent by User_DC397 Oracle Transactional Business Intelligence Idea Lab -
1Highlight the point an error is detected in the SQL of a data modelDescription When editing a data model especially complex ones, it is easy to introduce an error within the SQL code. The error messaging in the application does not alwa…Ian Rumble 11 views 2 comments 1 point Most recent by Andreas Ehrenstein Oracle Transactional Business Intelligence Idea Lab -
3Ability to Run SQL Query from BI Publisher ReportDescription Creating a BI Publisher Data Model that can dynamically accepts SQL query from a BI Publisher Report. passed as a Parameter from Report. Use Case and Busines…Senthilrajan V 641 views 13 comments 3 points Most recent by Andreas Ehrenstein Oracle Analytics Publisher Idea Lab -
1Analysis based on Direct Database QueryDescription Feature of creating Analysis based on Direct Database Query should be retained and made more robust Use Case and Business Need As Per me this is very nice fe…Ashish Shah-Oracle 211 views 13 comments 1 point Most recent by Ashish Shah-Oracle Oracle Transactional Business Intelligence Idea Lab -
1Editor for Logical QueriesDescription Create a new editor to enter and execute Logical Quries Use Case and Business Need At present report developers uses Physical SQLs to create BI Publisher rep…Shakher Sharma 1 view 1 comment 1 point Most recent by Laura Meine Oracle Analytics Publisher Idea Lab -
5Ability 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 53 views 2 comments 5 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 21 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 41 views 2 comments 2 points Most recent by David Wright - More4apps Oracle Transactional Business Intelligence Idea Lab -
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 -
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 61 views 4 comments 1 point Most recent by Misael Gutiérrez-Oracle Oracle Transactional Business Intelligence Idea Lab -
2Allow advanced SQL statements in prompted filtersOrganization Name Inovalon Description CURRENT BEHAVIOR: Prompted filters and data parameters on OTBI Analyses and BI Publisher reports respectively are limited to the o…Jessica D'Apice 51 views 3 comments 2 points Most recent by MaartenDIF Oracle Transactional Business Intelligence Idea Lab -
1List of joins between ERP TablesOrganization Name Western Digital Description User can provide a set of tables as input to a UI. The return from the UI should be list of tables and join conditions that…Shivakumar Biradar 31 views 2 comments 1 point Most recent by Sreekanth Mukalla Oracle Transactional Business Intelligence Idea Lab -
1Converting Invoice Amount into words other than English language(like arabic)Organization Name Zamil Offshore Services Company Description Currently we are not able to convert invoice amount into Arabic language or any other language apart from E…Ashok_Kancheti007 1 view 1 comment 1 point Most recent by Ashok_Kancheti007 Oracle Transactional Business Intelligence Idea Lab -
1Add custom calculation while generating Pivot table in BI using custom DMDescription Does anyone know how to create % of Grand Total or % of row total during pivot table generation using custom DM (just like pivot options in Excel)? I only se…kmanda 51 views 3 comments 1 point Most recent by Sailee Deb Oracle Transactional Business Intelligence Idea Lab -
2Upgrade needed to Data Set Definition WindowDescription New Data Set window provides really basic functionality and must be enhanced with advanced features in absence of direct database access in cloud application…Shakher Sharma 11 views 1 comment 2 points Most recent by user13313793 Oracle Analytics Publisher Idea Lab -
1Enhancement of the Administration Service AreaOrganization Name Teletech Description We need to add the two display fields from the Recruiting Service area to be added to the Administration Service area or link the …Ernesto Perez-183734 11 views 1 comment 1 point Most recent by Ernesto Perez-183734 Oracle Transactional Business Intelligence Idea Lab -
1BIP Data Model - View Data - Table View, get columns order exactly like in SQLDescription Oracle BIP Data Model has a relatively new feature to view data as a table (alternative way to XML view). Outstanding! Thanks Oracle. Table View sorts column…Valeriy Gorbunov-80491 1 view 1 comment 1 point Most recent by Senthilrajan V Oracle Transactional Business Intelligence Idea Lab -
1Scheduling a BI Report recursively using webservicesOrganization Name Deloitte Description Hi Team, My Idea here is to schedule BI Reports using web services (SOAP UI) Use Case and Business Need The main reason to use thi…User_AT83E 11 views 1 comment 1 point Most recent by User_AT83E Oracle Transactional Business Intelligence Idea Lab -
2BI Publisher Scheduler does not provide Multi Language Support for data translationOrganization Name Chartwell Master Care LP Description When a multi-language BI Publisher (BIP) report is being RUN ONLINE, both, static template content and dynamic dat…Valeriy Gorbunov-80491 41 views 1 comment 2 points Most recent by Valeriy Gorbunov-80491 Oracle Analytics Publisher Idea Lab -
1Need to fetch Calendar detail in reportDescription Hi Team, Good day!!! We need report for details which are presented in 'Time' (Navigation : Navigator>>About Me>>Time) This will contain employee's schedule …Kumaran Santhanam 1 view 1 comment 1 point Most recent by Valeriy Gorbunov-80491 Oracle Transactional Business Intelligence Idea Lab