Analyses
Discussion List
-
Sort drop-down list descendingly in Table Prompts in AnalysisSummary How to sort drop-down list descendingly in Table Prompts in AnalysisContent In OBIEE Analysis, how can table prompts value (per enclosed screenshot) be set to so…Jonathan Chan gmg 13 views 8 comments 1 point Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI) -
Referencing Parameters in the Layout Editor FilterSummary Referencing Parameters in the Layout Editor FilterContent 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 SocialContent Hi, We have a requirement to build reports on Social. Are there any OTBI Subject area or Tables to select fr…
-
How to override NULL values with existing valuesSummary How to override null value with values from another column in OBIEE AnalysisContent When building an analysis in OBIEE, what would be the code to enter into the …Jonathan Chan gmg 19 views 8 comments 1 point Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
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 20 views 1 comment 0 points Most recent by aconavay General Transactional Reporting (OTBI)
-
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, b…Nathan CCC 25 views 1 comment 6 points Most recent by User_7836 General Transactional Reporting (OTBI) -
Building BOM using analysisSummary How to build a hierarchical BOM analysis showing on-hand quantity and item cost all for components in all levelsContent In OBIEE, pre-built analysis "BOM" and "W…Jonathan Chan gmg 13 views 2 comments 1 point Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI)
-
Deferred Termination field in OTBISummary looking on how to determine a deferred terminationContent Hello, I have been asked to create a report showing the associates with a deferred termination. When th…Kevin Lee Choon 30 views 3 comments 2 points Most recent by prjohnson General Transactional Reporting (OTBI)
-
Help with Formula: most recent offerSummary I need help creating a formula to pull in the most recent offerContent I'm pulling together a list of YTD offers. I am finding records where the candidate has ac…Rosenerie Castillo 32 views 7 comments 2 points Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI) -
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 30 views 1 comment 1 point Most recent by Matthew Carothers-Johnson General Transactional Reporting (OTBI)
-
Convert Date FieldSummary Convert from MM/DD/YYYY to YYYY-QxContent 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 t…Stephanie Gott 25 views 2 comments 1 point Most recent by Stephanie Gott General Transactional Reporting (OTBI) -
The tool 'OracleBIOffice.exe' is not available after R12 upgradeSummary The tool 'OracleBIOffice.exe' is not available after R12 upgradeContent We are not able to install OracleBIOffice.exe tool after R12 upgrade from the EPM Workspa…User_AEMC1 18 views 2 comments 3 points Most recent by user650055 General Transactional Reporting (OTBI) -
Future Dated ActivitiesSummary Show me only the Opportunities that don't have a future dated activity addedContent Hello, I'm struggling to think through how to do this. Here is the business p…Stephanie Gott 16 views 1 comment 0 points Most recent by MaartenDIF General Transactional Reporting (OTBI)
-
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 administ…Geetha Devi 15 views 11 comments 1 point Most recent by Geetha Devi General Transactional Reporting (OTBI)
-
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 week…Tim Welsh 255 views 17 comments 3 points Most recent by Kamran Butt-161785 General Transactional Reporting (OTBI) -
Force Performance Tiles to show 0 versus No ResultsSummary Force Performance Tiles to show 0 versus No ResultsContent Is there a way to force a Performance Tile to show 0 versus the No Results message?Andy French 20 views 1 comment 0 points Most recent by Ankush Rode General Transactional Reporting (OTBI) -
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 23 views 2 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
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 longe…Rohan Lobo-Oracle 715 views 5 comments 7 points Most recent by Rohan Lobo-Oracle General Transactional Reporting (OTBI)
-
Filter on blank and future datesSummary Create a filter using SQL expression to show just the null and future dated valuesContent Hello, I have a need to see only the null values and future dates. I'm …Stephanie Gott 20 views 2 comments 1 point Most recent by SantoshKumarBhairi General Transactional Reporting (OTBI)
-
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 runCo…Karen B 34 views 3 comments 1 point Most recent by Lavanya Reddy General Transactional Reporting (OTBI) -
Future Dated ActivitiesSummary Show Opportunities with Future Dated Activities tied to themContent I posted this to the Reporting and Analytics for Engagement Cloud forum but I don't have grea…Stephanie Gott 14 views 3 comments 1 point Most recent by Stephanie Gott General Transactional Reporting (OTBI)
-
Customer hierarchy using BI Analysis (or OTBI)Content Hi All, I need to build a customer hierarchy report using BI Analysis (or OTBI). It should display Party Name, Party Usage and Primary Address. Can anyone help m…Rinku Gautam 27 views 6 comments 2 points Most recent by adelsorbo-Oracle General Transactional Reporting (OTBI)
-
Subtract resulting values of CASE functionSummary Need to subtract two values that are first derived using the CASE functionContent I have created two measure columns that use a CASE function. I am trying to sub…Stephanie Golly-Oracle 24 views 3 comments 2 points Most recent by RichardChan General Transactional Reporting (OTBI) -
How to get and SQL for our own OTBI AnalysisSummary SQL for OTBI AnalysisContent Hi All, How to get and SQL for our own OTBI Analysis.I know we can get this in the advanced tab but there we cannot see the sub quer…Praveen Kumar-146357 77 views 3 comments 4 points Most recent by Christian Berg-0racle General Transactional Reporting (OTBI)
-
New features - BICCC 19A patchSummary Document for new features list in BICCC - 19A patchContent New features has been added to BICCC Application as part of 19A patch, it is very good, but it will be…Senthilrajan V 19 views 0 comments 0 points Started by Senthilrajan V General Transactional Reporting (OTBI) -
Oracle Fusion OTBI Direct Database Query/ReportSummary Querying Oracle Fusion OTBI feature is being deprecated for CLOUD environment from 19A releasesContent Creating Reports with Direct Database Query in Oracle Fusi…Senthilrajan V 155 views 9 comments 2 points Most recent by Senthilrajan V General Transactional Reporting (OTBI)
-
CORS: Setting Access-Control-Allow-Origin header values for BI AnalysisSummary How to set the Access-Control-Allow-Origin for BI analysis.Content Hey, I am working with BI analysis (Sales Cloud Reports and Analytics) in Oracle Sales Cloud. …Gleb Gawriljuk-27720 17 views 1 comment 0 points Most recent by M Sridhar General Transactional Reporting (OTBI)
-
get greatest of two dates in OTBIContent Hi, I need to find greatest /least of two dates in OTBI using formula how can we do this in OTBI?Parthiban Vaithiyanathan-86705 26 views 6 comments 0 points Most recent by Prudence K General Transactional Reporting (OTBI)
-
Dynamic date variables using 'Between' calendar date promptSummary How do I set dynamic, default server variables on a calendar date that uses 'between' dates?Content Hello, I want to set a default date value on my dashboard dat…Stephanie Gott 35 views 2 comments 0 points Most recent by RichardChan General Transactional Reporting (OTBI)
-
OTBI: OTBI Agent with SFTP DestinationSummary How to Setup OTBI Agent to export report results to SFTP ServerContent Hello All, I have a request to export the result output of an OTBI report to an SFTP serve…Fongang 107 views 3 comments 1 point Most recent by User_5NGE4 General Transactional Reporting (OTBI)