General Transactional Reporting (OTBI)
Discussion List
-
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…
-
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…
-
Column Properties InteractionSummary Primary Interaction = None but hyperlink still showing in the valueContent Hello, I have a report where I've set the "Primary Interaction" on the 'Value' to "Non…
-
NACHA format filesSummary NACHA format filesContent Can we create NACHA format files using BI Publisher template builder in Cloud? Any documentation for creating the same will be helpful.…
-
BI publisher template builderSummary Can we create fixed format files using BI publisher template builder?
-
Phone screens completedSummary Looking to add the number of phone screens completed to reportContent I have a current report that I am needing to add the number of phone screens that have been…
-
Case When for date fieldsSummary Case when date is lesser than or equal to another date, THEN "on time", ELSE, "Not on time"Content I'm trying to build a Case statement that shows If one date is…
-
Is it Possible to Use an Alias for the Bursting Sender Info?Summary Is it Possible to Use an Alias for the Bursting Sender Info?Content We engaged a vendor to write some BI Publisher reports, which use bursting to send out emails…
-
archive unarchive and oracle bi admin roleSummary archive unarchive and oracle bi admin roleContent Hi, in Oracle BI is it possible to get archive/unarchive functionality and not be an oracle bi admin? Our tech …
-
Missing Folder in OBISummary Is there a way to recover missing folder in BI.Content We have a folder Analytic Library that is missing in our production environment. I can see it in our PTFDe…
-
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 sh…
-
BI Mobile HD AppsSummary OTBI reports in BI Mobile AppContent We would like to view reports created in OTBI from within BI Mobile HD app. What steps need to be taken to have the OTBI cre…