General Transactional Reporting (OTBI)
Discussion List
-
Error occurs in query when we add one line in where conditionSummary Error occurs in query when we add one line in where conditionContent Hi, While adding this line in the existing query the below error occurs. Line used in where … -
Syntax to converting 24 hour time format to 12 hour format in sqlSummary Syntax to converting 24 hour time format to 12 hour format in sqlContent Hi, Anyone know the SQL syntax to convert 24 hour time format(eg. 18:00 for 6:00 PM) to …
-
Missing Name Infomration in Subject AreaSummary Cannot find field for Preferred Name, Employee Salutation, etcContent I cannot find the following fields in the worker or any other subject area. Preferred Name,…
-
Conditional FormattingSummary Conitional Formatting is not working properlyContent I have created a report to help our teams identify at risk background checks. The report uses OBI conditiona…
-
Delivered Analytics on system usageContent Hello, I am part of another go-live of Cloud HR Core, different company. Does Oracle now provide any OBTI reporting regarding system usage to capture adoption/us… -
Adding Totals to Stacked Bar GraphsSummary Looking for a best practice for adding a bar total to a stacked bar graphContent Has anyone found a way to add a total to a stacked bar graph?
-
HCM OTBI Reporting Challenge with User FoldersSummary Unable to see all user folders in Admin ViewContent In OTBI, our team is unable to see the entire listing of the User folders. Sometimes, they are visible, but m…
-
InitCap without EvaluateSummary Trying to arrive at "normal" case for names without Evaluate functionContent Names in our system are entered inconsistently and the goal is to be consistent with… -
External Data SourcesContent Hi All We are creating a bespoke application to complement Oracle Fusion. This application takes information from Oracle, processes it and then feeds it back int… -
Extracting Project Team Member Start DatesContent Hello How can I extract the the Person, Project Role and Start Date from OTBI or BI Publisher? I have found several subject areas where some of the information i…
-
Exporting report in CSV adds extra space to fieldSummary CSV report adds a space to a field, which doesnt happen when report is exported via Excel.Content Hi, I have one report which is automatically scheduled to be se…
-
How to assign BI Administrator role in R12?Summary How to assign BI Administrator role in R12?Content In R11 I was able to assign BI Administrator role in APM. Without this role users are not able to archive/unar… -
Adding two measures not workingSummary Adding two measures not workingContent I have a report where we are trying to add two measures together with a simple formula X + Y. This does not work within th… -
Help with DashboardsSummary Help with DashboardsContent I have created dashboards for managers to view. I have assigned permissions to the managers for the necessary reports. When I test to… -
Embedded Reporting/BI PublisherSummary audit report using offer fieldsContent Hello, I am trying to build a report for recruiters to use to audit the offers they have created. The intention is for the… -
Analytics Cloud (OAC) portsContent What ports does OAC currently use for the BI component? Is it 80 instead of 9704? How about for the Essbase component?
-
Calculate Yesterday date based on CURRENT_DATE variableSummary Calculate Yesterday date based on CURRENT_DATE variableContent Hello, how do I could calcolate obtain yesterday date based on current_date field in an OTBI analy…
-
OTBI Data Security is not working for Documents of Record Real Time Subject AreaSummary OTBI Data Security is not working for Documents of Record Real Time Subject Area -
Report that shows Agents and BI SchedulesSummary Report that shows Agents and BI SchedulesContent We have multiple scheduled BI reports and Agents and we need a way to shift through them all. I know the BI sche… -
Two Pivot Tables with Different ValuesContent Hi I am trying to contain a report that has two pivot tables in it but with different parameters to restrict the results. I am pulling in the Expenditure Type co…
-
Data Sync licensingSummary Want to know if we need to license data sync separately.Content Hi BI Experts, I am posting this on behalf of my colleague. We need the below details. Do we need… -
How to adjust 1000 notation within a BI Publisher graphContent Hello, We would like to adjust the y axis of a chart we made so that the 1000 counts are not seperated with a comma. Where can we adjust this formatting? See att…
-
Emergency ContactSummary Workforce Management - Person Real Time.Content Using Fusion version 7 and the fields phone number and phone type do not feature in subject area - Workforce Mana…
-
How to do MAX Date Logic less than Prompted AsOfDate in AnalysisSummary Trying to get the maximum Salary Change Date in OTBI AnalysisContent I am trying to convert a filter to SQL to get the maximum Salary Change Date that is less th…
-
Audit Report for Bank DetailsSummary Audit Report for Bank Details - Pulls all updates on employees bank detailsContent how do I create a audit report for employees bank details. This needs to show …
-
Extracting Configuration Options via OBIEEContent Hi All I've been asked to try and export the configuration options of expenses (Setup and Maintenance > Manage Policies By Expense Category). Now, I can export t…
-
Hands-On Training/Consulting Svcs on OBI DashboardsSummary Hands-On Training/Consulting Svcs on OBI DashboardsContent Hello:) Can anyone recommend a consulting services that provides hands-on training for OBI Dashboards?…
-
OBIEE Visual AnalyzerSummary Is visual analyzer available with OBIEEContent Hi we are looking for ways to load external data to OBIEE for reporting purpose. I saw the article https://develop…
-
report on user account details - Role NamesSummary SQL for reporting on employees rolesContent Can someone see how to stop the multiple rows from returning in below SQL? select "PER_USERS"."USERNAME" as "USERNAME…
-
Is there an Enhancement Request for BICS "exceeded configured maximum number of allowed input recordSummary Our BICS users get this error message when trying to look at years worth of data. Our users have to run multiple reports now in BICS to get the results. In OBIEE…