-
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
DashboardSupply Chain Planning & Collaboration
Reporting and Analytics for SCM
Internet of Things
-
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 4:02 AM by Geetha Devi
, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Fusion, OBIEE Answers in General OBIEE publicTitle:how to connect to Bi publisher administer console in fusion 19C?Summary:How to access the bi publisher administer console in fusion 19c?Content:I have added some roles to my fusion account. But, I cannot see the bi publisher administrator console offering in fusion 19c
Could anyone please help with this?
Topic posted July 20, 2017 by Aaron Leggett
, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Data Models, Fusion, OBI Answers, OBIEE Answers, Report Output, Setup/Administration, SQL in General OBIEE publicTitle:Security Console TablesContent:Hi Everyone
Quick question, is there a table that I can query in BIP that will show me the Roles and Roles Description? We have been struggling to assign the right roles to the right people throughout our implementation and I feel this report will give us a much better understanding for our programme team to see what each role gives access too. Below is a screenshot from the Security Console showing what I would like to extract (Role Name, Role Code and Role Description...if possible the type of role too, such as Duty, Data etc.).
Image:
- Topic posted May 15, 2019 by Praveen Kumar, tagged Analyses, BI Publisher, BI Publisher Report Templates, Customizing Reports, Data Models, OBI Answers, OBIEE Answers, OTBI, SQL in General OBIEE publicTitle:How to get and SQL for our own OTBI AnalysisSummary:SQL for OTBI AnalysisContent:
Hi All,
How to get and SQL for our own OTBI Analysis.I know we can get this in the advanced tab but there we cannot see the sub query and all.
Where to get the SQL including sub query.Also help me with the navigation.
Thanks in Advance.
Regards,
Praveen G.
- Topic posted March 27, 2019 by Kunal Daya, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Layout, Customizing Reports, Data Models, OBI Answers, OBIEE Answers, Report Layouts, Reports, Sample Reports, Tip in General OBIEE publicTitle:BI Publisher Excel TemplateContent:
Hi All,
We have a nested table and beacause of this we are receiving this row mark in front of the data
Printing and Stationery" rowMark="2
Does anyone know how to workaround this isse when nesting multiple groups in Excel?
Thanks,
Topic posted March 5, 2019 by Stephanie Gott
, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Report Delivery, Report Output, Reports, Scheduling or Agents in General OBIEE publicTitle:Published Report Schedule - showing message if attachment has nothingSummary:If the published report attachment has no data, can we put that in the body of the message?Content:Hello,
For a personal BIP report schedule, if the attachment has no data on it, is there a way to call that out in the body of the email message to the user? We find that users are opening reports that have no data unnecessarily. Some days the report will have data, sometimes it might not and that could be valid. If there is a way to show the user that they don't need to open the attachment because it doesn't contain data, that would be great. Any thoughts?
Thanks,
Stephanie
- Topic last edited November 5, 2018 by Viswanadh Kambham
, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Fusion, Reports, Sample Reports, SQL in General OBIEE publicTitle:Need inputs to find who created/deleted the folder in Reports and AnalyticsContent:Hi All,
We have different custom folders in Reports and Analytics side. Is there any way to find who created/deleted the folder or Data model or Report?
We need to know the username as well as IP Address of the machine.
Thanks,
Visu
- 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 September 7, 2018 by Kingsley, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Reports, Data Models, Fusion, Fusion Performance Mgmt, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Layouts, Report Output, Reports, Sample Reports, Scheduling or Agents, SQL in General OBIEE publicTitle:List of OTBI inefficient ReportsSummary:looking for was to monitor OTBI reports performance and Frequency of useContent:Hi All,
I am looking for ways to monitor the performance of OTBI Reports in fussion cloud environment. We have BIP and OTBI reports that are running poorly and I wish to find out how I can do that. Admin session mager provides the cursor cache where I can see the OTBI report run-time, logs and path but this information is only held for a very short time in the production environment.
Has anyone an idea on how i can get this information for a time period of over a month?
- Report name with path
- Runtime
- Execution time and date
Thanks
Kingsley
Version:R13 - 18B- Topic posted May 16, 2018 by Mahesh Ganji
, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, OBI Answers, OBIEE Answers in General OBIEE publicTitle:GET_DURATION function syntax in Release 13Summary:We are getting error in Release 13 because of wrong number or types of arguments in call to GET_DURATION'Content:We are getting error in Release 13 because of wrong number or types of arguments in call to GET_DURATION'.
'ORA-06553: PLS-306: wrong number or types of arguments in call to 'GET_DURATION'
Note: This function was working fine in Releases 9 to 12.
Any help in this regards ?
Thanks - Mahesh
- Topic posted April 5, 2018 by Doron de Jong, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Reports, Discussion Forums, Fusion, OTBI, Report Delivery, Report Layouts, Report Output, Reports, Sample Reports, Scheduling or Agents, Setup, Setup/Administration, SQL in General OBIEE publicTitle:How to create a custom read online role to allow users to self serve reports that are segregatedContent:
Hi All
I am struggling to get to grips with one area of reporting and that is allowing users to self serve some key reports we have but I need them to be segregated to themselves/their own cost centre.
The reports I am looking to do is a procurement requester report I have build, and I want users to be able to see all POs that they have raised and are requester for. What custom role/seeded role is their so they can have a view of this report (I also want to pin this report onto there oracle homepage - is this possible?)
Another role I want to create is so that cost centre managers can see all POs raised to their cost centre only. How can I do this?
Finally I want to create a role for expenses where a manager can see a report of all expenses that their team (Line manager hierarchy) have raised. Is this easy to do?
Thnx