Popular Tags
- OTBI 1,501
- Reporting 1,420
- FDI 1,293
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,015
- BI Publisher 898
- Analysis 699
- Oracle Fusion Analytics 634
- OAC 582
- Administration 564
- Fusion HCM Analytics 447
- Analytics 446
- OBIEE 444
- Fusion ERP Analytics 444
- BI Publisher Data Models 370
- Security 303
- HCM 295
- Oracle Analytics Cloud 294
- Fusion Data Intelligence 276
- BIP 272
- Answers 266
- Analyses 258
- Developers 250
- Data Modelling and Datasets 238
- Fusion Data Intelligence FDI 232
Analyses
Discussion List
-
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. 942 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 251 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 282 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 245 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 71 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 521 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 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 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 71 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 151 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 63 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 51 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 55 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 301 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.7K 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 201 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 221 views 5 comments 0 points Most recent by Rohan Lobo-Oracle Oracle Transactional Business Intelligence Forum