-
Error filtering out nulls & zeros on calculation columns
I am using calculations to show costs for a specific month and currency (Month 1 & Month 2, derived from two month parameters). I also have a Growth/Decline column (calculated percentage difference between the two month data calculations). I want to not show the rows where these calculated columns are zero or null. When I…
-
Support BI Server Session Variables in OAS/OAC Data Visualizer (DV)
Oracle Analytics Data Visualizer (DV) does not currently support BI Server session variables (e.g., NQ_SESSION.*) that are defined and evaluated in the RPD semantic layer. This creates a functional gap between: BI Answers, which fully supports session variables and enterprise semantic logic, and DV, which relies only on…
-
Incremental Data Access
In the OAC Data app, incremental data access was removed, which directly impacted many datasets. Was this option truly removed?
-
RPD download was not working - OAS 2025
Hi team, We had recently migrated to OAS 2025 with October patch, we are unable to download the rpd from the server. we used below command ./datamodel.sh downloadrpd -O RPDname [-W RPDpwd] -SI service_instance -U cred_username [-P cred_password] error below - Post downloadrpd REST with…
-
Exporting data from REST API OAC to CSV/XML/JSON or similar format
Hi, I'd like to export data from an OAC analysis or workbook via the REST API to CSV, XML,JSON, or another format that's easy to import into a database. If this isn't possible via the OAC REST API, perhaps there's another similar solution.
-
OAS 2025 Upgrade Problem. BIP reports are missing Parameters when added to a dashboard page
Hello All We are migrated to 8.2 with October bundle patch. All the reports of OAS is running and working fine as expected expect the BI publisher report in OAS. We facing the problem where BI publisher Prompts are displaying in Catalog, not in the Dashboard page when it was embedded in OAS Dashboard pages. We had cross…
-
OIC Connection that has Pre-Request script based authorization
Summary: We are trying to establish OIC connection with an application. Need your help. Content (required): We can connect using Pre-request Script in Postman. Need to replicate it in OIC. Pre-request Script: var public_key = "XXXX"; var private_key = "YYYY"; var tenant_id = "ZZZZ"; var service = "search"; var method =…
-
How to set a fixed width for a column in OAC Classic Dashboard?
Hello, I'm creating a dashboard and adding some columns to include links to other dashboards. However, these columns are dynamic and keep adjusting to each other as I add items to them. Is there a property that allows me to set a fixed width for the columns at a specific value? Thank you in advance
-
List of Oracle FUSION Audit Reports
I am looking to obtain a list of audit reports? is it possible
-
How to set a fixed width for a column in OAC Dashboard?
Hello, I'm creating a dashboard and adding some columns to include links to other dashboards. However, these columns are dynamic and keep adjusting to each other as I add items to them. Is there a property that allows me to set a fixed width for the columns at a specific value? Thank you in advance
-
Oracle Fusion BICC PVOs - Invoice processing
I am looking for PVOs related to AP - invoice processing - Invoices, approval, validation, payment information, etc. I do see a couple of PVOs that say Invoices in this Doc ID: How to Review Database Lineage Mappings, Check For Columns and View Objects for BICC PVOs? (Doc ID 2626555.1)…
-
Scheduling OBIEE 11.1.1.9 reports to FTP server
Hi Please advise how to schedule the OBIIEE Excel reports to FTP server .I am using the OBIEE11g 1.1.9 version. we do not have an option for scheduling the export using BI publisher reports ,so we dont have any direct option for scheduling the OBIEE reports to FTP server.
-
Double Data type values coming in Analysis as integer values
Recently we have migrated OBIEE 12c (Backend: Netezza) to OAS (Backend: Databricks) by migrating RPD and catalog as such. But while running analysis could see measures from double/float data type with precision values are showing only integer values and decimal places values are coming as 0. Eg: Sales values 145677.755 is…
-
Unable to save Agent in OAS 2025
Hi Team, We had recently migrated to OAS 2025 - 8.2 with October bundle patch. All the reports/Dashboards are working and running fine as expected. But we are unable to save the agent after creating new. Error as below - Oracle Analytics Scheduler Error: [nQSError: 12002] Socket communication error at call=connection:…
-
How to monitor OAC Usage statistics
Hi All, We have an OAC instance with a daily increasing user base. We would like to know the peak OCPU usage of OAC so that we can preplan any scale-up or scale-down activity in advance. In the OCI console, I could only find query metrics. Is there a way that showcases OAC OCPU consumption and related metrics? Version…
-
How to get the direct URL to pass parameter value directly in OAC DV
Hi, I am trying to get the URL for below scenario. I have one prompt called "Email" and value is satish.reddy@oracle.com in one of the workbook so I need to pass this value in direct link without going to workbook. if you have idea then please share the link ? ex:…
-
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…
-
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…
-
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!
-
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.
-
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…
-
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…
-
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…
-
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…
-
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…
-
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.
-
How to setup row level security in rpd
I have setup row level security in oracle analytics cloud rpd based on application roles but when i upload the rpd my filters dont seem to work, I wanted to know if any one else has run into this issue and how they were able to resolve it.
-
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…
-
BIP report fails With Error 'XMLPGEN-03111 : user requested cancel operation'
Hello. My Publisher reports fails With Error 'XMLPGEN-03111 : user requested cancel operation' when it runs more than 600 seconds. I increased timout in datamodel but it didn't help. I found the same question on oracle support https://support.oracle.com/knowledge/Oracle%20E-Business%20Suite/2448001_1.html but I can't read…
