Popular Tags
- OTBI 1,401
- Reporting 1,365
- FDI 961
- Analysis and Data Visualization 953
- BI Publisher 816
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 543
- OBIEE 421
- Analytics 342
- OAC 336
- BI Publisher Data Models 335
- Security 271
- Answers 261
- Analyses 253
- Developers 240
- HCM 237
- BIP 232
- Data Modelling and Datasets 218
- Data Connectivity 205
- ERP Analytics Content 199
- BI Publisher Report Templates 184
- 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 181 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 359 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 227 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 333 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 384 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 72 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 61 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 165 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 141 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