-
OAC Conditional formatting stops working for some Consumer Roles or Users
Recently a user told me they couldn't see any conditional formatting in your dashboard (Table Objet), but when I log in, it works perfectly. I created a new user account for test, I shared the report with the same role and the formatting was visible OK, but after a few hours it stopped working again! Older versions of the…
-
Universal KPI Banners for Any OAC Dashboard
SQL Expression Parameters let you build a live KPI banner that sits on any dashboard — independent of its datasets. Use it for company-wide metrics, operational alerts, or sales scorecards that every team needs to see. Examples and step-by-step instructions in the attached document.…
-
AI Agent - Subject Area Usage
Hi, Can we create OAC - AI Agent based on Subject area data. Regards Saroj
-
Getting "Not available due to errors" for Assistant with a Dataflow generated dataset
We are getting the "Not available due to errors" in the Assistant tab in a workbook. If I run the search manually it will refresh. I have tried leaving the the re-crawl on the refresh of the dataset. I have also scheduled the the crawl to refresh automatically and neither will work unless I process the search manually.
-
OAS 2025: Data security related question
Hi, we are using OAS2025, with EBS 12.2.1 OBIA 7.6.4, Oracle 19c on Linux. We have quite a few users who had access to a subject area, they created and saved reports in their 'My Folders'. Now over the years, they moved/transferred and don't have that role(s) which provided access to that subject area but they still have…
-
New security model for Data Flows\ Datasets
Hi- I am creating a workbook using a data flow created dataset. while in development, the workbook, dataflow, and resulting dataset are all in the same folder. Now that I have to deploy the workbook to another folder, do I also need to bring the dataflow and dataset to that new folder as well? I'm still a little confused…
-
Connection to Databricks from Oracle Analytics Server - Fails to load catalog
Trying to connect to data bricks from OAS using SIMBA Spark ODBC driver. In the DSN setup the connection is successful, but when try to refer it from OBIEE admin tool to import metadata, not able to see any catalog folders. Is there any listed steps to achieve this connectivity ?
-
How to connect Sharepoint to Oracle using Odata?
Has anyone successfully used OData to connect SharePoint with Oracle Analytics? If OData isn’t supported or practical, what other recommended or supported approaches have you used to integrate SharePoint data with Oracle Analytics?
-
Data Flows Monitoring in OAC
Hi, Is any one built any program / code to monitor data flows in OAC instance? We're familiar with Job feature, but we've noticed that it doesn't provide deeper insights into certain aspects we're interested in. Specifically, we're looking for more detailed information regarding the execution duration of the latest job,…
-
Urgent Request! - Oracle Analytics AI Assistant Embedding is down automatically
Hello OAC Community .We observed today (26-Feb-2026) our embedded AI Assistant is automatically not being displayed on the web page .This was working fine from last couple of weeks .On the console we're seeing the errors as shown in below screenshot : The embedding page was prepared as per the below OAC documentation (With…
-
OL7 to OL8 Migration for Oracle Analytics Server (7.6) & Oracle Http Server.
Hi All, I am testing OL7 to OL8 Migration for Oracle Analytics Server (7.6) & Oracle Http Server. I was able to verify Oracle Analytics Server(7.6) on OL8. For Oracle Http Server, we are using 12.2.1.4.0 version. when i run the silent installation on OL8, Installation was failing with the missing packages Starting check :…
-
EPM Cloud data(RealTime) and ADW data validation through OAC
Hi Everyone We were able to create a report in OAC using EPM Cloud connectivity. Is there a way to leverage this workbook to validate the data that is loaded into ADW? Our end goal is to validate EPM data against ADW. We have a subject area built on top of ADW that is currently being used, and we want to ensure that the…
-
Custom Tooltip Not Displaying Attribute Values in OAC When Columns Are Hidden
I have observed that the Custom Tooltip in OAC does not display Attribute values when multiple Attribute columns are present, and any one of those Attribute columns is hidden in the Pivot View or Table View. In such cases, the Tooltip only shows the Measure values. Has anyone else encountered this issue? Is there a known…
-
custom layout with shared image background
Hi, we are on Jan 2026 release of OAC DV. Trying to save the custom layout with a custom background of shared image. However, this image is not coming over when trying to select this layout. Any suggestions are welcome to address this.
-
in OAC DV, is there possibility of adding filter based on another analysis?
I am looking for a feature 'Add filter based on another analysis'. It exists in classic BI, we are looking for a similar approach Oracle DV. Please let me know how to achieve this
-
How unsubscribe?
-
Building a union report option via subject area is missing OAC DV.
Building a union report option from Subject Area is missing OAC DV. Please guide how to create a union report in DV
-
RESTAPI－SHIPMENT
I would like to register serial numbers at the time of shipment confirmation by using the REST API. Based on my investigation, it seems that shipment data and its child entities cannot be updated directly, so I am trying to use the “ShipmentTransactionRequests (POST)” endpoint to achieve this. The endpoint is described in…
-
Encountering "Max Rows Query Limit" Error
We’re encountering the [nQSError: 60008] "’Exceeded the maximum query governing rows 2000000 from the database " error while trying to retrieve data for a specific period. Even when reducing the period to 1 day, 1 hour, or 1 minute, we still receive the same error. We’ve observed this issue in two scenarios: Case 1: The…
-
In OAC DV, Do we have an option to enable condition based data actions?
In our Summary report, we have a requirement to enable data action links only to specific row values conditionally.
-
How to do a month-over-month comparison with this formula in Fusion / OAC?
Hello, I'm trying to calculate the turnover rate and hires with the formula below in Fusion (or Oracle Analytics Cloud), and I would like to know how I can make a month-over-month comparison. Here is the formula I’m using to calculate the hires/terminations: MSUM( FILTER( COUNT( DISTINCT "HCM - Workforce Core"."Employment…
-
OAS 2025 client admin tool shuts down
Hi, I have upgraded OAS 2024 to OAS 2025 (8.2) with all the patches I could find and everything seems fine. Instalation is on Windows server. I have installed also corresponding OAS client, setup ODBC connections and everything works ok. The issue is when I try to Import Metadata or view data on physical table……
-
In Oracle DV , Unable to repeat the values in Pivot table. All the columns are suppressed by default
Unable to repeat the values in Pivot table in Oracle DV. All the columns are suppressed by default. Our end users are not happy with the results appearance. The data export in excel format also has the same behavior. This is a required feature. Appreciate if this feature be rolled out asap
-
Creating one Apply button for multiple dashboard prompts
In various blog posts, we can find information about suppressing the display of Apply buttons on multiple dashboard prompts, and replacing them with a single Apply button. This method has worked well in earlier releases of OBIEE. As taken from those blogs, the method for suppressing the Apply buttons is this: 1. Create a…
-
Oracle Analytics AI Assistant - Ability to add numeric / text responses to the canvas
From November 2025 release version onwards, it is observed that the AI Assistant responses in the form of numeric values or text descriptions - are not having the provision to add to the canvas. This ability seems to be confined to only graphs generated. Why this was important? Only when we move the response to the canvas…
-
Need to unpivot a dataset in a tabular format in DV workbook
We want to display the column names as a row value in a pivot table, by placing the 'measure labels' between rows/columns as needed. This feature works well in classic report, but missing in OAC DV. Please let me know if this feature is or can be available anytime sooner
-
Best approach to build OAC reports for EPM cloud data
Hello All, We have a requirement to build reports in OAC for EPM cloud planning data, what is the best approach to do achieve this? Direct connection to EPM cloud from OAC DV. RPD (connect to EPM and model the data). Use ODI to extract data from EPM cloud and load into DW . Appreciate any insights on this, thanks in…
-
After installation of OAS 7.6 ,analytics login page gets timed out and xmlpserver page fails to load
Hi Team, After installation of OAS 7.6 , the analytics login page gets timed out and throws the following Error 500--Internal Server Error From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.5.1 500 Internal Server Error The server encountered an unexpected condition which prevented it from fulfilling the request.…
-
Unable to connect to ATP database from OAC
Hi, We have a requirement to create reports in OAC and the data resides in ATP database. We have created a connection in OAC to connect to ATP using database wallet. There is a ACL configured in the ATP db, we have included the Gateway IP of the OAC to allowlist the IP. But the connection is not successful. Can you please…
-
Why am i getting repeating metrics when i add line number to my report
I have an rpd whose fact table is based on flattened dimensions, in the physical layer the source dimetions together with other tables are joined to fact creating a start schema. Issue is when i create report my metrics are repeated and it seems like whenever i add one specific column my metrics getting repeated in…
