-
Programmatically hide the menu option "SQL Query" in Diagram tab under Data Model.
The idea here is to NOT allow customer to write their own open ended SQL query based BIP reports, but rather use Analysis and subject areas only. This allows us to have little more control about what customer can and cannot do with their instance of OAS when offered as an Oracle SaaS product.
-
European number format for French Locale
Despite the new march 2024 ability to define Language and Locale in the profile, the number format for "French" is not the one expected (dot as thousand separator and comma as decimal separator). Nevertheless this expected format is available in spanish language. It appears that this is due to the international CDLR based…
-
Scaling settings to show chart value numbers as it is instead of rounding it up to Thousands (K)
Hello everyone, I am using Oracle PLM Cloud Version 24A (11.12.24.01.0) And I am creating a data model with FSCM Database source and then I am creating report template on top of it. I'm currently utilizing Oracle BIP Report Layout, and within my charts, I'm displaying item counts. However, I'm encountering an issue where…
-
To be able to rename a column in Workbooks
At the moment there's no way to rename a column when it's added to a viz. In many cases it's necessary to rename the columns because depending on the viz you might want to have a different label. Possibility of including variables/parameters like {current_month} in these column labels would be highly appreciated as well.…
-
To be able to apply custom formats to numbers in a similar way it's possible in Classic Analytics
It would be great if wee were able to format numbers in different custom formats as we are able to do in Classic Analytics using format strings like: #,#0.0, thousand separator and 1 decimal #,#0, thousand separator and without decimals
-
Extension of OAS End of Error Correction
Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): Many tests are required when upgrading the version. Therefore, it takes a lot of time.The "Grace Period: 1 year" in document ID 2775561.1 is very short.Even if you…
-
Automate processes required by Oracle after a release update
I am implementing the steps in this document. https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/time-labor/releases/23B/23B-time-labor-wn.htm One of the steps was to run a process: ESS job to create index definition and perform initial ingest to OSCS There was this note: Tip: You need to run this…
-
Exporting OAC dashboard reports in unformatted (Excel/CSV) version through Agents
Organization Name Uponor Oyj Description The standard OAC agents exports the formatted reports with 25000 rows. There is no option in the current OAC version (5.7) for exporting the reports in unformatted version through agents like dashboard reports which can be exported in Unformatted/Formatted output files. Use Case and…
-
Automatic Config File Genaration for New Region Build Process
The current implementation is creating config files manually for each incoming new regions. This involves human error and redundancy causing delay in region build. Proposed idea- To create config files in a automated way and store in OCI object storage using a template. Tools- Terraform/Shepherd, bitbucket , Scripting tool…
-
List of workbooks created by user in OAC
Is it possible for us to generate a list of all OAC workbooks that have been created by a specific user?
-
Enhancing OCI Logging To Self-Service Troubleshooting Init Block Issues In OAC
Use Case: Init block execution failures cause issues in OAC. Following is some of the common use cases: 1. Data level security not getting correctly / incorrect report data 2. Loading of the subject areas taking a long time while creating analysis 3. "504 Gateway Time Out" Errors Available Troubleshooting Options: 1.…
-
Review Supply Availability Consumption to Include User Defined Reservations
We've observed that only reservations originating from Sales Orders are being reflected in consumption within RSA ("Review Supply Availability"). However, it's essential to note that reservations classified as 'User Defined' are not currently supported in either HVGOP or C++ GOP. Our business operates with an additional…
-
Workbook data sets blend should be independent and changes should not impact other workbooks.
Workbook data sets blend should be independent and changes should not impact other workbooks. When we add dataset to workbook , by default it is defining match. If we delete it is giving error and impacting other workbooks. Strange workflow. If we do something here and impacting something else is strange.
-
Grand Total & Sub Total title should have custom option to update.
There are many instances, we change the title of Grand Total. Grand Total of Average of months , showing Average value under header of "Grand Total" which is meaning less header.
-
Allow creating connections to Postgres DB lower than 9.0 versions
Allow creating connections to Postgres DB lower than 9.0 versions (Major drawback as we won't be able to visualize critical data) Very Important
-
Parameter anomalies when setting a filter in the BIP report
Summary There was an anomaly with the report parameter. The scenario is that when the set parameter option in the report is set to "ALL" it works fine, it can generate data as expected. But when "ALL" option data is not set, for example I have only one unselected among the options in the list, it automatically includes…
-
"Refresh other parameters on change" option for Date parameters
Description We are looking for a way to have an option for refreshing other parameters with Date type Prompt. Use Case and Business Need We have a requirement that needs to be applied to our reports for all effective dates in reports that are dependent on the date parameter. But as per our ticket in Service request the…
-
OAC - USAGE TRACKING SUPPORT FOR SQL SERVER
OAC usage tracking only supports Oracle DB and ADW as of now. Request is to add usage tracking for SQL Server DB in coming releases.
-
Model Monitoring equivalent functionality in OAS
In OAS, there is in-built functionality to create machine learning models using the built-in algorithms, but as I understand it, there is currently no way to understand model performance / monitoring. This would have a detrimental impact to an organization once the model is productionized. There would be no way to…
-
Allow creating your own colour palette access universally on other visualizations
Allow creating your own colour palette that can be used and available for all other visualization dashboards.
-
Allow Exporting reports in excel format. Very IMPORTANT
Allow Exporting reports in excel format, users sometimes prefer having the report in excel so they further analyse it or use it for other purposes
-
iBot/ Agent: Separate Administration Role
Here I am suggesting to have a separate Administration Role exclusively for Agents/ iBots. Till now users are not able to edit other users Agents due to limitation in Product. If any of the user left the team or organization then those Agents are to be stopped or Assigned to some others by BI Administrator. If we have…
-
Oracle BIP DataModel -> Default views 'Table View' and '200' rows - Possible
Description Hello, Just wondering if there are any default settings available to achieve 'Table View' and '200' rows. Attached a picture. If not, I guess its high-time to consider these small settings in next releases. You can find more information at this post https://cloudcustomerconnect.oracle.com/posts/509953cb2a.…
-
Distributing items across containers
We are encountering somehow unique business case , but this use case may be applicable where components are shipped before final assembly. Case: Order bundle may consists of multiple items (eg. A bundle consists of 1 toy, 1 small story book, 1 pencil, 1 eraser) So, When we receive order it will have 4 lines each with huge…
-
Copy style of a viz/canvas and paste it onto a target viz/canvas.
Authors should be able to copy styles of a visualization and apply the copied style on to a target visualization. This would enable the workbook authors to quickly apply homogeneous style across the canvas, by copying common property attributes from a visualization and apply same property on target visualizations. This…
-
xlsx generated from BIP need MIME type as application/vnd.openxmlformats-officedocument.spreadsheet
Excel output (.xlsx) generated from BI Publisher/Oracle Analytics Publisher has MIME Tyep set to “application/zip”. There was no issue in opening this excel output generated from BI Publisher in Excel. But, when tried to associate this generated Excel Output from Oracle Transportation Management Cloud (OTM) application,…
-
Emulate a user login
Can we log in as another user to see their view? It would help troubleshooting and security testing much easier.
-
Oracle Analytics Server 6.4 - Advanced compression feature enabled by default
Hi, In Oracle Analytics Server 6.4 application, Would like to know if it is feasible to disable the Advanced compression feature enabled by default for XMLP_DOCUMENT_STORE_PART Table in BIPLATFORM schema. This schema is created using the OAS repository creation utility. We would like to know if the securefile compression…
-
Request OAC Enhancement to call REST API for run OBIEE Agent.
Request OAC Enhancement to call REST API for run OBIEE Agent. Hi, Currently, I have a ETL daily jobs for load data to ADW. and I have OBIEE report on OAC for monitor ETL daily jobs. I need to use ETL workflow endpoint to call REST API for run OBIEE Agent on OAC. PS. My ETL tools is support call REST API such as command OCI…
-
In Properties panel , "Display As" should have one more option "Running Sum".
In Properties panel , "Display As" should have one more option "Running Sum". It will help in creating additional calculations. Most of the time, it will help is Display of "Aggregating Sum values" and display them as "Running Sum". This is already available in OBIEE classic.
