Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
General Transactional Reporting (OTBI)
Discussion List
-
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…
-
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…
-
Compare two fields in analysisSummary How to compare two fields within an analysisContent How do I compare two fields in an analysis. I need "Workforce Management - Person Real Time"."Person Legislat…
-
Removing time from date criteriaContent In all criteria the date appears as 03/03/2015 03:56:13 PM. Is there anyway to remove the timestamp from the view so only the date appears in the columns? Thanks…
-
Production to Stage for BIP ReportsSummary Easiest way to copy BIP reports from Production to Stage environmentsContent Hi all - we have two ways that we use BIP reports on our dashboards: 1) Embedded Con…
-
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 segrega…
-
Add Password to Report EditingSummary Can I add a password to a file to prevent some from opening/editing it?Content Hi all - is it possible to add a password to a OTBI or BIP file to prevent anyone …
-
Day Name from DateSummary Need to get the name of the day of the week from the Creation DateContent Hello, I am using this function: DAYNAME("Service Request"."Creation Date") and it is n…
-
Unable to download BI publisher report outputSummary Unable to download BI publisher report outputContent Unable to download BI publisher report output when the report is scheduled via webservice call. The output l…
-
BI/OTBI report location and last run date - is it possible?Summary BI/OTBI report location and last run date - is it possible?Content Hello I want to be able to extract a list of all OTBI and BI reports and their folder location…
-
Pipleline Time In Process - Detail & Metrics Performance Issue - Advanced SQLSummary Pipleline Time In Process - Detail & Metrics Performance Issue - Advanced SQLContent Hi All, We have a dashboard -Pipeline Time In Process which consists of both…