-
Issue in attribute showing in workbook
My workbook need Packaged_item_gid with all other shipment related info, but it is not in shipment analysis folder, Packaged_item_gid is in Order Base Line Dimensions , My requirement is that In workbook against shipment info , pacakged_item must be shown , because filter is apply on items, now tell how I do this
-
HDOWNER database is oracle analytics and GLOGOWNER database, how data flow between them
In otm we have Database GLOGOWNER and have Data Dict, from where we know what is in tables, and analytics have HDOWNER database and data in otm has flows to analytics but dont know in between mapping means shipment related tables in GLOGOWNER we know how this data is flows to which folders of subject area in HDOWNER dont…
-
OAC scheduled maintenance does not line up with the Bi-monthly updates
Our Scheduled Maintenance notification dates for our region/instance names, does not line up with the Bi-monthly updates listed on the web page. Can someone explain what the actual process is? thank you. I see updates on the web page for Jul 25, Sep 25, Nov 25 which suggests all updates are done bi-monthly yet our…
-
OAS Data visualization Default values in filter dashboard for date fields
Hi! We have defined a date filter dashboard with parameters with from current_date-7 to current_Date: I expect this values will be displayed for all users but there is only visible for my user. The other users by default see the full range. This is a bug? We need to be able to define the same default values for all users.…
-
Pivot in Data Flow
Hi All, I am working on a Data Flow in Oracle Analytics Cloud and would like to know if there is a Pivot transformation available within Data Flow. I need to pivot rows into columns as part of my data preparation, but I am not seeing any direct option for Pivot in the Data Flow UI. Thanks, Jay
-
Connecting OAS RPD to Snowflake
We are using OAS 2025 and want to start testing a connection to SnowFlake. How does that connection need to be setup in the Physical Layer of the RPD? Thanks William
-
OAC Visualization- Date Filter - By Default Current(Today's) date selection
Hello …..We have some visualizations having date filters .Our requirement is to make sure that by default current(Today's) date is selected as shown in the image below .Pls suggest how to implement this .Thank you.
-
COUNT DISTINCT Shows Decimals in Reports - Logical Column Data Type Changed from INT to VARCHAR
After migrating from OBIEE 11g to OAS, We are experiencing an issue where numeric fields that display COUNT DISTINCT aggregations are showing decimal places in OAS reports, whereas they displayed as integers (no decimals) in OBIEE. Key Findings: Both RPDs have identical aggregation rules: COUNT DISTINCT on a VARCHAR field…
-
Formula to to always aggregate by a dimension and allow other grouping in visual
We have a formula that should always be aggregated by the Ledger Currency in FDI but it also may need to be visualized by other dimensions: Fiscal Year, or Business Unit, Supplier, etc. Currently, we set the values tab on the properties tab for the visual Aggregation Method: Sum By: Ledger Currency, Fiscal Year, etc.…
-
OAS | MCP Enquiry
We would like to enquiry that OAS can integration with Oracle sqlcl MCP server. Or we can OAM have API for create reports?
-
Chinese Characters Show Garbled Text in OAC
We create a connection from Fusion, and it has been working normally since May with all Chinese characters displaying correctly in OAC. However, today we suddenly found that all Chinese characters have turned into garbled text. What can I do for this situation?
-
Row Level Filtering/Security at the Datasource level
We are on OAS (2025 version), in case that matters. We have a requirement that we need to create a project dashboard, to be distributed to our various project managers, each of whom have their own login and project assignments. We want to show each PM only the data applicable to their specific project. We have a DB table…
-
Parameterizing DV Datasets in Oracle Analytics Cloud/Server
Hi Community, Is there a way to parameterize DV datasets in Oracle Analytics Cloud/Server, either at the logical query level or the physical SQL level, so that data can be dynamically restricted/controlled? Thanks!
-
Data Actions
I am trouble trying to figure out how to connect two data action to one a specific row also how to distinguishing between which data action to use to pull out the information that I need. I know in analysis report its called action links, so how can that be created in dv? I have read that I need to use One Click Action in…
-
RPD Upload Failed - OAS 2024
Recently installed OAS 2024 and imported bar file from OBIEE 12.2.1.3. Import and restore was successful and now i am trying to download and upload rpd to OAS. Downloaded using the below command: it worked as expected datamodel downloadrpd -O D:\oracle\product\RPD\DEV_2_20240418.rpd -W xxxxxxxx -U weblogic -P xxxxxxxxx -SI…
-
How to display the date in MM/DD/YYYY format in oracle apex.
I'm creating an oracle apex page to load the csv file and to view the uploaded data. The csv file contains three the date columns namely access reference date, access start date and access end date, and the requirement is to display as given in the file in the MM/DD/YYYY format. Problem: I have given the format mask of…
-
Do we have any restriction on the OAC instance name length?
REST API to create OAC instances are failing with below error. Seems like this is due to instance name size restriction to 25 characters, Was this introduced recently? This was working before with instance name greater than 25 characters as well. I did not find any documentation on this size limit. Error: Caused by:…
-
OAC-Dashboard Filter - Values removal on selection of other filter values Issue
Hii OAC Community, We have a Simple Dashboard Filters named Country and City applied on multiple visualizations in the canvas as shown below. Initially all the values of Country and City are visible in the dropdown. We observe that when the user selects a City ,ex: New York ,this automatically updates the Country Filter…
-
Gauge in OAC Analytics like in Classic whit 3 Threshold Values and 3 Color Areas?
Is this possible in OAC Analytics?
-
Is there documentation, YouTube Videos, etc. to help learn more about OAC Capabilities?
Been working with OAC for a while now but never had an opportunity to do ML type projects. Where could I go to get started?
-
Forcing UserScripts.js javascript file to reload/refresh on OAS Server
Hello, I have set some javascript objects in the UserScripts.js file to use to build URL's for Action Links (using the "Invoke Browser Script" method) in classic Analytics reports. I updated the script to point to a new URL, but it's still pointing to the old URL when I try to use the Action Link. I've restarted the whole…
-
Issue Summary:OAS AdminServer Fails to Start — “Boot Identity Not Valid” and Schema Credential Sync
Environment Product: Oracle Analytics Server (OAS) WebLogic Version: 12.2.1.4.0 OS: Linux Domain Home: /obie/oas/user_projects/domains/bi Java Home: /obie/Software/jdk1.8.0_441 When starting the OAS domain using: ./start.sh the following error occurred during AdminServer startup: Admin Server Start Exception: Error…
-
OAS 2025: Unable to create a dataset using local subject area
Hello! In OAS 2025 server with SSL enabled, I'm unable to create a DV dataset using a local subject area. Getting "Failed to retrieve schemas" We implemented the solution documented in Doc ID 3027293.1 It helped with datamodel.sh uploadrpd. However the "Failed to retrieve schemas" issue persists. Any ideas? Thanks in…
-
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…
