-
How unsubscribe?
-
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…
-
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.
-
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.
-
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…
-
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…
-
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…
-
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……
-
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…
-
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
-
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
-
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
-
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
-
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…
-
Azure AD a Certified Identity Store / LDAP for Oracle Analytics Server (OAS)
Is Azure AD(Entra ID) a Certified Identity Store / LDAP for Oracle Analytics Server (OAS)? Azure AD (Entra ID) → SAML → WebLogic (OAS)
-
CPU JANUARY-2026 PATCH FOR THE OBIEE 12.2.1.4.0 SOLARIS SPARC SERVER
Kindly suggest the CPU JANUARY-2026 PATCH FOR THE OBIEE 12.2.1.4.0 SOLARIS SPARC SERVER
-
Access Control Issue: DV Datasets Visible in Classic Analytics
We have observed that, by default, Data Visualization (DV) datasets appear in the “Create Analysis” list under Classic Analytics in OAC, regardless of specific user or role permissions. The background of this issue is that the user currently holds the BI Author role. With this role, users are able to create Classic…
-
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…
-
Possibility to have classic features of Prompts - Hidden variables / Repository var in SQL
Hi What are the chances of bringing options for hidden variables , make it similar classic options in terms of prompt sections with dynamic variables/request variables/ repository / session variables use in the prompts. Thanks, Senthil
-
Embedding DV Workbook in BI Answers Classic Dashboard - Row Count Safeguard Gap (OAS 2025)
Hello Community, We are currently on Oracle Analytics Server 2025 and using both the Modern DV platform and BI Answers Classic. We have a requirement to embed a DV Workbook inside a Classic BI Dashboard page. Our DV Workbook is built on top of a Subject Area (RPD-based), not a direct database dataset. The Challenge: In BI…
-
Problem DV in Classic Home Oracle Analytics
Hello Team, I encountered some problems visualizing a DV content in the Classic Home. If I try to view it in the DV section I see the workbook correctly, while if I try to view the workbook in a dashboard page of the classic home, I see "the loading page". I can see this problem also in other projects. Thanks
-
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…
-
Oracle Analytics Instance Access issue
I have registered for Oracle Analytics and AI challenge 2026 and I got provided with access for Oracle Analytics instance. But when I try to access that, it's showing like this.
-
Workbook filter - dynamic selection of last 3 / 4 years from the list
OAC version - January 2026 We have workbook(s) with filter (s) and we want make the selections to be dynamic , like latest 3 years from the list OR it could be 4 years . want to make selections dynamic so that when we have cross over next year the selections should be automatic and we don't need to update the selections…
-
OAC-Derived Date column weekday display on Tooltip
Hello…As shown in below screenshot of a simple bar chart showing Products sold and revenue .We are required to display Weekday(Sunday.Monday,etc) data on the tooltip .However Tooltip section only allows measure data .Kindly advise how to implement this. The requirements are also mentioned below : 1)Displaying Weekday on…
-
Automate 'Reload Data' from DV dataset.
How can I configure my Oracle APEX application to automatically refresh the data from an Oracle DB data set after an edit, so that the user sees the change in real-time without needing to click "Reload Data"? It feeds off of the OAS analysis, but the data is sourced from a dataset that is not in the RPD
-
Get path from catalog element, e.g. to be embedded in an agent
Hello Oracle BI experts, We have hundreds of agents where the path of the current location, a full path or a catalog element name is being added, e.g. into the attachment note under delivery content of an agent, example below. Is there a way to use a variable or any other solution to dynamically add the path of the current…
-
BI publisher data connection. ODBC
I am trying to create ODBC on DV data connection. for DSN should I put a entry from TNSNAMES.ora? let me know.
-
"The report runs fine with my user ID, but it takes 22 minutes when the functional user
there is a Employee master data of Physicians report is runs fine with my user ID, but it takes 22 minutes when the functional user please help me this case
-
Report OAC embedding error
We are trying to embed an OAC Report in Saas using sandbox but when we open the application it returns this error: It tried the link outside the page, directly in a web page and it works. So it is a problem just inside the page I created. someone knows how to solve the problem?