Customizing Reports
Discussion List
-
How to default the method of opening for an analysis that has been favorited?I have an analysis with a filter marked as a Favorite. The issue I have is when I click on the analysis from the Favorites dropdown, it opens into edit mode. Is there a …Mike Burnett 53 views 10 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI) -
Any one help Skills ReportSummary: Hi Team, we need skills report in Bi or OTBI Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets…AjayKumar Maddipati 12 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI) -
we have questin text and answer report but all questions are coming in columnsSummary: Hi , we have questin text and answer report but all questions and answers are coming in columns. so we get multiple records for each employee i mean 7 questions…AjayKumar Maddipati 24 views 4 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
Table name to capture reverse termination date & its details for reverse terminated employeesSummary Table name to capture reverse termination date & its details for reverse terminated employeesContent Hi All, In which table I can find the reverse terminated dat…Nirmal Kumar L 21 views 1 comment 1 point Most recent by Parag Hiremath General Transactional Reporting (OTBI) -
Where To Find Overtime Approval FieldsHi all, I'm building a report within OTBI that pulls back all overtime submissions by employee. For the most part, this works great, but I've been asked to include the m…MikeW 2 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle General Transactional Reporting (OTBI)
-
User Organization Hierarchy Based LoginSummary: I am trying to fix a report and it looks like the Hierarchy is broken (Sales - CRM Resource subject area): Content (required): when using User Organization Hier…Cyrille Saulnier-Oracle 3 views 2 comments 0 points Most recent by Cyrille Saulnier-Oracle General Transactional Reporting (OTBI) -
when i taken manger number and name from manager folder then company level coming mulitiple numberSummary: Hi Team, when i taken manger number and name from manager folder then company level coming mulitiple numbers for each mangers . How can i rectify the issue. PFA…AjayKumar Maddipati 22 views 7 comments 0 points Most recent by AjayKumar Maddipati General Transactional Reporting (OTBI)
-
duplicay coming for each employee due to each employee have showing multiple mangersSummary: Hi Team, In below screen shot we have taken employee name and manger name, but same employee has two line mangers coming that is the issue facing in the report.…AjayKumar Maddipati 42 views 14 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
When we creating the otbi report that time showing as UI but some times showing dff nameSummary: Hi Team, when we create the OTBI report that columns shown as as per ui but in some time showing as dff name directly in report. PFA Thanks, Ajay Content (requi…AjayKumar Maddipati 32 views 2 comments 0 points Most recent by AjayKumar Maddipati General Transactional Reporting (OTBI)
-
Invalid date in BIP report for some usersHello, We have an issue where some of our users are seeing invalid dates in the BIP report. e.g. actual date in table (at db level) is 15-Nov-21 but certain users are se…User_ZTN0B 22 views 5 comments 1 point Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
Prompt on empty datesSummary: We need to have a prompt where you can not only filter on a date range but also on the empty date fields Content (required): We want to filter in the prompt on …Cyrille Saulnier-Oracle 4 views 5 comments 0 points Most recent by Cyrille Saulnier-Oracle General Transactional Reporting (OTBI)
-
OTBI Report Too Slow / Not Generating ResultsSummary: Have created a report to pull all roles for all users (Audit purposes), and admittedly there is an excessive amount of data to pull. That being said, when runni…User_DKPSX 12 views 10 comments 0 points Most recent by Matthew Voss General Transactional Reporting (OTBI) -
Convert varchar to date datatype in OTBISummary: Hi All, I am looking for To_date function to convert from varchar to date datatype in OTBI but To_date function is not available. Content (required): Is it poss…Surya Anbazhagan 2 views 6 comments 0 points Most recent by A.JOSH General Transactional Reporting (OTBI)
-
How do I bring back data greater than 6 months in Workforce Performance.Performance rating real timeSummary: We've been told that the link conversation performance only captured data from the last 6 months of the creation date. When we investigated the report there is …
-
Embed BIP Report with URL on page (HTML) and have parametersSummary Embed BIP Report with URL on page (HTML) and have parametersContent Hi, I've embedded my BIP Report on the Purchase Requisitions page succesfully using an iframe… -
How To Find Advanced Custom Object Subject Area In OBIEESummary How To Find Advanced Custom Object Subject Area In OBIEEContent Hi, Where do I find the Advanced Custom Object Subject Area in OBIEE? I need to find Custom Objec…edpalomo 13 views 2 comments 0 points Most recent by edpalomo General Transactional Reporting (OTBI) -
Presentation Variable Prompt causes Error on Results tab, but not in Open linkSummary AsOfDate prompt causes errors OPR4ONWY:U9IM8TAC:OI2DL65PContent I added the follow prefix to my analysis: SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}'; Then I…Brenda Jacks-49721 85 views 8 comments 0 points Most recent by CB General Transactional Reporting (OTBI)
-
BI Publisher Excel - How to get multiple horizontal repeating groups working?Content Hello There, I would like to know how can I get the below output using BI Publisher for Excel. I have three groups in the xml file. G_1 -> G_2 -> G_3 Below expec…
-
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 …Kunal Daya-76859 48 views 2 comments 2 points Most recent by _IshanAgarwal General Transactional Reporting (OTBI)
-
Wrap Text in MHTML formatSummary Wrap Text in MHTML formatContent Hi All, While selecting mhtml as a default template, i am not able to wrap text few columns such as description column. User wan…VAIDIA 13 views 1 comment 1 point Most recent by SantoshKumarB General Transactional Reporting (OTBI)
-
OTBI performance recommendations paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…Pavel Buynitsky-Oracle 35 views 4 comments 2 points Most recent by Pavel Buynitsky-Oracle General Transactional Reporting (OTBI)
-
How to version OBIEE report output sent to webcenter content serverSummary OBIEE reports are scheduled to send to WCC but getting "file already exists"Content We have several scheduled reports in OBIEE that are configured to send to the…John Stinnett 18 views 5 comments 2 points Most recent by Christian Berg-0racle General Transactional Reporting (OTBI) -
Custom PO Print - Text Attachment Content on BI Publisher ReportSummary We are creating a custom report where we need to display the Content of Text attachment for a Purchase Order. This information is not being stored in seeded Docu…Rahul L 26 views 2 comments 1 point Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI)
-
User Time-Zone in BI Publisher Excel TemplateSummary User Time-Zone Management in Bi PublisherContent Hi, I am creating a report which has to extract a field which is managed with TIMESTAMP. Since this report shoul…Alberto Romani-Oracle 27 views 3 comments 2 points Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI)
-
Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataSummary Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataContent Hi, We need to fetch the pending transaction Transfer details like New Loc…Nirmal Kumar L 24 views 1 comment 1 point Most recent by User_OWH0W General Transactional Reporting (OTBI)
-
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 fussi…Fongang 55 views 6 comments 1 point Most recent by AshishERPCloud General Transactional Reporting (OTBI) -
Referencing Parameters in the Layout Editor FilterSummary Referencing Parameters in the Layout Editor FilterContent Hi, What is the syntax we should use to reference a parameter in the Layout Editor Filter? BR Hany
-
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 th…Kevin Lee Choon 31 views 3 comments 2 points Most recent by prjohnson General Transactional Reporting (OTBI)
-
The tool 'OracleBIOffice.exe' is not available after R12 upgradeSummary The tool 'OracleBIOffice.exe' is not available after R12 upgradeContent We are not able to install OracleBIOffice.exe tool after R12 upgrade from the EPM Workspa…User_AEMC1 19 views 2 comments 3 points Most recent by user650055 General Transactional Reporting (OTBI) -
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 …Nathan CCC 24 views 2 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)