General Transactional Reporting (OTBI)
Discussion List
-
How to add the number in BarChart in OTBISummary How to add the number in BarChart in OTBIContent I have created the Graph in OTBI, Pie chart and barchart but values is not showing on the charts . Like attached… -
Can we have a OTBI analysis based on a BI Publisher Report's output?Summary Can we have a OTBI analysis based on a BI Publisher Report's output?Content Can we have a OTBI analysis based on a BI Publisher Report's output? Regards, Rashmi -
Terminations ReportContent Hi I am currently trying to create a terminations report. I cannot find the following: - Termination Action - Termination Reason I am using the Workforce Managem… -
How to display values in bargraph_vertical in BI Publisher RTF TemplateSummary How to display values in bargraph_vertical in BI Publisher RTF TemplateContent Hi, Can anyone help on how to display values in the Bargraph in RTF template. I ha… -
Customizing a Seeded Report - Editing the Data Model and using PackagesSummary The Payable Invoice Aging Data Model uses package AP_APXINAGE_XMLP_PKG. I could use instructions on how to interact in SQL with this package.Content I am searchi… -
OTBI Reports - Disable Excel optionSummary Can we hide 'Excel 2007' option under Export for OTBI reportsContent Hello All - We have an issue with downloading OTBI reports to Excel. it doesn't download all…
-
Employment Position History ReportSummary Grouping dataContent I am creating a BI Report that basically lists out all the Jobs an employee has had during their employment, so of course my initial groupin…
-
Restoring a deleted folder in catalogueSummary Accidently deleted a folder. Is there a way to restore the folder?Content Hi I accidently delelted a folder in the fusion OBI catalouge. Is there a way to be abl… -
BI Catalog show last updated bySummary BI Catalog show last updated byContent I'm trying to find a way on the catalog page, to show the name of the person that last updated an analysis/report/data mod… -
Splitting DFF column after first blankContent I am still struggling with advanced edits in OTBI so this post for a (seemingly) easy task came up: Due to a rushed implementation we have cost centers to which …
-
Table to query on ReportsContent Hi Team, Can I get the table name to query on available OTBI & BI reports in Cloud. Thanks, Priya
-
OTBI - add a SQL column to a subject area analysisSummary Can you refer to a table using SQL and a subject area at the same time?Content Is it possible to add column to a subject area using SQL? I have tried editing the…
-
CSV Export with limited range of measures/columnsContent I have created an analysis on employees that works very well for HR reporting. Due to the fact that I combine multiple subject areas I have entered several measu…
-
Audit on deleted Analysis/Dashboards in OBISummary Capablity to recover deleted analysis/dashboards in OBIContent Wanted to check if we have any ability to recover deleted analysis/dashboards in OBI by administra…
-
Password Protect OBIEE AgentsSummary Password Protect OBIEE AgentsContent Hello, Any ideas on how to protect reports that are scheduled? Thanks!
-
Self-Defined Candidate Facts - Yellow BoxSummary How to create a self-defined candidate facts using UDFContent Hi Experts, Could someone please walk me through how to create a self-defined UDFs with embedded fo…
-
Emails not getting bursted, inspite of job success and delivery details show right info.Summary Emails not getting bursted, inspite of job success and delivery details show right info.Content Hi, I am using BI publisher to burst employee confirmation e-mail…
-
Prompts OBIEE not working in OTBIContent I have created a simple new analysis in OBIEE for leavers and added a prompt so the user can run the analysis between termination dates. This works fine when ope…
-
Oracle Essbase in the Cloud: A Mercer Advisor’s Success StorySummary Webinar on the successful implementation of Essbase in the Cloud at Mercer AdvisorsContent https://www.perficient.com/insights/webinars/on-demand-webinars/2017/o… -
Removing HTML tags from a datbase fieldSummary Remove HTML tags saved in database fieldContent Hi, I have an sql data model retruning HCM performance review data. One of the fields returned is a comments fiel…
-
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 wr…
-
OTBI QuestionSummary Adding field, removes othersContent Hi, I am brand new to OTBI and am having issues adding a field to my Received Not Invoiced report I am attempting to build wi… -
Showing '0' for Null ValueSummary How do you show a 0 value in place of a blank value on an analysis?Content Hello, We want to show the total number of something on an analysis (in this case Lead… -
Reporting Options for data source in PaaS and SaaSSummary Reporting Options for data source in PaaS and SaaSContent I understand we have OTBI and BI tools available to report out of SaaS Data Source. Similarly, * What a…
-
Prefix - set effective date using SQL ExpresssionContent Hello - I'm hoping someone can help me with this please. I have an OTBI analysis that I want to schedule on the first of each month that will show changes in the…
-
FTP Timeout ErrorSummary FTP Timeout ErrorContent We are using Oracle Cloud R12. We want to connect to Service now. I went to BI publisher, administration, Configured FTP Connection. Whe…
-
Agent is generating Corrupted ExcelSummary Agent is generating Corrupted ExcelContent Hi All, Curious if anyone has seen this error within the excel file of an agent generated report: Outputfilename.xlsx …
-
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 … -
Free Oracle Analytics Cloud Workshop in Houston, 4/26Summary Perficient has partnered with Oracle to deliver a hands-on workshop at the Oracle office in downtown Houston on Thursday, April 26th. This is a rare chance to wo…
-
Saved Personal FiltersSummary Can our users save their reporting preferences?Content Hi all - I have users that will export their report, slice it a variety of ways, and then send off to thei…