-
OAS DV embed fails behind HTTPS WAF due to mixed content (HTTP JS includes)
Hello, I have Oracle Analytics Server (OAS) where a DV workbook is embedded into an OAS dashboard. Everything works fine when accessing OAS directly via http://server:9502. We placed a WAF in front of OAS and now access it via an HTTPS URL. The WAF terminates HTTPS and forwards traffic to OAS over HTTP (9502). OAS itself…
-
ODI 14.1.2 Salesforce connectivity and options to handle Boolean data type columns
Hi, We have upgraded our ODI marketplace image on OCI from 12.2.1 to 14.1.2 recently. Post upgrade, we noticed ODI 12.2.1 is handling Salesforce integrations differently compared to ODI 14.1.2. Columns which has Boolean data in Salesforce e.g. True / False were extracted as 1/0 by ODI 12.2.1 where as same integration…
-
Tabular Visualization Padding Property
Hello….As shown in the below Tabular visualization. Can anyone pls tell how to remove Padding from the 3 sides of the Table ?.We want to remove padding for different widget sizes and also different screen sizes.
-
OAC AI Assistant Embedding Issue
Hello…We are trying to embed AI Assistant on our web portal .After indexing of our datasets we followed the steps from the document below(Example with Tokens). However we are not seeing embedding of AI Assistant .Are there any other steps for AI Assistant Embedding ,Pls advise. Document…
-
OAS Classic Subject Area and DV Dataset calcs use floating point (DOUBLE)
This behaviour may be expected in OAS but it is a bit frustrating when trying to filter out 0. Basically Combine a Subject Area with a Dataset by joining in DV workbook, go into Classic and create an analysis. Example Expenses = 100 and income = -100 from subject area, but, creating a calculation on the subject area…
-
Error Code:OBI\u002d00001 ,after logging inside OAC
Hello, We are unable to access OAC today and we're getting below error after login .Can anyone pls advise how to resolve this ? this is the first time we're encountering this issue. Thank you.
-
Email and SMS Alerts Functionality in OAC Canvas.
Hello, We have developed a dashboard having some KPI's in the Workbook Canvas .We need to implement the functionality wherein if the Sales/Revenue crosses a threshold or limit value then an email and SMS Alert is sent to the client. Kindly advise how to implement this…
-
DV vs. Classic Hierarchies
I have a client does not like the expanded drill down option in the DV hierarchy tree. Does anyone know if we can duplicate the hierarchy functionality on a column that in OBIEE Classic in DV. In Classic when you click on a column or data element and that column is part of a hierarchy it automatically sets a filter and…
-
OAS analytics dashboard textbox passes multiple filter items with ; ending it up with \;
I am trying two filter items in the dashboard, but prompt filter shows 111234\;111234A I need to get rid of \ to get the filter working properly. only ';' passes with '\' if I use ',' it shows as is. But for the OAS analytics needs ';' between two filter items. Any idea i can pass the multiple filter items? Thanks!
-
OAC scheduler fails to launch scheduled agent report deliveries
We are supporting an OAC environment that holds a reporting setup (repository, reports, agents,…) that was migrated from OBIEE 12c. Since 3rd Dec-25 (short after an Oracle SaaS upgrade) the daily scheduled report deliveries (there's more than 50) are being missed intermittently. It seems as if the OAC scheduler failed to…
-
Is there is file size restriction
I am trying to create a dataset which is 15MB with 18K+lines and when i got to edit the lines I am seeing not more than 100 lines. Is there something I could do to get all the lines pushed to editing page.
-
Limiting access so user can move content but not delete.
We have a security need in the OAC Classic Catalog - users need to be able to move content between folders but not be able to delete content from specific folders. Setting the role to Custom permissions and unchecking Delete leads users unable to move or rename content. Is there a Permissions setting that would allow for…
-
Enhancement Request: Enable OAC Classic Dashboards in Mobile Web Browsers
Oracle Analytics provides two types of dashboards: Classic Dashboards OAC Dashboards (modern dashboards with inbuilt mobile-responsive features) Currently, OAC dashboards are optimized for mobile rendering, but classic dashboards do not have an option to enable mobile responsiveness. Users accessing classic dashboards on…
-
ER: Support Seamless SSO to OAC with Keycloak Direct Grant (No IDCS Login Prompt)
We have federated Keycloak with OCI IAM (IDCS) using OIDC. (Followed:https://blogs.oracle.com/coretec/ssofederation-with-keycloak-and-idcs-andor-oci-iam-domains) Users authenticate into WebApplication using Keycloak Direct Grant (API-based token login). Current Behavior: When users click the OAC link from WebApplication,…
-
In my TEE zone, requisitions exist, but some user-defined field (UDF) values are not being pulled in
any one experienced disconnect with TEE and OAS ?
-
Setting a Session Variable for User Time Zone in OAS 2025 DV
Hi all, We are currently using Oracle Analytics Server 2025 (DV) and want to understand how time zones are handled at the session level Questions? In OAS 2025 DV, can we set a session variable that dynamically captures the user’s time zone (e.g., based on browser locale, user profile, or authentication context)? If yes:…
-
OAC, Professional Edition: table visualization, how to render line breaks
We have OAC, Professional Edition, November 2025 update: displaying a dataset in a "table" visualization there is no column option for "treat as html", etc. (text or number only). The data cell values are text containing <br> which is being displayed literally. Tried CHR(10) as well, no success. My user has the "BI Service…
-
How to use current date in a parameter
Hello, I am building some workbooks using OAC and OAS. I understand I can use system parameters as current date but how can I create a user defined parameter that is current date-3 (3 days ago) for example. I know I can easily create a calc to return current date and or current date -3 but instead of using calc as the…
-
DateTime used as filters
Hi All, I am trying to use the DateTime column in a Filter bar. It's all great but with one issue when the Calendar widget opens the timestamp shows time in increments of 5 minutes. My user is asking he has to manually each time enter the minute for eg 11:59 PM isn't there any way the widget can show increments in…
-
CASE Statement Not Evaluating with Level-Based Hierarchy in OAC
I want to change the behavior of certain columns in my OAC analysis that uses a ragged level-based hierarchy. What I've found, though, is that the value of a column in the hierarchy does not seem to be available consistently - or even at all - when I use it in a CASE statement. In my situation, my accounting hierarchy has…
-
DV Dashboard Filter-List option-display all related items + Selected item and same with dependent.
Hi, DV Dashboard Filter-List option-display all related items + Selected item and same with dependent filter. In 'List' filter. for ex:1 In 'Year' filter display all years and selected year, in 'Month' filter display all months with selected month. Year, Month filters are dependent on each other. Please see image. ex2:…
-
How to reset NetSuite Analytics Warehouse instance in NetSuite?
Hello, we have an unused NSAW instance connected to our NetSuite sandbox and want to change that to the instance that is being actively worked on. How do I do that? I'm new to NSAW. Thanks in advance!!
-
The application is requesting permission to access your account, Invalid login attempt
Hello, I'm trying to connect to Oracle Cloud Analytics to NetSuite sandbox and have been getting this error message. The NetSuite sandbox has another connection to a different NSAW instance that is not being used. So in order to create a fresh connection, I created a new integration in NetSuite and generated the Client ID…
-
Custom SSO with /analytics redirects to standard login page
We have custom SSO enabled for OAS 2025 and it works with BI publisher using the /xmlpserver URL, however if we like to use the analytics page as well, but the SSO does not work for /analytics URL… it brings up the standard Oracle login page. I checked and our SSO cookies are getting set in the browser properly, and as I…
-
Advice on Graph Visualization
Hi-I am trying to create a version of a stacked bar chart but I'm not having much luck and wondered if anyone has had success with this. Within each bar I want to show the original budget, the actual expenses against the budget, and the reforecasted (budget amount). For example, if the original budget was $11 M, and the…
-
OAS best Practices for HA / Failover
can someone recommend the best practices for HA /Failover for OAS between 2 servers , Active/Active or Active/Passive I am trying to install a second instance over the same DB and getting an error that the STB have already been used Also for DR what is the recommendation if DB if Prod and DR DB are in sync and host DB…
-
Zscaler issue with Idea Labs
There is no error page. After we log in, it reidrects back to the ideas lab page (home or the exact post), but we are not logged in. It’s like the cookie isn’t catching on our browsers.
-
Is it possible to use Global Country images in OAC DV workbook?
Hello All, We would like to bring country images in a report along with its revenue/Quantity. In OAC DV workbook BLOB data types are not supporting . In Classic analytics , images are displaying but when we include any measure columns getting error. I tried to use custom pluggin (Images) , Used country images URL's from…
-
Limiting number of rows a user-role can download from dashboard/dv/analysis/answers and BI Publisher
it is good to have ability to enforce additional security by limiting number of rows a user-role can download. we wanted the user-role to have ability to VIEW all the data within dashboards or answers without any restriction of data (not to be confused with data/row level security) but when the user is downloading, we…
-
OAS & DV access control question
Hi, we are using OAS2025, OBIA7.6.4., EBS12.2.12, Oracle19c on Linux. We have our core subject areas whose fact tables are grown > two billion rows over time. We are planning to release DV in stages, first to a selected group of users on custom datasets only. We want DV users to do their Adhoc queries/create workbooks etc.…
