-
In OAC DV, Do we have an option to show condition based Grand totals in Pivot table?
Our requirement is to enable dimension attribute value specific grand totals in Pivot table. For example: When we enable grand total on pivot table visualization it shows grand totals for all values of columns. We wanted to enable totals only for specific values. Is there a way to achieve this in DV?
-
How to utilise an unbroken time series in a visualisation?
We have a requirement to produce a Pivot Visualisation that includes an unbroken series of dates, from a filterable period, and the value of whatever measure is relevant. For example, in a period of 16/03/26 - 22/03/26 being able to see the number of activities a Resource has handled, including dates when the value is…
-
How to create subfolders in the semantic layer
Hello, I created a semantic layer in OAS where the presentation layer shows 3 table names with fields inside them. When the user opens a new workbook, he see 3 folders - account + time + credit cards, each folder containing a table with its fields. Is it possible to create subfolders? For example, inside an accounts…
-
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.
-
How can i connect from BI client windows to BI Server on linux
Installed: On Server Linux Red Hat 8.3 LINUX.X64_19c_DB Weblogic : 12.2.1.3.0 OBIEE : 12.2.1.4.0 2. On Client Window Server 2022 bi_client_12.2.1.4.0 Everything installed ok, but on step create ODBC, dns test error. So i cannot login BI Admin Online mode. Pics on attached files included error log. Have you encountered this…
-
Unable to create OAC connection to new ADW but connection from SQLDeveloper works fine
I created a new ADW instance to be the target of an OAC Data Flow. ADW creation was successful, and I can connect to the new ADW using SQLDeveloper from my on-prem machine. When I try to create the ADW connection in OAC using those same connection details/wallet file I get "Failed to save the connection. Invalid connection…
-
OAS 2025 to 2026 inplace Upgrade Failing for OPSS, MDS, and IAU Schemas with ‘Invalid DB Role’ Error
We are currently performing an in-place upgrade of Oracle Analytics Server (OAS) from version 2025 (FMW 12.2.1.4.0) to OAS 2026 (14.1.2.0.0) on Oracle Linux 8. During the upgrade process, we executed Upgrade Assistant and select the option “All Schemas Used by a Domain.” Observed Behavior The Examine phase completes…
-
How to set log level in OAS for semantic modeler?
Hi, I am trying to set the global/session log level within the Semantic Model for my OAS instance. I attempted to use the same method as the Admin Tool Gather and Analyze Query Logs but it doesn't seem to take effect. I found two articles from last year regarding this limitation, but I'm not certain if Oracle has made any…
-
How to edit Color of a Series in Chart
Hi, Hoping to gain some wisdom from you all. I want to graph Year over Year sales in Netsuite using a Workbook. My initial idea was to have bars for current year and area for last year sales, however, I wasn't able to do that. The best I could do is a Series for Last year and a Series for Current year. I thought that by…
-
Elasticsearch or Opensearch
Hi, Can I use (connect as datasource or dataflow) Elasticsearch or Opensearch in OAC? Thanks
-
Governance plug-in not downloading Dataflow details
I am using the governance plug-in, and I see no dataflow details downloaded. The SYS_DATAFLOWS is empty. The other 2 excels SYS_DATASOURCES, SYS_WORKBOOKS have data. Is anyone else facing this issue? Please advise.
-
0Auth2 E-Mail with Oracle Analytics Server 8.2?
Hi Friends! I've managed to get my head around the patch vs upgrade issue. I feel dumb. That said - I have a new issue I'm troubleshooting. I'm trying to get e-mail authentication working with our office365 server. smtp.office365.com:587 using STARTTLS. I've configured & tested the Tenant, Secret & Client ID's using…
-
Unable to find PATCH method in Salesperson Reference Accounts REST Endpoints
Hi , I need to update the Salesperson reference account segments, but I’m unable to find the PATCH method in the Oracle documentation. REST API for Oracle Fusion Cloud Financials - Salesperson Reference Accounts REST Endpoints
-
Using LOCATE() with Wildcards
Is it possible to use LOCATE(), or a similar function, with wildcards? For example, if i'm searching in a string for '%N.___.3__%'. Is it possible to use an existing function to find and extract the value using SUBSTRING()?
-
Oracle Analytics 6.4 >> 7.6 >> 8.2 SPB Question
Hello, Long time user - many time poster. Doing phase precheck for 7.6 & 8.2 SPB from OAS 6.4 // 35608828;OAS STACK PATCH BUNDLE 6.4.0.0.230715 (Patch 35607281) [03/20/2026 10:01:28] - [ERROR] - [preReqCheck] : [239]- OBI component e:\Oracle\Middleware\Oracle_Home\inventory\Components\oracle.bi.publisher\12.2.7.6.1 is not…
-
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……
-
Agent AI Oracle Analytics
Hello Team, I am trying to create an agent AI on oac using a dataset uploaded in the dv section. I created successfully an agent, but when I try to ask a question, the agent doesn't work. I can't see the dataset fields on the following section: How can I solve this problem? Regards
-
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.
-
P2T BICC
Hello! I’m currently involved in a project focused on data extraction via BICC from Oracle Fusion ERP. We have a P2T (Production to Test) process planned, where the Production environment will be copied into the Development environment. At the moment, we have extraction jobs configured in the Development environment, but…
-
Unable to access Oracle Analytics Challenge instance – No user returned via correlation policy
Hello, I registered for the Oracle Analytics and AI Challenge 2026 and received both the registration confirmation email and the “Your Oracle Analytics environment is ready” email. However, when I click the “Access Oracle Analytics” link and log in, I receive the following error: Oracle Cloud – oacstrategy Identity domain:…
-
OAC AI Agents - Forecasting and other predictive analytics capabilities
Hi team, I have a quick question regarding the AI Agent created and embedded in Oracle Analytics Cloud (OAC). Does it provide forecasting and/or other predictive analytics capabilities? If yes, could you please share the applicable documentation (link) and guidance on how to work and use those features? Thank you!
-
Access
How do I get an access to Reporting and Analytics?
-
Problem with variables in Data Filter in the Semantic Model
Good evening, in the same subject area we have a different beaviour for 2 uses with the same profile: the Data Filter to show only the data available for specific users -> with the SAME profile for different users the filter works properly while for other it doesn't work and the value from the variable in this case shows…
-
OAC conneciton to OTM
Hi Team, We have a requirement of extracting data from OTM into OAC for reporting puposes. Please let me know the options for the same in OAC. Regards, Jahnavi
-
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…
-
OAC: Automatically Take Snapshot Using Rest API and Store in OCI Bucket
Manage snapshots using Rest API has become more simpler than earlier. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/manage-snaphots-using-rest-apis.html All steps are similar as mentioned in above link , except "Understand OAuth 2.0 token authentication" . Detailed steps : - Create a storage bucket and a…
-
Shipment Dtl with item and PO dtl with PO nbr and seq_nbr have conflicting invn attributes
Hi ,We are getting this error when trying to create Inbound shipment for PO . When we send payload it is giving this error in input interface "Shipment Dtl with item and PO dtl with PO nbr and seq_nbr have conflicting invn attributes." ThanksKavitha
-
Dashboard prompt for direct database request
Hey all, I have built a direct database request in OAC and I want to create a dashboard prompt that will allow me to choose values based on data in one of the columns in the direct database request. Is that possible to do? I have been trying to do it using a presentation variable but keep getting failed to load error in…
-
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
