-
Dashboard/Dashboard Pages Level ,BIP Reports and Data Model level permissions
We are using OBIEE 12.2.1.4 on Windows 64 bit OS. We have a requirement to fetch Dashboard/Dashboard Pages Level ,BIP Reports and Data Model level permissions for users and groups. This is required for audit purpose to have a report of users/group having permissions on reports. Currently we are able to pull only the…
-
Report on all objects in OBIEE
Description Ability to report on all objects within OBIEE including BIP layouts/data models, OTBI analyses and agents Will make it easy to audit and migrate objects Use Case and Business Need Easily audit all BI objects Include: * object type; BIP layout, data model, analyses * last update date (potential for audit trail…
-
Sending prompted OTBI analysis results by email
Actually, system seams to be unable to send analysis results by using email function available in bottom of the page when user enters prompt values to filter analysis results. It should be useful following actions: user opens OTBI analysis > user enters prompt values to filter analysis results > user selects 'email'…
-
Increased Maximum Scheduled Rows on Scheduled OTBI Report
Organization Name Arcadis N.V. Description Currently the limit is 25k rows for scheduled reports regardless of file type. We currently have over 25k employees in our organization so it is impossible to send an employee listing via a scheduled OTBI report. Use Case and Business Need Send employee listings greater than 25k.…
-
Reports can be moved from One folder to another in OTBI
Description Reports and can be moved from one folder to another folder. currently it is required to copy the report and then paste to the new location and then delete from the old location. If the movement option available it will be good. Use Case and Business Need While managing the reports and analytics in OTBI when…
-
Enable More Secure and Current SSH Cipher suites
Currently BIP only handles the following cipher suites : https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/ssh-options-sftp.html. There are many missing advances and more secure suites from this list. This idea is to add a more robust and secure list of ciphers to BIP functionality. An example missing suite is :…
-
Excel template to be generating output in Excel 2007 or Beyond versions
Our client had a requirement of a custom BIP report with 99+ columns to be fetched and expected volume of more than 1 Million per execution. Current functionality allows us to handle 99+ columns using an excel template, however the output generated being in Excel 2003, the fetched records get split into multiple tabs to…
-
Add timestamp to report export file names
Our business user would like to have report export file names appended with a timestamp of when the report was saved. This will allow them the ability to have the report saved several times a day while including a differentiator in the file names. They will not have to open each file to see when the report was run. An…
-
Add Structured Payment Reference field in Subject Area Cash Management - Bank Statements Real time
Please consider adding this field. It is present in the UI and a field that our organization would benefit from having it available in a subject area analysis.
-
Oracle Fusion BIP Excel template should include output type as .XLSX
we have BIP report where we are using Excel template due nature of the requirement. Here we are facing an issue like with this template where output formats supports limited to (.xls,XML,CSV) with this .xls we have limitation like columns are limited to 256 and 65K rows supported . But client is looking for Does oracle…
-
Set security in data Model
Some users have access to the Data Model, and the customer needs to set security restrictions within the Data Model. For example, User X should only be able to see employees in Payroll 1 and should not have access to any data for employees in Payroll 2. However, when User X creates any SQL query in the Data Model, the…
-
Property or Option to Exclude a Field in the Data Model
The requirement is when we are exporting a .CSV report, we wanted to have an option to select/deselect fields to be included in the export file. We have a case that there are IDs in the data model that can't be removed because they are connecting the groups in the data model. The problem is, when we are exporting the…
-
Guarantee Order of Columns from BICC Extract
Organization Name The Cleveland Clinic Foundation Description Create a way to ensure the order of the columns from an extract using Business Intelligence Cloud Connector Console (BICC). A few ideas: * Ensure every extract has the columns in alphabetical order * Allow BICC to configure the column's order in a Data Store *…
-
Feasibility to view Trading Partner ID and EDI location code in the Receivables Subject area
Organization Name TITAN INTERNATIONAL Description Hi Team, The OTBI subject area "Receivables - Customer Real Time" had all the account, site and site purpose details. But the field "EDI location code"/"Trading Partner Id" (ece_tp_location_code) from hz_cust_acct_sites_all is not available in this subject area. Request to…
-
Subject Area Modification: Transaction Administration Real Time
Seeking additional fields from the Transaction Console/Manager to be added to the Transaction Administration Real Time subject area. Additional fields would include: "Name", "Approval History", "Comments and Attachments"
-
Restrict BIP access (table access) for person, sensitive data
When creating or editing a data model it should be possible to restrict data access to certain tables that contain person sensitive data such as Ethnicity etc. The security should be applied to data model access as well similar to the access via the UI.
-
Option to Exclude Columns in the XML Extract of BI Report
Organization Name Oracle Description In the old Reports Builder tool, there used to be an option "Include in XML". Setting this property would include or exclude the value in the final XML generated. It would be very useful if we have a similar option in the Data Model to include / exclude the filed in the XML. One…
-
Report Date Format Issue for Excel when exported from Unifier
Excel does not recognize the exported date format and manual adjustment is needed for the date to be recognized in a filter. Is it possible for us to change the date format of the export to the below format? We are facing issues when we are trying to sort the columns and filter them. A manual process is needed but when we…
-
User Role Usage Report
Organization Name GE Digital Description Ability to run a report that lists active users , the key privileges they have access to ( key privileges that drive subscriptions ) and the number of times this privilege was accessed in a defined period ( report parameter ) and the last time it was used. This will help assess if…
-
Donut chart type not available in OTBI
Description When can we expect “donut” charts to be available in OTBI. As of now, there is only an option for pie charts. Donut charts are currently options in Data Visualization and BIP though.. Vanderbilt University vice chancellors despise pie charts, and we are only allowed to use donut charts for any content or…
-
Implementation of Purpose-Based Separation of Process Controllers on BIP Server
In the on-premises Oracle EBS, we could setup custom Concurrent Managers, specify a maximum number for each process, and define jobs to be assigned to specific processes. I know that this functionality is not available in ERP Cloud. However, since I would like to control processes separately with different managers for…
-
Digital Signature Alignment to Multiple Pages - Reports
DSC should get aligned on the right place even though the number of pages increases to 2 pages. Our goal is to display the digital signature at the end of a multi-page invoice. Currently, the digital signature is always printed at the fixed position specified in the report properties, but it needs to adjust dynamically…
-
BIP Charts need to be enhanced
Charts have gridlines but in our requirement we need to prepare chart without gridlines.
-
Provide provision in BIP report to create data model using REST API
Provide provision in BIP report to create data model using REST API, So report can be made from external source data also like from ATP DB etc.
-
Inclusion of Date of Probity, Date of Interview & other phase dates in recruiting subject area
Hi Team, Customer wants to see Date of Interview, Date of Review, Date of Manager Shortlist etc. phase dates in an OTBI report. Currently we are pulling these details with the help of last update date field with the help of current phase ID which is not a good way as there could be chance that application gets updated for…
-
Automatically apply the filters set in parent report to the drill-down/child reports
If you run a report that includes a filter to exclude certain domains (i.e. your company's domain) from the results, the child report linked to the parent report (Drill down report) does not include that filter so the totals of both reports won't match, as the child report will include all contacts regardless of the…
-
Generate ZIP file out of CSV-XML Output from Report
Description We have requirement to generate the zip file consist of BI report CSV and XML output and have to upload it to UCM server for further processing Use Case and Business Need We have requirement to generate the zip file consist of BI report CSV and XML output and have to upload it to UCM server for further…
-
In OTBI Report How can we defaulft 'Value Suppression' as Repeat in Column
Description In OTBI Report, the column value defaulted the 'Value Suppression' as Repeat Use Case and Business Need While defining the OTBI analysis the default value for Suppression is Suppress, and to make the Repeat every time need to go on indivisual column and then change the Column properties to Repeat. Original Idea…
-
Add additional information on source transactions in Budgetary Control – Transactions Real Time
We would like to get some additional information on the source transactions in the Budgetary Control – Transactions Real Time subject area. We would like to have some consistency on supplier name and supplier number across, Payables transactions, Purchase Order details, Requisition details and Receiving Transactions…
-
Is there away to find the OTBI reports sending to which mail ids
Currently we don't have feature to restrict domains for OTBI reports which is having a chance of data breach. Oracle mentioned they are working on this domain restriction. We are looking is there a way we can identify users scheduled reports to which e-mail ids to mitigate issue. Please can anyone share if they has the…
