Popular Tags
- OTBI 1,468
- Reporting 1,403
- FDI 1,175
- Fusion AI Data Platform 1,029
- Analysis and Data Visualization 1,000
- BI Publisher 870
- Analysis 686
- Oracle Fusion Analytics 604
- Administration 556
- OAC 508
- OBIEE 435
- Fusion HCM Analytics 421
- Analytics 416
- Fusion ERP Analytics 402
- BI Publisher Data Models 360
- Security 301
- HCM 274
- BIP 267
- Answers 265
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 237
- Data Modelling and Datasets 230
- ERP Analytics Content 216
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Analyses
Discussion List
-
Dividing MetricsSummary I am trying to divide two metrics -- Not working!! Content I am trying to divide two metrics and am not getting the results I need. Can someone help? The number …slgott 271 views 12 comments 0 points Most recent by Cyrille Saulnier-Oracle Oracle Transactional Business Intelligence Forum -
Can data model data be called out by infolets on Oracle Cloud/Fusion?Summary In addition to analysis data, can data model information be added to infolet on Oracle Cloud/Fusion? Content Hello Oracle Community, Is there anyway to post data…Jonathan Chan gmg 81 views 6 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
How to display count(new customer account opened) from lasy year's month-to-date in analysisSummary How to display the amount of new customer account opened in last year's month-to-date, together with this year's month-to-date data Content Hello Oracle Communit…Jonathan Chan gmg 82 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
How to create a prompt, Year-Month format, in analysis while not having a "Month" dimension?Summary The goal is to enable end users to look at an analysis by year-month periods (ex. YYYY-MM, 2020-01), but "Month" dimension is not available within the subject ar…Jonathan Chan gmg 251 views 6 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
Scheduled Report JobsSummary Deails of Scheduled Report Jobs Content Hi Experts, I would like to know is there any seeded report to pull the complete details of scheduled report jobs in BI o…Charan Kollipara 231 views 8 comments 0 points Most recent by Akshay Aiyer Oracle Transactional Business Intelligence Forum
-
List of OTBI inefficient ReportsSummary looking for was to monitor OTBI reports performance and Frequency of use Content Hi All, I am looking for ways to monitor the performance of OTBI Reports in fuss…Fongang 101 views 6 comments 0 points Most recent by AshishERPCloud Oracle Transactional Business Intelligence Forum
-
Hidden fields in OTBISummary Need to find fields selected as 'Hide' as system default in column properties Content We have recently had an issue where one of our users has hidden a couple fi…Ruthie 261 views 5 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
Extract first sets of integer from entriesSummary How to extract the first sets of integer from entries in "New Calculated Measure" Content Hello Oracle Community, In "New Calculated Measure" in Analysis, how ca…Jonathan Chan gmg 171 views 8 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
Rows overcounting in AnalysisSummary How to only count the number of rows showing in an analysis Content Hello Oracle communities, When I attempt to display the total number of rows shown in an anal…Jonathan Chan gmg 112 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
SQL to Query Report Library - OTBI CatalogSummary Looking for SQL or tables to report a list of all reports, properties and folder location Content Does anyone have a SQL or know the tables that would contain th…Lisa G. 874 views 4 comments 0 points Most recent by Lisa G. Oracle Transactional Business Intelligence Forum
-
Error when using TODATE(REVENUE, YEAR) Oracle SQL functionSummary TODATE function resulted in error, what are possible alternatives to get the needed results? Content Hello Oracle Community, The below error (per enclosed 2 scre…Jonathan Chan gmg 211 views 7 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence Forum
-
Sort drop-down list descendingly in Table Prompts in AnalysisSummary How to sort drop-down list descendingly in Table Prompts in Analysis Content In OBIEE Analysis, how can table prompts value (per enclosed screenshot) be set to s…Jonathan Chan gmg 232 views 8 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
Referencing Parameters in the Layout Editor FilterSummary Referencing Parameters in the Layout Editor Filter Content Hi, What is the syntax we should use to reference a parameter in the Layout Editor Filter? BR HanyMr H 161 views 9 comments 0 points Most recent by Mr H Oracle Transactional Business Intelligence Forum
-
Report on SocialSummary Need to create a report on Application Social Content Hi, We have a requirement to build reports on Social. Are there any OTBI Subject area or Tables to select f…Mr H 61 views 2 comments 0 points Most recent by Mr H Oracle Transactional Business Intelligence Forum
-
How to override NULL values with existing valuesSummary How to override null value with values from another column in OBIEE Analysis Content When building an analysis in OBIEE, what would be the code to enter into the…Jonathan Chan gmg 482 views 8 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
How to do an average days to approve formula?Content Hi all, I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it w…Doron de Jong-57089 51 views 1 comment 0 points Most recent by aconavay Oracle Transactional Business Intelligence Forum
-
What is catalog folder Extension?Summary Does anyone know the purpose of the empty shared folder Extension in the catalog? Content The folder is empty. A duty role exists for it, BI_EXT_REPORTING_DUTY, …Nathan CCC 31 views 1 comment 0 points Most recent by User_7836 Oracle Transactional Business Intelligence Forum -
Building BOM using analysisSummary How to build a hierarchical BOM analysis showing on-hand quantity and item cost all for components in all levels Content In OBIEE, pre-built analysis "BOM" and "…Jonathan Chan gmg 51 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
Deferred Termination field in OTBISummary looking on how to determine a deferred termination Content Hello, I have been asked to create a report showing the associates with a deferred termination. When t…Kevin Lee Choon 61 views 3 comments 0 points Most recent by prjohnson Oracle Transactional Business Intelligence Forum
-
Help with Formula: most recent offerSummary I need help creating a formula to pull in the most recent offer Content I'm pulling together a list of YTD offers. I am finding records where the candidate has a…Rosenerie Castillo 131 views 7 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum