-
OAS 2025 - data visualisation limitations (Taleo)
We use Oracle Analytics Server (OAS) exclusively for Taleo Recruiting and have recently upgraded to version 25A. However, the new version seems to have a different look and feel to the standard we see published, and the data visualization features appear to be limited. The view we are presented with are the classic style…
-
migrated from obiee to oas. weblogic user doesn
-
What is the syntax to dynamically pass parameter values from workbook to workbook via a URL link
Workbook A has parameter p_PersonName bound to a filter I need to create a URL link (on a Text Viz) to navigate to Workbook B and pass the selected filter value via p_PersonName &p1n=p_PersonName and &p1v=JohnDoe (hardcoded p1v) works OK However, I want p1v to be dynamic. What is the correct syntax?
-
Does the updateACL method on the OAC REST API support "execute" permissions
According to documentation REST API for Oracle Analytics Cloud - Update a catalog item ACL and REST API for Oracle Analytics Cloud - Get catalog item ACL, The permissions structure should support specifying "execute" permission type, however it does seem to actually work. Nor does the the "execute" permission type get…
-
OAS BIP Joining 'DV data' source you can't do it? is this coming soon?
Hi Apologies, this is raised as a question, but, it might equally be a candidate for a new idea? If a product expert on here can rule it in or out. I suspect this may already have been considered. In BIP OAS we have the option to pull in a data source of 'DV data' into the BIP data model, (hexagonal blue icon from + icon…
-
OBIEE 12c - incorrect grand total for ABS formula
Hello, I used ABS formula → abs(qty) Results for individual records are ok, but Grand Total is incorrect. For example: In RPD I have set → Aggregation SUM. What am I doing wrong? Please help me.
-
How to provide Granular Shared Folder Access in OAC
I'm trying to implement fine-grained role-based access control in Oracle Analytics Cloud (OAC), specifically regarding shared folder permissions. My use case is: I have a shared folder where I'm assigning an application role. This application role will be granted to OCI IAM groups. Within OAC, I want to ensure that members…
-
How to visualize a Route Line?
Is it possible to implement a Route Line visualization in OAC or OAS Workbook that connects the latitude and longitude positions in order with a line using a data set that lists multiple orders, latitudes, and longitudes? If it is possible, please explain in detail.
-
I inherited an older OAS 2023 server, which version to upgrade to?
Good morning, I need to upgrade an OAS 2023 BI server I inherited because support and patching ended this month ( I just applied the latest January sb patch for windows that was available )… Do you recommend I upgrade to 2024 24.7.6.0 and apply the latest patch or go to the new 2025 24.8.2.0 ? Since 2025 was just released…
-
Unable to restrict schema access for specific user in OAC
Use Case: I want to create a connection for a single user schema in ADW. The goal is that when the user creates a dataset, they should only see the tables from their specific schema and not from other schemas. Details: Approach 1: I tried creating a connection by providing the username and password for the specific user…
-
OAS: Unable to login to Analytics Console Post Upgrade to OAS 7.6.
Hi All, I did upgrade from OAS 7.0 to OAS 7.6 on Linux Machines. Used the same Oracle WebLogic Server 12c (12.2.1.4) version for OAS 7.0(2023) & OAS 7.6(2024) I was able to start the services post Upgrade, able to login to Weblogic Console & EM Console. But post upgrade to OAS 7.6, I am unable to login to Analytics…
-
OACS Report based on Cross database tables with Left Outer join Requirement
We have a requirement where two tables which needs from different databases needs to join as left outer join. For ex. Primary Database - DB1 Secondary database - DB2 Primary database Table - TB1 Secondary Database Table - TB2 Our Report SQL should like below. select TB1.*, TB2.* FROM DB1.TAB1 left Outer Join DB2.TB2 WHERE…
-
Is OAC AI Assistant Functionality planned for Professional Edition?
Hi All Is OAC AI Assistant Functionality planned for Professional Edition? Or will it be limited to Enterprise Edition only? Many Thanks Darryn
-
Is global workbook-level filtering possible in OAC to apply filters across all canvases simultaneous
My organization needs to implement global filter functionality across our OAC DV workbooks. Currently, our business users must repeatedly apply the same filters (such as Region and Division) on each individual canvas, creating inefficiency and potential inconsistency in analysis. We require a solution that allows users to…
-
OAS 2023: AI Assistant features
HI, How to enable AI Assistant features for data set in OAS 2023. I have only below options in "Index Dataset for Searching". Regards, Srinivas.
-
Is it possible to create parameter that can select multiple values?
Hi, I just want to know the possibility of creating something like below in Power BI that I can have the capability to select multiple columns with one parameter. Cause currently in FDI, I need to create parameter for every column that can be selected. Here's what currently in FDI, my problem is it would not be good if I…
-
Reg. Delivering Dashboards through Agents
Hi I wanted to deliver a dashboard to desired recipients' email IDs through Agents. the delivery agent is failing although I have configured SMTP in Bi Publisher. please suggest how can I go forward
-
Note boundary in Workbook.
I was wondering if i can make the Note boundary gone~. I couldn't find any option/properties to control it..
-
How to cancel agent executions
Hi! I need to run an agent, but I get the error [nQSError: 67020] The maximum number of concurrent instances of a scheduled job has been exceeded. The maximum limit is 1. I see the same agent that I need to run in the Manage Agent Session view, so I want to cancel it. How can I do this?
-
Problem opening workbook in OAC
Good morning, we're fancing an issue with a user: when the user tries to load a workbook in OAC he doesn't get an error but the page continues to load. Activating the Network monitoring on the browser we get a message as "Refuse to execute the script xxxx because its MIME tyoe ('application/jason') is not executable and…
-
placing the files in a public html folder
Hi, We have Images in Jpeg format. Now we want to use this images in Purchase agreements. how to call these images as URL in Purchase agreements. It was suggested to place the files in public Html folder. Iam not sure where is the HTML folder and how to access this folder to place the images.
-
Does any one know if there is any way we can limit long running BI reports in Weblogic?
Hello, our reports have been running more than 3 hours, but we would like to kill these long run report, does any one know if there is any way we can limit long running BI reports in Weblogic? like weblogic console parameters setting etc? thanks !!
-
Can we disable the export option in OAC
Hi, Is there an option to disable the export option at the visulaizaiton level in OAC (Sep 2024 release)? Regards, Jahnavi
-
Use of image in HTML code
Hello, I have a image which was created on my local machine & uploaded on OBIEE server using "Link/Image". Now i am using "Text Box" & putting text as a HTML code which is using same image as above one. So in this case how can i pass "img src" path in HTML code. Any idea to achieve the same. i tried with path…
-
How we can integrate OAC or FAW report in the Oracle ERP Cloud (SaaS) home page
Please provide the steps to display the report in Oracle ERP Cloud home page once after developing the reports in OAC or in FAW
-
OAS Upgrade OAS 7.6 (2024) Reconfiguring the Domain in silent mode
Hello All, I am trying to upgrade from OAS 7.0 (2023) OAS 7.6 (2024) version on linux machines. There is one particular step Reconfiguring the Domain The Upgrade Documentation has steps only to run Reconfiguration Wizard in graphical mode. Is there any way this can be done in Silent Mode? Anyone tried the Reconfiguration…
-
Timecard manager Approved Date
-
Migrating Obiee 12c rpd (datamodels and subject areas) from oracle to snowflake
We are migrating Obiee 12c rpd (datamodels and subject areas) from oracle to snowflake in windows. If I create a new connection for snowflake, then it will over write the existing physical, BMM & presentation layer. I want both oracle and snowflake to exist pointing to oracle and snowflake respectively for reports and…
-
Oracle Analytics Desktop is stuck, should I create a report or something similar?
I was trying out the app on my M1 pro Mac and I was able to add data and create some workbooks with them. Everything was going fine until the app decided that it would not load my workbooks anymore and that the data that had been used before would not work anymore. I'm trying to figure out if I should create a…
-
what is maximum number of columns text format can accommodate?
Hi All, Can you please help what can be maximum number of columns text format can accomodate. Thanks in Advance
