-
When will Excel export be available for the OAC to MS Teams integration? {Content-sharing-platform}
Description: I have set up the "Content-sharing-platform" integration between OAC and MS Teams. Currently, we can share visuals to Teams channels as PDF, PPT, and Image files. Is there a roadmap to introduce Excel (.xlsx) as an export option? This is critical for users who need to perform data manipulation on the shared…
-
Moved: How to connect BI Publisher using REST services
This discussion has been moved.
-
OAC generates invalid ROWNUM clause against Snowflake when using RPD subject area
When running an analysis built on an RPD-based Data Model that connects to Snowflake, OAC incorrectly injects an Oracle-specific WHERE rownum <= 500001 clause into the generated SQL.Snowflake does not support ROWNUM → query fails immediately with: SQL compilation error: error line X at position Y invalid identifier…
-
I am getting error - "Not available due to errors." in the AI Assistant for a custom datasets
Hi, I am getting error - "Not available due to errors." in the AI Assistant for a custom datasets. I have enabled the indexes on the dataset. How do I resolve this error?
-
OBIEE Dashboard Gauge not displaying decimals for custom formulas. Any work-around?
I have made a custom formula that calculate SPI(t) (an Earned Schedule metric) values. I selected the Dial Gauge to display it in OBIEE. But the dial gauge only displays in whole numbers. But the same gauge is able to display decimals when it is displaying values of default SPI. I Have tried adjusting the settings without…
-
OBIEE + Snowflake Database - Query error
Hello. I'm connecting OBIEE 12c (Product Version 12.2.1.3.0 (Build BIPS-20170820114118 64-bit) to a Snowflake database, using ODBC connection (3.5 ODBC). The connection information was entered in the ODBC file (Server, Database, Role, Warehouse and Username). I created a connection pool and pointed to this new DSN I…
-
OAC "No active warehouse selected in the current session" error with Snowflake RPD Data Model
Hi everyone, I'm repeatedly hitting the following Snowflake error in Oracle Analytics Cloud (OAC/OAS) when working with an RPD-based Data Model connected to Snowflake: "No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command." The connection tests successfully and I…
-
How to update attributes of a datastore
I have created a datastore, and use reverse engineer to get the attributes, but I want to update the type for a column, after update, I can't save the changes, it shows error: I tried to update the name of datastore to xxxx_02, click save, it show error indicate a column name: "stock" is already used. How can I update the…
-
Oracle Analytics Server 2024 - Deliver Content Link in Email privilege
Hi , In Oracle Analytics Server 2024 - Deliver Content Link in Email privilege not available under Administration→Manage Privileges→ Delivers section Please let me know how can we create an Agent to email output delivered as link instead of attachment in OAS 2024. Thanks Siddharth
-
Has anyone implemented Earned Schedule metrics in OBIEE dashboard?
I want to know if anyone has implemented Earned Schedule, a concept where Earned Value is given in the units of Days as opposed to units of Cost, (https://www.earnedschedule.com/)? if so i would like to know the formulas they have used in OBIEE
-
Embedding only specific visual on the canvas - Javascript framework
I am embedding OAS content on a web page using Javascript framework. Is it possible to get the path to a specific visualization on the page (and not the whole page). OAS version - 2025 Thanks
-
OAS SAML SSO re-establish session
We have SAML SSO solution to authenticate users and display OAS dashboard on an ADF page, without logging in to OAS. When we logout from dashboard or have the webpage timeout (< 1 hour), we are able to re-establish SAML SSO and display dashboard again. But if logout/page timeout is after 1 hour, then SAML login is not…
-
OAS 2025 – Excel export adding extra blank rows for columns with HTML
Hi all, We’re migrating from OBIEE 12.2.1.4 to OAS 2025 and noticed a difference in how classic reports export to Excel. For one of our classic report columns, we’re using the following Column Data Format: This is used to wrap long text and preserve line breaks. Behavior difference: In OAS 2025, when we export this report…
-
Catalog Manager error: path not found
Hi there, I'm exporting catalog objects using Catalog Manager CLI. While I can pull catalog objects per object type, I get lot of error lines that say "path not found" and the specific path. I checked a few paths that caused the error, but none of them actually exists. Why this error keeps happening? and how can I resolve…
-
Has Anyone else experienced issues with passing parameter values to an Analytics URL?
Hello OAC Community! This is my first post to this forum (very exciting)! I am reaching out because I am experiencing an issue with one of my workbooks whenever I try to pass parameter values into an analytics URL. I have done this in the past with no issue, but I can't seem to pinpoint why it's not working correctly. For…
-
OAC RDP View output error for ADW ORA-12506, TNS:listener rejected connection based on service ACL f
Error while connecting form OAC to ADW while view the RDP [JDSError: 22] Exception from datasource. errorcode=116 [JDSError: 116] JDBC Connection Error: Listener refused the connection with the following error:ORA-12506, TNS:listener rejected connection based on service ACL filtering- Cause: Listener refused the connection…
-
How to change a Legend label?
-
Facing the error msg.. while connecting OAS Dashboard Pages
Error Codes: WH4KCFW6:OPR4ONWY:U9IM8TAC:U9IM8TAC Location: saw.connection.openConnection, saw.connectionPoolAsync.createConnectionJob, saw.threadpool.dbconnectionpool, saw.threads Error during query processing (SQLDriverConnectW). State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has…
-
Issues with dataflows
Hi all! I am having issues with dataflows in OAC. After the latest update, the dataflows run but I cannot edit them. When I open them, I get the following error message: Status: HY000. Code: 22123. [nQSError: 22123] The (name) member is missing in the dataflow JSON. (HY000) (translated) Please, your assistance.
-
Authentication OAS users from(1- Oracle DB 2- internal LDAP)
I want to configure the database auth for my OAS users. I create a schema in oracle 19c db, create a datasource in OAS for my db, make a customDBMSauth provider in OAS and set it SUFFICIENT and order in top, What is missing . OR is there a step by step guide.
-
Oracle Analytics Mobile (Android) – Application Performance is Very Slow
Dear All, We are currently facing an issue with Oracle Analytics Mobile on Android. None of the dashboards or reports are loading successfully , the application keeps showing the loading screen indefinitely without rendering the content. Has anyone else encountered this problem, and are there recommended fixes or…
-
OBIEE 12C. Users have lost access rights to their personal folders
Hi there We have an OBIEE 12.2.1.4 cluster with two instances, and the bidata folder is located on shared storage. Authentication is configured via the repository (RPD) using an initialization block with an Oracle DB query similar to:select username, name, role from app_users where username=:USER and password=:PASSWORD…
-
Podcast Feature - Mobile APP - OAC
Hello! Is the Podcast feature in OAC mobile app available in any other language than English? Thank you!
-
Image resize in Excel output - RTF template
Summary Image resize in Excel output - RTF template Content Hi All, I am using RTF template to produce report in Excel and PDF. I have a requirement to embed image in the excel sheet. Using following URL for the image and it works fine in both PDF output and excel output url:{concat('${OA_MEDIA}','/',LOGO_FILE)} But unlike…
-
I cannot find Oracle Analytics Day by Day Mobile app on App Store or Play Store
I am not able to find Oracle Analytics Day by Day Mobile app on App Store or Play Store. Is this mobile app deprecated? Anyone has any update on this? Thank You.
-
Copy/Paste option not available on MacOS for Oracle Analytics Desktop (OAD)
Hi everyone, I’m using Oracle Analytics Cloud Desktop on macOS, and I’ve noticed that the Copy/Paste option is not available (both right-click and keyboard shortcuts). I’ve tried restarting the app and my Mac, but the issue persists. Is this a known limitation of the OAC Desktop client on Mac? Are there any workarounds to…
-
How to convert selected data from the column in Action Link to Oracle Apex.
I am trying to create action link passing the variable to Oracle Apex variable. I was able to pass the hard coded one but want to make it dynamically. 110:3:::::P21_test:test_value hard-coded test_value (orange) works at the APEX page. but test_vale needs to be Apex ready .. but no idea where to get the example. any syntax…
-
cannot export OAC error Server is busy. Please retry after some time
-
Single Sign on Setup (SSO) in OAS for cookie based.
we are migrating from obiee to oas, we are having issue with sso setup, in obiee we use cookie and initialization block securty model for authenticaton. how do i implement the same in OAS, could you please provide any documentation on this.
-
Error during import of Oracle Analytic-Views Metadata into rpd
I am trying to import metadata for Oracle Analytic Views - which used to be Oracle OLAP in old days. In rpd, I have created a database with Database type = 'Analytic Views'. In the Connection Pool, I am using 'OCI' connection, and Data Source Name=(tns string for our Autonomous database) When I try to import metadata, it…
