Popular Tags
- OTBI 1,482
- Reporting 1,408
- FDI 1,216
- Fusion AI Data Platform 1,043
- Analysis and Data Visualization 1,011
- BI Publisher 879
- Analysis 691
- Oracle Fusion Analytics 618
- Administration 556
- OAC 548
- OBIEE 437
- Fusion HCM Analytics 428
- Analytics 427
- Fusion ERP Analytics 413
- BI Publisher Data Models 362
- Security 303
- HCM 287
- BIP 268
- Answers 266
- Analyses 256
- Oracle Analytics Cloud 255
- Developers 248
- Data Modelling and Datasets 235
- Fusion Data Intelligence 219
- ERP Analytics Content 217
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Analyses
Discussion List
-
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 233 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 165 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 62 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 481 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 52 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 41 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 53 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 64 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 134 views 7 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum
-
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 Forum
-
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 62 views 2 comments 0 points Most recent by slgott Oracle Transactional Business Intelligence Forum
-
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 35 views 2 comments 0 points Most recent by Enzo Urbinati Oracle Transactional Business Intelligence Forum
-
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 51 views 1 comment 0 points Most recent by MaartenDIF Oracle Transactional Business Intelligence Forum
-
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 223 views 11 comments 0 points Most recent by Geetha Devi Oracle Transactional Business Intelligence Forum
-
Setting relative dates in a filter for an OTBI AnalysisSummary In an OTBI Analysis is there a way to add into a relative date range into a filter? Content I need an Analysis with a filter to pick up dates within the last wee…Tim Welsh 2.5K views 17 comments 0 points Most recent by Kamran Butt-161785 Oracle Transactional Business Intelligence Forum
-
Force Performance Tiles to show 0 versus No ResultsSummary Force Performance Tiles to show 0 versus No Results Content Is there a way to force a Performance Tile to show 0 versus the No Results message?Andy French 41 views 1 comment 0 points Most recent by Ankush Rode Oracle Transactional Business Intelligence Forum
-
Get privilege to issue logical SQL in OTBISummary As a developer i need to "Issue SQL" /analytics/saw.dll?issuerawsql to query using logical sql metadata repository database (rpd) with log level 2 then view log …Nathan CCC 202 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
R13.19C Introducing OTBI Metadata Independent Mode Using BI Cloud Connector (BICC)Summary Opt in to use the OTBI Metadata Independent Extract Mode in BICC introduced in R13.19C. Content What is the Change? Starting in Release 13.19C, BICC will no long…Rohan Lobo-Oracle 218 views 5 comments 0 points Most recent by Rohan Lobo-Oracle Oracle Transactional Business Intelligence Forum
-
Filter on blank and future datesSummary Create a filter using SQL expression to show just the null and future dated values Content Hello, I have a need to see only the null values and future dates. I'm…slgott 266 views 2 comments 0 points Most recent by SantoshKumarBhairi Oracle Transactional Business Intelligence Forum
-
Filter for terminations in prior calendar weekSummary I'm creating a termination report and trying to show which terminations were in the calendar week (Sunday-Saturday) prior from the week when the report was run C…Karen B 94 views 3 comments 0 points Most recent by Lavanya Reddy Oracle Transactional Business Intelligence Forum