Popular Tags
- OTBI 1,390
- Reporting 1,360
- FDI 943
- Analysis and Data Visualization 932
- BI Publisher 811
- Analysis 659
- Administration 545
- Oracle Fusion Analytics 540
- OBIEE 420
- BI Publisher Data Models 334
- Analytics 334
- OAC 312
- Security 260
- Answers 260
- Analyses 253
- Developers 239
- HCM 233
- BIP 228
- Data Modelling and Datasets 215
- Data Connectivity 205
- ERP Analytics Content 196
- BI Publisher Report Templates 182
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Customizing Reports
Discussion List
-
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 183 views 2 comments 8 points Most recent by Caroline Blanchard Oracle Fusion Data Intelligence -
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 343 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 224 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 141 views 9 comments 0 points Most recent by Praveen Kumar Akkala-Oracle 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 328 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 41 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle 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 382 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 74 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 65 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 131 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 221 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 71 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 161 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 142 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 1.1K 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 51 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 221 views 8 comments 0 points Most recent by CBeks 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 21 views 2 comments 0 points Most recent by _IshanAgarwal Oracle Transactional Business Intelligence