-
Forums
-
- Applications (SaaS)
-
Marketing, Sales, and Service
Marketing, Sales, and Service
DashboardB2C Service
Field Service
Marketing
-
Human Capital Management
Human Capital Management
DashboardTalent Management
-
Enterprise Resource Planning
Enterprise Resource Planning
DashboardRisk Management
Project Management
Reporting and Analytics
Integrations, Extensions, and Security
-
Supply Chain Management
Supply Chain Management
Dashboard -
Reporting and Analytics
Reporting and Analytics
DashboardSolutions for Applications (OTBI)
- Reporting & Analytics for HCM
- Reporting & Analytics for Taleo Enterprise (TEE)
- Reporting & Analytics for Taleo Midsize (TBE)
- Reporting & Analytics for Taleo Learn
- Reporting & Analytics for ERP
- Reporting & Analytics for SCM
- Reporting & Analytics for Sales
- Reporting & Analytics for B2C Service
- OBIEE for Applications
Business Analytics
- Applications Security
-
More
More
-
Infrastructure (IaaS)
and Platform (PaaS)Infrastructure (IaaS) and Platform (PaaS)
DashboardContent and Experience
Business Analytics
Security
System Management
-
Partners
OPN Technical Assistance Forums for Partners
BUILD: Partner Technical Assistance
For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
SERVICE: Partner Technical Assistance
For partners that provide implementation or managed services around Oracle Cloud Applications
- Announcements
-
-
Ideas
-
- Applications (SaaS)
-
Marketing, Sales, and Service
Marketing, Sales, and Service
Marketing, Sales, and Service
-
Human Capital Management
Human Capital Management
-
Enterprise Resource Planning
Enterprise Resource Planning
-
Supply Chain Management
Supply Chain Management
-
Reporting and Analytics
Reporting and Analytics
Reporting and Analytics
-
Platform (PaaS)
Platform (PaaS)
-
-
Events
-
Events
Sales and Service
Human Capital Management
-
- Contribute
- Hall of Fame
- Learning
- Success
- Documentation
- Support
Posts
Posts
Topic posted March 1, 2018 by Ramesh Pusarapu
, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates in General OBIEE publicTitle:Dynamic Report layouts in BI PublisherSummary:Dynamic Report layouts in BI PublisherContent:We have a requirement from a client where from the prompts, if we select any attributes you report layout has to show case those field attributes in the report layout.
Any help is highly appreciated
- Topic posted February 14, 2018 by Richa
, tagged BI Publisher, BI Publisher Report Templates in General OBIEE publicTitle:not able to divide two columns RTF TemplateContent:we are trying to divide two columns but its not working.we are using the below code.
<?CURR_TOT_GAURENTEED_COMP?>DIV <?NEW_TOT_GAURENTEED_COMP?>
- Topic posted January 22, 2018 by Islam Abu Khamseh, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Fusion, Report Layouts, Reports in General OBIEE publicTitle:Dynamically place the custom logo in BIP reports in Fusion CloudSummary:Dynamically place the custom logo in BIP reports in Fusion CloudContent:
Hi,
We need to developed few custom reports as per the requirements. In this implementation we have around 30 companies each of them has its own logo.
so in the report template we need to make the displaying logo dynamic
means if user from COMP1 run the report then LOGO1 will appear .
and if COMP2 runs the report then LOGO2 will appear.
Is there any flexibility where we keep the logo in one particular location and pull the logo dynamically in the report template in FUSION CLOUD?
or there is another way to do it fusion cloud ..For example if we can upload the logos to a path in fusion server and from the template we call them .
I am not sure how to do this in fusion
Please advise
- Topic posted November 23, 2017 by Nirmal Kumar L
, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Core HR, Customizing Reports, Data Models, OBI Answers, OTBI, Report Delivery, Report Layouts, Report Output, Reports, SQL in General OBIEE publicTitle:Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataSummary:Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataContent:Hi,
We need to fetch the pending transaction Transfer details like New Location,New Position,New Grade,New Job etc. We are aware that We can capture these details in data_cache column in hrc_txn_data table. As these column captures many entries, how can we fetch only one value(say New location, New Position,New Grade,New job etc.)? Is there any syntax to fetch that alone? Please suggest.
Thanks,
Nirmal kumar 
Topic posted November 16, 2017 by Ling Xiang
, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Layouts, Report Output, Reports, Sample Reports, Tip in General OBIEE publicTitle:Fusion BI Catalog Folder Management Best PracticesSummary:A white paper on Fusion BI Catalog Folder Management Best PracticeContent:This white paper provides the best practices for working with BI catalog folders, and suggestions on actions for accidental move or deletion of a folder.
Document:- Topic posted November 14, 2017 by Sandip Kumar, tagged BI Publisher, BI Publisher Report Templates, Public Sector in General OBIEE publicTitle:BI Publisher Report as Cloud Data Extract engineSummary:Use of Report as Cloud Data Extract engine and keep track of extracted data/ recordContent:
Cloud Integration process where data is extracted and sent via FTP to other partner applications.
If this process is performed on a scheduled basis (or manual run) then it becomes difficult to find out which records were extracted earlier and where are NOT? Other mechanisms are used to remove already extracted records from being sent twice.
Could we perform the following steps:
#01: BIP Report is given the capability (similar to EBS) to update some DFF fields (not other fields) from the source tables (data being pulled) to update and store them so that next run could validate and exclude these records. This should be kept as datatime field so that it can keep track of when the data was pulled. In addition, if the record was updated then the record should be pulled second time in BIP. This could be performed on Datatime and "Last_Update_date" comparison.
#02: ATOM configuration could accommodate custom BI Publisher reports so that one can create reports and send via ATOM audit structure to FTP / emial
- Topic posted November 10, 2017 by Nirmal Kumar L, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Core HR, Customizing Reports, Data Models, OBI Answers, OBIEE Answers, OTBI, Report Output, Reports, Sample Reports, SQL in General OBIEE publicTitle:Table name to capture reverse termination date & its details for reverse terminated employeesSummary:Table name to capture reverse termination date & its details for reverse terminated employeesContent:
Hi All,
In which table I can find the reverse terminated date & its details for the reverse terminated employee? Please help me with the table name or sample query.
Thanks
Nirmal kumar - Topic posted October 24, 2017 by Nirmal Kumar L, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Core HR, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Layouts, Report Output, Reports, Sample Reports, SQL in General OBIEE publicTitle:Different report in same Excel file with differents sheetSummary:Different report in same Excel file with differents sheetContent:
Hi Experts,
I created 3 new reports as per our customer requirements. But they need all the reports in single excel file(one report in sheet 1, another in sheet 2 & other in sheet 3). Is it possible to do? If it can be done, please guide me.
Thanks
Nirmal kumar 
Topic posted September 23, 2017 by MShrini, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Reports, Discussion Forums, Fusion, OBI Answers, OBIEE Answers, Online Layout Editor, OTBI, Report Delivery, Reports, Sample Reports, Setup, Setup/Administration, Upgrades in General OBIEE publicTitle:The tool 'OracleBIOffice.exe' is not available after R12 upgradeSummary:The tool 'OracleBIOffice.exe' is not available after R12 upgradeContent:We are not able to install OracleBIOffice.exe tool after R12 upgrade from the EPM Workspace as error message is returned. Kindly help us in this regard as we have to build OTBI report on smartview
Topic posted September 14, 2017 by Aaron Leggett
, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Reports, Data Models, Report Layouts, Report Output in General OBIEE publicTitle:Extracting all Columns from BIP Query without creating layout?Content:Hi Guys
I have to extract all the columns from 11 different tables for our finances guys to sift through and see what data they want. Some of these tables have 100 or so columns and I really don't want to tediously have to drag and drop each column in via the report creator. Is there a simpler way to extract all the data from a data model?
Also, I can't seem to get the BI Publisher tools working for Microsoft Office so won't be able to utilise any ideas using that i'm afraid :(
Thanks