-
Plugin org chart v2 doesn't print as expected
Hi all, I am currently facing an issue with the org chart v2 plug-in for OAC. When exporting and printing the orgchart with expanded nodes the result is still with the collapsed node on hierarchy level 1. The expanded nodes are not shown in the export. See attached the view when clicking on "export" vs the view on the…
-
duplicates using a transaction date
Hi all; so I am having a somewhat similar issue to my last question. Let me give you the objective; I would like to create an attribute column that highlights when an individual (ID #) creates transactions in multiple stores in a single day. In my data, I am given the ID #, two transaction date columns, a store # column.…
-
Oracle Analytics Server on-prem Mobile Identity questions/requirements
Hello, Please excuse if this has been addressed previously but I have not had much success searching for my questions detailed below. We have an on-prem OAS 2024 (7.6) system that has been operational for quite some time that was migrated previously from OBIEE 10g, 11g, 12c, & OAS 6.4 over the past 12 years using Microsoft…
-
Oracle Analytics Cloud - OAPublisher Parameter Issue on Snowflake Data Source
We have a data model off of a Snowflake data source that is working without issue except in one particular case: selecting all parameter values. The Data Model uses our standard code method - (FIELD IN (:PARAMETER_NAME) OR 'All' IN (:PARAMETER_NAME)) However when we run the report and select All, nothing returns. If we…
-
Can an LLM use Oracle Application Server (OAS) as a data provider or catalog via Model Context Proto
We're exploring an architecture where a large language model (LLM) interacts with Oracle Application Server (OAS) through Model Context Protocol (MCP) to retrieve structured data and metadata. In our specific use case: We want to leverage OAS's existing security model, including row-level security, so that user queries are…
-
Exam issue
Hi guys, I just attempted and passed the exam, but when I clicked the learning path, it shows - no show? And Register again for the final exam again?? I got the marks via email as well 🤔
-
Run a Natural Language Query in Oracle Analytics Server 2025
Hello All, Can I actually run a Natural Language Query in Oracle Analytics Server (OAS 2025)? It seems that there are a few steps in order to enable NLQ (unless im wrong). First i created a new Application Role and assigned the permission 'Use Assistant in Workbooks' After that i cannot seem to find a section to write an…
-
Query on Slope-Based Sales Trend Analysis in OAC
Hi Team, We have a requirement to identify customers whose sales have declined over a specific period in the last one year. Essentially, we need to compare the last 12 months of sales data and determine the trend — similar to how the SLOPE function works in Excel. Could you please confirm if Oracle Analytics Cloud provides…
-
Catalog Manager Query - OAC Report List - Login through Security Portal
We need a full list of Catalog contents from our OAC environment. All the documentation I've found states this needs to be done through the Catalog Manager CLI. I believe I have the query correct, however there's a hiccup with the credentials. Our OAC login is via our company's security portal, not direct login. Therefore,…
-
Adding sub-totals by hierachy levels in a pivot table with Oracle Analytics Cloud
I'm creating a fairly simple tabular analysis in Oracle Analytics Cloud. My Semantic Model only has one dimension table (for suppliers) and one fact table (for spend to those suppliers). The Suppliers dimension has a logical hierarchy built into it: Category, which contains Supplier Type, which has Suppliers. Having this…
-
How to create hierarchy columns in Oracle Analytics Server (OAS)
From this link https://youtu.be/PBxADXChCqw I found out that it has hierarchy columns of date, but when I tried to upload dataset (or create dataset from Database connection), it does not show as the video described (not in hierarchy form) Not hierarchy form (what I have) Hierarchy form (what I want) Questions How to…
-
Unable to Synchronize Application Roles with RPD in Cloud Mode
Hello, I am currently using the Oracle Analytics Cloud (OAC) environment and I am unable to synchronize the security rules (Application Roles) with the RPD in Cloud mode. In the legacy environment (OBIEE 12c), I used to open the RPD in Online mode and perform this operation through the Manage → Identity menu. However, in…
-
Query on Slope-Based Sales Trend Analysis in OAC
Hi Team, We have a requirement to identify customers whose sales have declined over a specific period in the last one year. Essentially, we need to compare the last 12 months of sales data and determine the trend — similar to how the SLOPE function works in Excel. Could you please confirm if Oracle Analytics Cloud provides…
-
i got a problem with uploading SVG file using PICTOSTACK
i uploaded an image(SVG) but pictostack visualization is not working. i already read an README.txt and tried everything… attached file is the SVG file that i uploaded for pictostack 🥲
-
OAC Custom Application Role Issue
Hii OAC Team, We have a requirement to grant user role permission equivalent to BI Consumer + Create and Edit Existing Workbooks +Ability to import existing datasets after creating workbook .We created a custom Application role and added the user under users section of this custom role and defined Permissions, Application…
-
Is it to possible to trigger an auto insight from a image as an action link?
Hello: Is it possible to embed an action link or an URL to trigger the auto insight on clicking an image rather than the auto insight bulb icon? Please let me know if its possible to do or if there are any suggestions. Thanks
-
OAS Kernel Parameters
Does anyone have the O/S Linux Kernel Parameters to be set for OAS ?
-
OAC - Auto selection of Current Date in List Filter
Hii OAC Community. As shown below ,In some of our visualizations ,We have List Filter having Date values of Data type:Date and Format :dd/MM/yyyy .We want to make sure that the selection of Current Date is done automatically .For this we tried with Parameters ,but we couldn't found the current date value as shown below.Pls…
-
Error 500--Internal Server Error From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.5.1 500
help please
-
OAC Canvas Embedding - Data Loss Issue on Page refresh.
Hii OCA Team, We have created a Workbook Canvas which we are embedding in our Website .Our End Users complained that if they are selecting a filter value from the visualization and then refreshes/Reloads the website Page .Then the selected Filter value is Lost .Is there any way to preserve the selected filter values in…
-
Is there a way to export the metadata for a dataset?
Been asked if the metadata for a data set can be export from DV. Using the screen shot below they would like to export what would be the table below.
-
OAS 7.6 SSL configuration issue
Hello All, We did fresh installation and configuration for OAS 7.6 everything worked perfect. tried to implement SSL configurations and updated nodemanager.properties and console (Adminserver & managed server -Keytools & SSL tabs) used below document for reference. OBIEE 12c/OAS: How To Configure SSL Including Examples…
-
Conditional Visibility of Filters based on selected Parameter Value
Hii OAC Community, As shown below we have a Dashboard Filter bar having : 1) Parameter named Time Frames (Details in screenshot below ) 2)Column named Creation Date being used as a Filter with dataType: DateTime and format:dd/MM/yyyy. 3)Derived Dates Columns from above - Creation Date (Year) and Creation Date (Month). We…
-
Data Flow Failure – Missing libcrypto.so.10 dependency (OAS 2025)
Hello, After migrating from OBIEE to Oracle Analytics Server (OAS) 2025, we encountered a failure when running any Data Flow. The error message is: [nQSError: 36001] Unable to load the dll /opt/weblogic/middleware/bi/bifoundation/server/bin/libParquetWrapper64.solibcrypto.so.10: cannot open shared object file: No such file…
-
I have a custom report always encounters an error after running for 5 hours
Summary: The Customization Report always encounters an error after running for 5 hours if I using the parameter plan name. Content (Please ensure you mask any confidential information): I have a customization report, which is the report fails to generate data whenever I provide only the plan name as input in the parameter…
-
OAC Instance creation via terraform ( With Identity domain)
Hello All, We are using Identity Domain in our tenancy and trying to create OAC instance via terraform, but we couldn't create OAC as terraform expecting us to pass idcs_access_token as part of the parameter. its a mandatory parameter. Reference:-…
-
how to get passed filter from URL (go URL) so that i can use it as variable in the OAS analytics.
I am using OAS 7.6 and trying to converted passed filter through URL as conditional format item. I am using this Passing filter(s) url . ( i got it to work from this link listed below). https://docs.oracle.com/cd/E12096_01/books/AnyWebAdm/AnyWebAdm_APIWebIntegrate6.html for example :…
-
About runcat command and dashboard section object
Hi, I am trying to use runcat command to monitor and control user permissions of catalog objects such as dashboards and analysis . But we've come up with a problem that we are unable to print out objects under dashboards such as 'section' object . I am adding some images to about the object we need help with. We are using…
-
Questions about Scheduled Cache Purging in OAS
Hello, At some point, we set up an agent/analysis in OBIEE 11/12 that would run each day and clear the case by running the "call SAPurgeAllCache()" command through this process. The process is well documented here: Clear OAC cache automatically. One of the requirements that customers… | by Eloi Lopes | Medium We have since…
-
OTM Transactional Data and BI tools
Hello everyone, I'd like to know if it is possible to access the OTM (Oracle Transportation Management) transactional data from external BI Tools? Or is there a way to access the OAC Data Model from external BI tools connector? The objectif is to have only one centralized BI system, which is in the client side , which…
