-
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
Forums
Use our discussion forums to pose questions, explore ideas, and discuss Oracle Applications. -
-
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)
Ideas
Share your ideas on product enhancements, vote, and comment on your favorite ideas. -
-
Events
-
Events
Sales and Service
Human Capital Management
-
- Contribute
- Hall of Fame
- Learning
- Success
- Documentation
- Support
Posts
Posts
Topic posted October 15, 2019 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 August 28, 2017 by Giuseppe Botta
, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, OTBI in General OBIEE publicTitle:Data model with parameter with "Select all"Summary:Data model with parameter with "Select all"Content:Hi,
we created a data model based on several analisys and we want to add a parameter which filters by Employee Name, with the possibility to filter both for single employee name and all employee names.
How do we do that? Which is the where clause we have to put in?
Thank you,
Dario
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 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 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 July 7, 2017 by Alice Kim, SPHR-SCP
, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, OBI Answers, OBIEE Answers, Online Layout Editor, Report Delivery, Report Layouts, Report Output, Reports, SQL in General OBIEE publicTitle:Embedded Reporting/BI PublisherSummary:audit report using offer fieldsContent:Hello,
I am trying to build a report for recruiters to use to audit the offers they have created.
The intention is for the recruiter to create and save the offer, then run the report to see if there are any issues with the offer (i.e. bonus amount is 0 but bonus program is quarterly).
I built a data model definition using the recruiting subject that includes both requisition data (requisition number, requisition title) and offer data (currency, sign on bonus).
When I try to run the report, the requisition data displays, but the offer components do not display. I do not know what the issue is. Is it because the offer is still in draft?
Thank you in advance for your help.
Regards,
Alice Kim
CDW- Topic posted Yesterday by Gaston van de Weijer, tagged BI Publisher, BI Publisher Report Templates, Report Output in General OBIEE publicTitle:Reference Relationship in BI PublisherContent:
Hi,
I created an interview which loads data about a certain order - it then needs to go into boxes and I need to create shipping labels
1. The user adds an instance 'the box' and enters dimensions and more information.
2. I created a relationship from 'the box' to 'the item' called 'the debrief item in the box'
3. I added this relationship to the entity collect screen, so you can check which items will be in the box.
4. The data overview displays exactly what I want:
5. However, I cannot get this in BI publisher. I want an overview of items per box, however, I can't seem to pull this off. Once I create a 'for each' for every box, I can't add another 'for each' in there. I can't seem to add the items in this overview..
How do I create a report with BI publisher with a page for a box and a list of items in the box below?
Version:19B - Topic posted May 12, 2017 by Peter Kirwan
, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Core HR, Data Models, Fusion, OBI Answers, OBIEE Answers, OTBI, Reports, SQL in General OBIEE publicTitle:report on user account details - Role NamesSummary:SQL for reporting on employees rolesContent:Can someone see how to stop the multiple rows from returning in below SQL?
select "PER_USERS"."USERNAME" as "USERNAME",
"PER_ROLES_DN_VL"."ROLE_NAME" as "ROLE_NAME",
"PER_ALL_PEOPLE_F"."ATTRIBUTE3" as "ATTRIBUTE3",
"PER_PERSON_NAMES_F"."FIRST_NAME" as "FIRST_NAME",
"PER_PERSON_NAMES_F"."LAST_NAME" as "LAST_NAME",
"PER_ALL_PEOPLE_F"."EFFECTIVE_START_DATE" as "EFFECTIVE_START_DATE",
"PER_ALL_PEOPLE_F"."EFFECTIVE_END_DATE" as "EFFECTIVE_END_DATE"
from "FUSION"."PER_PERSON_NAMES_F" "PER_PERSON_NAMES_F",
"FUSION"."PER_ALL_PEOPLE_F" "PER_ALL_PEOPLE_F",
"FUSION"."PER_ROLES_DN_VL" "PER_ROLES_DN_VL",
"FUSION"."PER_USER_ROLES" "PER_USER_ROLES",
"FUSION"."PER_USERS" "PER_USERS"
where "PER_USERS"."USER_ID"="PER_USER_ROLES"."USER_ID"
and "PER_USER_ROLES"."ROLE_ID"="PER_ROLES_DN_VL"."ROLE_ID"
and "PER_USERS"."PERSON_ID"="PER_ALL_PEOPLE_F"."PERSON_ID"
and "PER_ALL_PEOPLE_F"."PERSON_ID"="PER_PERSON_NAMES_F"."PERSON_ID"
and "PER_ALL_PEOPLE_F"."EFFECTIVE_END_DATE" >CURRENT_DATE
order by "PER_USERS"."USERNAME" ASC - 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 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
