Analyses
Discussion List
-
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 31 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 31 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 26 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 19 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 24 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 716 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 SantoshKumarB 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 35 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 28 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 78 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 20 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 135 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 97 views 3 comments 1 point Most recent by User_5NGE4 General Transactional Reporting (OTBI) -
To Extract Order Header and Line details using OTBISummary looking for Sample query that works to get Header and line details of available orders using OTBIContent Hi, Can someone please provide me working sample query f…Shalindra Singh 26 views 0 comments 1 point Started by Shalindra Singh General Transactional Reporting (OTBI)
-
Any way to bypass the row LimitationSummary Bypass Row LimitationContent Is there anyway to bypass the row limitation? There are times I need to be able to analyze more than 25,000 rows of data. This is ca…Robin Friedberg O'Connor 110 views 11 comments 1 point Most recent by Gustavo Erthal General Transactional Reporting (OTBI) -
Remove duplicate values in OBIEEContent Hi All, Is it possible to remove duplicate values in OBIEE? In my report, columns A and B have unique values per line for an employee, however, column G is all t…Natalie Andrek-27262 60 views 4 comments 0 points Most recent by RichardChan General Transactional Reporting (OTBI) -
OTBI Variable Presentation Date Prompt Format DD-MON-YYYYSummary Users need to be able to enter a date in DD-MON-YYYY format at the promptContent Our date format changed to dd-MON-yyyy (15-MAY-2017), but the only way the repor…Brenda Jacks-49721 96 views 1 comment 0 points Most recent by RichardChan General Transactional Reporting (OTBI)
-
Create a LDAP Data source for OTBISummary Need to be able to access LDAP folders from OTBIContent Hi, We have a need to verify the usernames in EPM to the LDAP account names. This is because we have inst…Vikram Pandalai 39 views 1 comment 0 points Most recent by Jessie Jones General Transactional Reporting (OTBI)
-
Reporting on Current Payroll Balances for a colleague i.e P60 Rate, Holiday Rates, Court Orders (othSummary Payroll Reports or Fusion pages that display the individual colleagues current BalancesContent Hello, Is anybody aware of a method in which we can view a colleag…Brad Hughes 49 views 1 comment 0 points Most recent by RyanPatrick General Transactional Reporting (OTBI)