-
Forums
-
- Applications (SaaS)
-
Customer Experience
Customer Experience
DashboardB2C Service
Field Service
Marketing
-
Human Capital Management
Human Capital Management
DashboardTalent Management
HCM ANNOUNCEMENT: Deadline Approaching Responsive UX - Urgent Action Required! -
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)
-
Customer Experience
Customer Experience
My IdeasCustomer Experience
-
Human Capital Management
Human Capital Management
My Ideas -
Enterprise Resource Planning
Enterprise Resource Planning
My Ideas -
Supply Chain Management
Supply Chain Management
My Ideas -
Reporting and Analytics
Reporting and Analytics
My IdeasReporting and Analytics
-
More
More
My IdeasPublic Sector
Oracle Education
-
Platform (PaaS)
Platform (PaaS)
My Ideas
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
General OBIEE
Get Involved. Join the Conversation.
Posts
Topic posted September 11, 2019 by nathan morgan (at Client)
, tagged Analyses, BI Publisher, BI Publisher Data Models, Customizing Reports, Data Models, OBI Answers, OBIEE Answers, Report Output, Reports, Setup, Setup/Administration Title:Get privilege to issue logical SQL in OTBISummary:As a developer i need to "Issue SQL" /analytics/saw.dll?issuerawsql to query using logical sql metadata repository database (rpd) with log level 2 then view log for diagnostics like physical sqlContent:Hi,
Does anyone know if in Oracle Cloud Application, we are oracle cloud application 19B(11.13.19.04.0) with oracle business intelligence 11g (11.1.1.9.0), does a role exist that has been granted privilege "Admin:General"/"Issue SQL Directly" by person with bi administration privileges who went to the Administration menu then the page "Manage Privileges" to assign that privilege to a role. Our development team who are writing extensions using oracle transaction business intelligence (OTBI) real time subject areas, to be productive, need the ability to issue logical sql, view results with the log level set > 0, then view the log file with rich diagnostics like timings and row counts and the actual physical sql. To achieve this on onpremise projects the administrator had granted the above role to developers. We assume that the bi administrator role is not allowed to be granted in cloud therefore we can not set this up ourselves. In Navigator/Tools/Security Console I have assigned the following roles "BI Consumer Role", "BI Platform Author Role", "BI Publisher Data Model" and even "BI Platform Repository Manager" and "Business Intelligence Content Administrator" but none of these give me the "Administration" menu in /analytis/ nor the ability just to go to "issue sql" saw.dll?issuerawsql or even "Manage Sessions" saw.dll?sessions. Thanks, Nathan
Version:oracle cloud application 19B(11.13.19.04.0) with oracle business intelligence 11g (11.1.1.9.0)Image:
Code Snippet:
Topic posted July 25, 2019 by Samrat Chattapadhyay, tagged BI Publisher, BI Publisher Data Models, Customizing Layout, Customizing Reports, Data Models, OBIEE Answers, OTBI, ReportsTitle:Audit History to access changes made in BIP Data ModelSummary:Require table or methods to find out changes done in BIP Data ModelContent:Hi,
We have encountered an issue recently where the data model query were updated by someone and the reports refering to the same data model started failing because of the changes.
Is there any way we can have and audit on the BIP Templates or Data models to find out what was the changes done and who incorporated the changes.
Any help in this is much appreciated.
Regards,
Samrat
- 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 Title: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 Title: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 21, 2019 by Kristy Bartnes
, tagged Customizing Reports, Reports, Scheduling or Agents Title:Report LogContent:Anyone have an xml they would be willing to share or recommendations for creating a 'master' report that returns a list of all the BI reports in order to audit and clean up what has been created over the last couple of years. A few primary details I am needing to include are the report name, location of report, and if it is scheduled - who the recipients are (if possible) and last date report was run (again, if possible). Thank you in advance for any assistance/advice you are able to provide.
Topic posted February 13, 2019 by Senthilrajan Vaithianathan
, tagged Analyses, BI Publisher, BI Publisher Data Models, Customizing Reports, Data Models, Fusion, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Reports, Scheduling or Agents, Upgrades Title:New features - BICCC 19A patchSummary:Document for new features list in BICCC - 19A patchContent:New features has been added to BICCC Application as part of 19A patch, it is very good, but it will be helpful if we get some document from Oracle explaining the new features within BICCC for every major releases in Advance, Now I am looking for 19A patch new features list for BICCC. let me know if any of you have come across such documentation for BICCC.
- Topic posted February 4, 2019 by Senthilrajan Vaithianathan, tagged Analyses, BI Publisher Data Models, Customizing Reports, Data Models, Discussion Forums, Fusion, OBI Answers, OTBI, Report Output, Reports, Setup/Administration, SQL Title:Oracle Fusion OTBI Direct Database Query/ReportSummary:Querying Oracle Fusion OTBI feature is being deprecated for CLOUD environment from 19A releasesContent:
Creating Reports with Direct Database Query in Oracle Fusion OTBI is being deprecated for CLOUD environment from 19A releases.
Refer Doc ID 2141412.1
Regards
Senthil
Image:Code Snippet: - Topic posted September 17, 2018 by Kevin Lee Choon, tagged Analyses, Core HR, Customizing Reports, Data Models, Discussion Forums, Global HR, OBI Answers, OBIEE Answers, OTBI, Report Output, Reports Title:Deferred Termination field in OTBISummary:looking on how to determine a deferred terminationContent:
Hello,
I have been asked to create a report showing the associates with a deferred termination. When they do a termination transaction, a selection box showing the processing options pop up on the interface with the choice of Immediate or Deferred.
I tried to look but could not find the field in OTBI related to it. Anyone knows which field to use of if there is another way to determine this type of termination?
thank you!
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 Title: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 April 18, 2018 by Christopher Shaver
, tagged Analyses, Customizing Reports, OBIEE Answers, Report Layouts, Report Output, Reports, Sample Reports, Setup, Setup/Administration, Taleo Enterprise Title:Provide Link to Candidate Job Submission in OBIEE ReportSummary:I am looking for a way to include a link to a candidate's job submission within the TEE OBIEE tool.Content:Is there a way to include a link to a candidate's job submission in the OBIEE reporting tool?
Filter by Tag
- All
- Analyses
- BI Cloud Connector
- BI Publisher
- BI Publisher Data Models
- BI Publisher Report Templates
- Compensation
- Core HR
- Customizing Layout
- Customizing Reports
- Data Models
- Discussion Forums
- Fusion
- Fusion Performance Mgmt
- Global HR
- Goals
- OBI Answers
- OBIEE Answers
- Online Layout Editor
- OTBI
- Payroll
- Public Sector
- Report Delivery
- Report Layouts
- Report Output
- Reports
- Sample Reports
- Scheduling or Agents
- Setup
- Setup/Administration
- SQL
- Taleo Enterprise
- Tip
- Upgrades