Welcome to the Oracle Analytics Community

Popular Tags
- OTBI 949
- Reporting 844
- Analysis and Data Visualization 647
- Analysis 572
- BI Publisher 506
- Administration 499
- obiee 282
- reports 282
- Oracle Fusion Analytics 240
- Analyses 237
- Developers 223
- BI Publisher Data Models 213
- FAW 212
- Data Connectivity 184
- Data Modelling and Datasets 160
- OBI Answers 150
- security 143
- Report Output 133
- Agents 130
- Packaging and Licensing 124
- Home and Catalog 116
- ERP Analytics Content 109
- HCM 105
- OBIEE Answers 102
- Access and Manage Data 102
Customizing Reports
Discussion List
-
6Addition of more columns/fields to Generate and Transfer XML Transactions programOur client requirement is to generate CMF xml with additional columns from other modules like OMS/Inventory through Generate and Transfer XML Transactions program. But c…RupaliGahalot 21 views 0 comments 6 points Started by RupaliGahalot Fusion Analytics Warehouse Idea Lab
-
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…Donald 160 views 6 comments 0 points Most recent by User_307T7 Oracle Transactional Business Intelligence
-
Date value recorded in the standard Audit report.We have examined the last updated date in the audit table, 'IBY_EXT_BANK_ACCOUNTS_' but we've noticed that the timestamp values do not align; only the date (dd-mm-yy) co…
-
Tables to find 'Impersonator' and 'Impersonator ID' values in the Oracle fusionWhat is Impersonator and Impersonator ID in the standard Audit Report in Oracle fusion. In which table we can find these values for building the custom audit report. We …
-
Fusion Analytics Tech Tips : Custom Case Study PVO using Data Augmentation and Semantic ModellingThe document describes how to extract data from Fusion through data augmentation in FAW and then use it to build new subject areas . If your use case is The basic proced…Abhishek Bajpai -CEAL Team-Oracle 20 views 0 comments 2 points Started by Abhishek Bajpai -CEAL Team-Oracle Fusion Analytics Warehouse
-
1Ability to drag and drop rows in tables for a custom sortEvery company has a specific way of presenting financial statements, and we need the ability to sort accounts as needed rather than simply alphabetically or by amounts. …CarolineAnderson 11 views 0 comments 1 point Started by CarolineAnderson Fusion Analytics Warehouse Idea Lab
-
Fusion Analytics Tech Tips :Dynamic parameters - Creating custom Calc & Prompts based on logical SqlThe video is the continuation of the community post https://community.oracle.com/products/oracleanalytics/kb/articles/21-dyanmic-parameters-prompts-and-parameters-in-fus…Abhishek Bajpai -CEAL Team-Oracle 158 views 2 comments 8 points Most recent by CarolineAnderson Fusion Analytics Warehouse
-
Is there are way to get the list of reports data and the column details used in reach reportI want the list of reports using XYZ column. We used to get this in Onpremise installation from Catalog, but i am unable to export the list of reports and their path and…Abhilash Kothakonda 121 views 7 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Oracle Transactional Business Intelligence
-
Dependent parameters are not showing LOV'S when new custom ESS job created by copying standard ESSHi All, We have made customizations to the standard report and are currently attempting to create a new custom ESS job by duplicating the standard ESS job. The functiona…Pooja K-Oracle 57 views 2 comments 0 points Most recent by Sandeep19rm Oracle Transactional Business Intelligence
-
How do we extract the rejection rule details for a PO which has been rejected by predefined BPM ruleWe are preparing a POET validation BI report for a PO which flows thru a set of predefined BPM rules. In case of auto rejected PO's we need to extract the details and pr…
-
Report LogContent Anyone have an xml they would be willing to share or recommendations for creating a 'master' report that returns a list of all the BI reports in order to audit a…Kristy Bartnes 106 views 9 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence
-
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 342 views 10 comments 0 points Most recent by Vijay Ramani VJ Oracle Transactional Business Intelligence
-
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 136 views 10 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
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 46 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
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 69 views 4 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
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 employees Content Hi All, In which table I can find the reverse terminated da…Nirmal Kumar L 101 views 1 comment 0 points Most recent by Parag Hiremath Oracle Transactional Business Intelligence
-
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 46 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Oracle Transactional Business Intelligence
-
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 Hi…Cyrille Saulnier-Oracle 46 views 2 comments 0 points Most recent by Cyrille Saulnier-Oracle Oracle Transactional Business Intelligence
-
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 96 views 7 comments 0 points Most recent by AjayKumar Maddipati Oracle Transactional Business Intelligence
-
duplicay coming for each employee due to each employee have showing multiple mangersSummary: step by step.docx 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 fac…AjayKumar Maddipati 129 views 14 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
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. details.docx PFA Thanks, Ajay C…AjayKumar Maddipati 56 views 2 comments 0 points Most recent by AjayKumar Maddipati Oracle Transactional Business Intelligence
-
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 79 views 5 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
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 46 views 5 comments 0 points Most recent by Cyrille Saulnier-Oracle Oracle Transactional Business Intelligence
-
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 221 views 6 comments 0 points Most recent by A.JOSH Oracle Transactional Business Intelligence
-
Embed BIP Report with URL on page (HTML) and have parametersSummary Embed BIP Report with URL on page (HTML) and have parameters Content Hi, I've embedded my BIP Report on the Purchase Requisitions page succesfully using an ifram…
-
How To Find Advanced Custom Object Subject Area In OBIEESummary How To Find Advanced Custom Object Subject Area In OBIEE Content Hi, Where do I find the Advanced Custom Object Subject Area in OBIEE? I need to find Custom Obje…edpalomo 46 views 2 comments 0 points Most recent by edpalomo Oracle Transactional Business Intelligence
-
Presentation Variable Prompt causes Error on Results tab, but not in Open linkSummary AsOfDate prompt causes errors OPR4ONWY:U9IM8TAC:OI2DL65P Content I added the follow prefix to my analysis: SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}'; Then …Brenda Jacks-49721 128 views 8 comments 0 points Most recent by CB Oracle Transactional Business Intelligence
-
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 27 views 2 comments 0 points Most recent by _IshanAgarwal Oracle Transactional Business Intelligence
-
Wrap Text in MHTML formatSummary Wrap Text in MHTML format Content Hi All, While selecting mhtml as a default template, i am not able to wrap text few columns such as description column. User wa…VAIDIA 46 views 1 comment 0 points Most recent by SantoshKumarBhairi Oracle Transactional Business Intelligence
-
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 77 views 4 comments 0 points Most recent by Pavel Buynitsky-Oracle Oracle Transactional Business Intelligence