-
BIP Data Model - View Data - Table View, get columns order exactly like in SQL
Description Oracle BIP Data Model has a relatively new feature to view data as a table (alternative way to XML view). Outstanding! Thanks Oracle. Table View sorts columns in the table in it's own, uncontrollable order, like newly added to SQL columns will be at the end, and so on. It would be nice if the columns order…
-
BIP - SQL to Excel in one click
Description Generate an Excel report from a data model in one click. Use Case and Business Need Hello, the quasi-totality of the reports we have to create are to be output in Excel. Since our requirements are typically too complex for OTBI, we have to create them in BIP. But to go from a working SQL in a data model to a…
-
GL_DAILY_RATES table mapping to OTBI subject area
Description Hi we have a requirement to build a custom report on FX rates. Though this info is available in BI tables (GL_DAILY_RATES), we do not have any subject area mapped to this table. Please consider mapping this table info to OTBI subject area so that Analysis and Dashboards can be created for FX rates. Use Case and…
-
Direct SQL access
Organization Name Golder Associates Description Continue to support the ability for direct sql querries for BI reports. Subject areas are too restrictive and slow to update. For example attachments are still completely unavailable. Use Case and Business Need Display links to attachments on BI report More details Display…
-
OTBI Analysis with a maximum of 25000 rows
Original Idea Number: c92fe9c4ff
-
Ability to automate backup/deploy of analytics and reports on Oracle Cloud HCM BI
Description Currently no tools are available to allow for automated backup and deploy of analytics and reports. There is no clear way to version our objects. We should also have the ability to store BI objects as code/text instead of binary. The binary objects can fail if you try to import across different versions of…
-
Search functionality in Select Subject Area window
Organization Name Inovalon Description CURRENT BEHAVIOR: When creating a new analysis, you are prompted to select a subject area to base the analysis on, but you must scroll through all of them to select the one that you need. DESIRED BEHAVIOR: A search function in the Select Subject Area modal window so that you may…
-
Security User Access Report for Oracle Fusion instance
Organization Name PricewaterhouseCoopers LLP Description Hi Team, We are looking for report to find out the login/logout information of all the users who are accessing the Oracle fusion instance. Please provide the security audit report with information like user name , user id , person number , person name , ;ogin time,…
-
DYNAMIC OUTPUT FILE NAMES USING DATE EXPRESSION WITH USER TIMEZONE
Description When generating file names dynamically using date expressions (https://docs.oracle.com/middleware/12212/bip/BIPUG/GUID-BC0A8B60-1BB5-4D85-85BB-B199C1A5C418.htm#BIPUG220), like Employee_%y%m%d%H%M%S.xls by default it takes UTC time zone. Example when an interface is ran at 2019-10-21 5:13:27 PM PST, the output…
-
BICC CodeCombinationPVO performance enhancement
Description FscmTopModelAM.FinGlAccountsCodeComboAM.CodeCombinationPVO Rel 19_13C This PVO performs extremely slowly when either these columns selected: CodeCombinationConcatenatedSegments CodeCombinationDescription We have 300,000 code combinations and selecting 58 columns from this PVO via BICC consistently took 3+ hours…
-
BICC CodeCombinationPVO performance enhancement
Description FscmTopModelAM.FinGlAccountsCodeComboAM.CodeCombinationPVO Rel 19_13C This PVO performs extremely slowly when either these columns selected: CodeCombinationConcatenatedSegments CodeCombinationDescription We have 300,000 code combinations and selecting 58 columns from this PVO via BICC consistently took 3+ hours…
-
Add "FTE Contract" to Subject area's in OBIEE - HCM Fusion
Description The field “FTE Contract” is missing in OBIEE – HCM Fusion. Based on the information from the table “PER_ASSIGN_WORK_MEASURES_F“ we should be able to find the field in the subject area "Workforce Management - Worker Assignment Event Real Time" and/or "Workforce Management - Worker Assignment Real Time". Only the…
-
Add "FTE Contract" to Subject area's in OBIEE - HCM Fusion
Description The field “FTE Contract” is missing in OBIEE – HCM Fusion. Based on the information from the table “PER_ASSIGN_WORK_MEASURES_F“ we should be able to find the field in the subject area "Workforce Management - Worker Assignment Event Real Time" and/or "Workforce Management - Worker Assignment Real Time". Only the…
-
API to allow config and especially ad-hoc run of BICC extracts and jobs
Description Request: API to allow invocation of BICC extracts and BICC jobs (equivalent to manually creating a Schedule with Recurrence = "Immediate") API to be synchronous – call does not return until extract is complete – and return an error code API to include everything possible manually via Console. For example…
-
Need an Report to get the List of ESS Jobs Submitted by Users
Organization Name Arcadis NV Description We are facing slow performance issue as of 19D Update on Projects and AP, we were able to see multiple ESS Jobs are Scheduled and running for a long time. Hence lots of users across the globe were submitting multiple process, which we were unable to monitor from Scheduled Process…
-
Allow advanced SQL statements in prompted filters
Organization Name Inovalon Description CURRENT BEHAVIOR: Prompted filters and data parameters on OTBI Analyses and BI Publisher reports respectively are limited to the operators given when setting up the prompt or parameter (equal to, between, like, etc), and these prompts and parameters do not accept SQL queries. DESIRED…
-
Annotations Functionality Enhancement Requests
Organization Name Carmel Partners Description * Enhance the locate annotations function in reports if report Grid Headers are Frozen in the FRS report design * Enhance users ability to update the original Annotation category. Use Case and Business Need Currently our organization uses multiple cross tab reports and are…
-
Unable to find Corporate Card Number field in OTBI Reporting subject area for Expense Module
Description Unable to find Corporate Card Number that is allocated to an employee for Expense module, in any of the subject areas for OTBI Report Use Case and Business Need We have a requirement to build a Custom OTBI report for client for Expense Module.For this we require to fetch Corporate Card Info that is allocated to…
-
Unable to find Corporate Card Number field in OTBI Reporting subject area for Expense Module
Description Unable to find Corporate Card Number that is allocated to an employee for Expense module, in any of the subject areas for OTBI Report Use Case and Business Need We have a requirement to build a Custom OTBI report for client for Expense Module.For this we require to fetch Corporate Card Info that is allocated to…
-
Scheduling a BI Report recursively using webservices
Organization Name Deloitte Description Hi Team, My Idea here is to schedule BI Reports using web services (SOAP UI) Use Case and Business Need The main reason to use this case is : Whenever there is a patch upgrade in production instance, there would be an issue that occurs which would be causing scheduling issues. So, in…
-
Direct SQL access
Organization Name Golder Associates Description Continue to support the ability for direct sql querries for BI reports. Subject areas are too restrictive and slow to update. For example attachments are still completely unavailable. Use Case and Business Need Display links to attachments on BI report More details Display…
-
Waitlist Count Filter
Description Within the subject area 'Workforce Learning - Learning Management Real Time' we are reporting on our classroom based courses and require a filter to show us 'Waitlist Total' (the number of people currently in the waitlist for the courses used). I have raised a Service request however it has been confirmed that…
-
Export OTBI Analysis Results Table View to CSV
Organization Name Inovalon Description CURRENT BEHAVIOR: When you export an analysis to CSV, the settings configured in the Results tab's Table View are not reflected in the CSV file produced. DESIRED BEHAVIOR: Have the settings configured in the Results tab's Table View reflected in the exported CSV file. Use Case and…
-
Add Date Acquired on Security Subject Area
Organization Name Principal Financial Group Description In the 19D update, the subject area Security - Roles and Privileges Real Time was delivered in OTBI. This subject area allows us to see what users have what roles, but it would be helpful for us to get the date that the role was assigned to particular users. Use Case…
-
Add Date Acquired on Security Subject Area
Organization Name Principal Financial Group Description In the 19D update, the subject area Security - Roles and Privileges Real Time was delivered in OTBI. This subject area allows us to see what users have what roles, but it would be helpful for us to get the date that the role was assigned to particular users. Use Case…
-
Scheduling a BI Report recursively using webservices
Organization Name Deloitte Description Hi Team, My Idea here is to schedule BI Reports using web services (SOAP UI) Use Case and Business Need The main reason to use this case is : Whenever there is a patch upgrade in production instance, there would be an issue that occurs which would be causing scheduling issues. So, in…
-
Pass the Presentation Variable/Prompt Values in ibot's (agents) output or attachment note
Description We have a requirement to pass the prompt values in ibot output or attachment note to show the user which prompts were chosen. When we try to pass the value using Presentaion Variable we get the following output in the email body (*** <variable> NOT FOUND ***) Use Case and Business Need It would be very helpful…
-
Paging Content Default
Organization Name ATCO Description Current The table properties for Table and Pivot table properties for Data Viewing default is set to "Fixed headers with scrolling content". Future Update the configuration in the InstanceConfig.xml file for grid views to have the Content Paging set to true. Please see the following…
-
DYNAMIC OUTPUT FILE NAMES USING DATE EXPRESSION WITH USER TIMEZONE
Description When generating file names dynamically using date expressions (https://docs.oracle.com/middleware/12212/bip/BIPUG/GUID-BC0A8B60-1BB5-4D85-85BB-B199C1A5C418.htm#BIPUG220), like Employee_%y%m%d%H%M%S.xls by default it takes UTC time zone. Example when an interface is ran at 2019-10-21 5:13:27 PM PST, the output…
-
OAC - Essbase Objects modification date stamp
Description OAC - Essbase objects (Outline, data load rule, calc scripts ..... etc) modification date stamp needed. On on-prem Essbase Administration Services, it has this function to allow administrator to see object modifications date. [Database properties -> modifications tab] Use Case and Business Need Essbsae in scope…
