Welcome to the Oracle Analytics Community

Popular Tags
- OTBI 1,000
- Reporting 858
- Analysis and Data Visualization 671
- Analysis 583
- BI Publisher 538
- Administration 487
- reports 297
- obiee 288
- Oracle Fusion Analytics 287
- FAW 270
- Analyses 240
- BI Publisher Data Models 226
- Developers 220
- Data Connectivity 185
- Data Modelling and Datasets 164
- OBI Answers 153
- security 150
- Report Output 135
- Agents 134
- Packaging and Licensing 124
- Home and Catalog 117
- HCM 115
- ERP Analytics Content 114
- Access and Manage Data 107
- OBIEE Answers 105
Customizing Reports
Discussion List
-
OTBI-Learning-Is there a way to report on who specifically took the action to Withdraw the learner?OTBI - Learning Module - Is there a way to report on who specifically took the action to Withdraw the learner or who assigned the Learning item to the learner? For examp…HarishMalik 22 views 1 comment 0 points Most recent by HarishMalik Oracle Transactional Business Intelligence
-
6Customizing and saving filters on OOB/OAC reportsFor Pre-Built reporting, there should be a way we can save our customizations on the Shared Folders >Oracle >Fusion ERP without saving it to another directory. There sho…Juan Hurtado 55 views 1 comment 6 points Most recent by User_X4LHT Fusion Analytics Warehouse Idea Lab
-
RTF template return different output vs testing itHi, I am having issue with my report where its not returning the expected result/design but when testing it, its works fine. To give more context, I have this XML data a…Kiko III 41 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher (BIP)
-
2BIP: Document (Output) classification based on audience of report and other security classificationsThere is requirement from many customer to classify the report and add sensitivity labels based on sensitivity of data. This will reduce the effort of watermarking repor…Sanjaykuamar Varma-Oracle 31 views 1 comment 2 points Most recent by User_4Y9CY Oracle Business Intelligence
-
1Learning -Ad hoc access groups are storing as "ACTIVE" status in BIP table even deleting using UI.Hi Team, Learning tables are storing all the ad hoc access group created as ACTIVE in "WLF_LI_AG_RELATIONS_F" table even though Learning admin deleting user ad hoc acces…Kamini Kaushik-Oracle 2 views 0 comments 1 point Started by Kamini Kaushik-Oracle Oracle Business Intelligence
-
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 209 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…Pooja K-Oracle 1 view 0 comments 0 points Started by Pooja K-Oracle Oracle Analytics Publisher (BIP)
-
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 …Pooja K-Oracle 12 views 0 comments 0 points Started by Pooja K-Oracle Oracle Analytics Publisher (BIP)
-
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 32 views 0 comments 2 points Started by Abhishek Bajpai - CEAL Team-Oracle Fusion Analytics Warehouse
-
2Ability 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 13 views 0 comments 2 points 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 161 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 133 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 61 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 117 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 433 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 155 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 45 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 75 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 145 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 42 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 55 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 115 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 152 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 65 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 95 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 81 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 331 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…