Popular Tags
- OTBI 1,371
- Reporting 1,352
- Analysis and Data Visualization 902
- FDI 897
- BI Publisher 792
- Analysis 655
- Administration 542
- Oracle Fusion Analytics 536
- OBIEE 415
- BI Publisher Data Models 324
- Analytics 310
- OAC 276
- Answers 259
- Security 254
- Analyses 251
- Developers 235
- HCM 225
- BIP 215
- Data Modelling and Datasets 209
- Data Connectivity 205
- ERP Analytics Content 193
- Report Output 180
- BI Publisher Report Templates 178
- Agents 148
- Customizing Reports 142
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Analyses
Discussion List
-
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 71 views 6 comments 0 points Most recent by AshishERPCloud Oracle Transactional Business Intelligence -
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 231 views 5 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
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 123 views 8 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
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 91 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
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. 764 views 4 comments 0 points Most recent by Lisa G. Oracle Transactional Business Intelligence
-
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 163 views 7 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence
-
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 201 views 8 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
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 Hany
-
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…
-
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 412 views 8 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
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 41 views 1 comment 0 points Most recent by aconavay Oracle Transactional Business Intelligence
-
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 32 views 1 comment 0 points Most recent by User_7836 Oracle Transactional Business Intelligence -
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 41 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
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 51 views 3 comments 0 points Most recent by prjohnson Oracle Transactional Business Intelligence
-
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 91 views 7 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence
-
Lost Functionality in OTBI after PB 10.17Summary After taking PB 10.17, we saw that icons did not work in OTBI. Content We test after every monthly patch. What we found was that, after 10.17, we could no longer…Aaron Hager-17476 41 views 1 comment 0 points Most recent by Matthew Carothers-Johnson Oracle Transactional Business Intelligence
-
Convert Date FieldSummary Convert from MM/DD/YYYY to YYYY-Qx Content Hello, I have a date field I want to convert. I want to convert that from MM/DD/YYY to "YYYY-Qx". Any thoughts on how …slgott 51 views 2 comments 0 points Most recent by slgott Oracle Transactional Business Intelligence
-
The tool 'OracleBIOffice.exe' is not available after R12 upgradeSummary The tool 'OracleBIOffice.exe' is not available after R12 upgrade Content We are not able to install OracleBIOffice.exe tool after R12 upgrade from the EPM Worksp…User_AEMC1 21 views 2 comments 0 points Most recent by user650055 Oracle Transactional Business Intelligence
-
Future Dated ActivitiesSummary Show me only the Opportunities that don't have a future dated activity added Content Hello, I'm struggling to think through how to do this. Here is the business …slgott 41 views 1 comment 0 points Most recent by MaartenDIF Oracle Transactional Business Intelligence
-
how to connect to Bi publisher administer console in fusion 19C?Summary How to access the bi publisher administer console in fusion 19c? Content I have added some roles to my fusion account. But, I cannot see the bi publisher adminis…Geetha Devi 141 views 11 comments 0 points Most recent by Geetha Devi Oracle Transactional Business Intelligence