Reports
Discussion List
-
OTBI: Ability to utilize a prompt for sorting purposes?Content Hello Customer Connect community, Does OTBI have the ability to prompt for a sort on a dashboard? For example, I have a costing report consisting of employee det…User_EY0O2 23 views 3 comments 1 point Most recent by Aarti Satyamurthy-Oracle General Transactional Reporting (OTBI) -
Password Protected Excel OutputsSummary Password for OTBI and BIP Excel ouputsContent Hi Team, I learnt from another post it is possible to protect PDF outputs for BIP reports. However, I wonder if you…Alvaro Couto 36 views 4 comments 1 point Most recent by Saresh Namboorissery General Transactional Reporting (OTBI) -
Need to Add more Information from Seeded Data ModelSummary We've successfully customized an AR Invoice Print Layout, but we need more information that the Seeded Data Model Does not ProvideContent Hi, we're in the middle…Juan Miguel Isip-94819 32 views 0 comments 1 point Started by Juan Miguel Isip-94819 General Transactional Reporting (OTBI) -
Hide "Reports Job" under New Menu in Analytics pageSummary How to hide "Reports Job" under New Menu in Analytics pageContent Hello, I am trying to hide "Reports Job" under New in analytics page (highlighted in the screen…Swamy-7253 24 views 6 comments 0 points Most recent by Christian Berg-0racle General Transactional Reporting (OTBI) -
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, RashmiUser_MC37Q 42 views 9 comments 0 points Most recent by User_MC37Q General Transactional Reporting (OTBI) -
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…Aaron Leggett 211 views 8 comments 1 point Most recent by Jatinder Tanda General Transactional Reporting (OTBI) -
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…Tim Welsh 59 views 8 comments 0 points Most recent by rajArun General Transactional Reporting (OTBI) -
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…Naveen Bitra 44 views 7 comments 0 points Most recent by Naveen Bitra General Transactional Reporting (OTBI)
-
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…Mohit Gupta-45440 64 views 4 comments 0 points Most recent by Mohit Gupta-45440 General Transactional Reporting (OTBI) -
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 …Stefan Orac 13 views 7 comments 0 points Most recent by Gianni Ceresa General Transactional Reporting (OTBI)
-
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…Antony Hooper-29731 97 views 1 comment 0 points Most recent by venkata veeragoni General Transactional Reporting (OTBI)
-
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…Stefan Orac 26 views 11 comments 0 points Most recent by Stefan Orac General Transactional Reporting (OTBI)
-
Password Protect OBIEE AgentsSummary Password Protect OBIEE AgentsContent Hello, Any ideas on how to protect reports that are scheduled? Thanks!Laura Robles 26 views 5 comments 0 points Most recent by Shakher Sharma General Transactional Reporting (OTBI)
-
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…User_MC37Q 29 views 4 comments 0 points Most recent by User_MC37Q General Transactional Reporting (OTBI)
-
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…
-
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…User_YOW50 30 views 0 comments 0 points Started by User_YOW50 General Transactional Reporting (OTBI) -
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…Linda Stelling-61686 60 views 2 comments 0 points Most recent by Rick Brobbel General Transactional Reporting (OTBI)
-
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 …Chris Shaver - HEB 15 views 4 comments 0 points Most recent by Chris Shaver - HEB General Transactional Reporting (OTBI) -
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…Prudence K 21 views 6 comments 0 points Most recent by Prudence K General Transactional Reporting (OTBI) -
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…Sara Simpson 50 views 9 comments 1 point Most recent by Stephanie Gott General Transactional Reporting (OTBI)
-
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…Doron de Jong-57089 26 views 0 comments 0 points Started by Doron de Jong-57089 General Transactional Reporting (OTBI)
-
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…Helen Thomas-53877 60 views 2 comments 0 points Most recent by Helen Thomas-53877 General Transactional Reporting (OTBI)
-
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…Ramesh Nakka 13 views 0 comments 0 points Started by Ramesh Nakka General Transactional Reporting (OTBI) -
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…Stephanie Gott 26 views 6 comments 0 points Most recent by Stephanie Gott General Transactional Reporting (OTBI) -
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…User_HZJPP 13 views 1 comment 0 points Most recent by Michael Scaduto General Transactional Reporting (OTBI) -
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…Stephanie Gott 35 views 2 comments 0 points Most recent by Stephanie Gott General Transactional Reporting (OTBI)
-
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…Rebekah Baker 62 views 8 comments 0 points Most recent by Sricharan Monigari General Transactional Reporting (OTBI) -
Complex filters - grouping 3 filters togetherContent I want to create a complex filter which requires grouping 3 filters with another set of filters. I have played around clicking the AND / OR to get the combinatio…Shree Pawar 112 views 6 comments 1 point Most recent by User_8TDVH General Transactional Reporting (OTBI)
-
How To Add Descriptive Flexfield To Fusion Transactional Business Intelligence (OTBI)Content Hi, I have did these steps Sequentially 1-From Manage Descriptive Flexfields page i have checked the [BI Enabled] flag . 2-Deployed the Flexfield . 3- Run these …Abdalaziz Barham 78 views 1 comment 0 points Most recent by Abdalaziz Barham General Transactional Reporting (OTBI)
-
Scheduling Agent with PromptSummary Scheduling Agent with PromptContent I have a report that has a facility filter prompt built into it. I've created several scheduling agents based on this report …Alexis Rivers 88 views 10 comments 0 points Most recent by Manjula K R General Transactional Reporting (OTBI)