-
How to apply EBS value sets security on reports?
Hi, In Oracle Analytics we have created reports getting data from Oracle EBS using connection. Now how we can apply user level access as per security rules assigned in Oracle EBS R12 in these reports as well. So if a user is of company 01 shall only view data of 01 of company segment and other user if of 02 shall be…
-
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…
-
CPU APRIL-2026 PATCH FOR OBIEE 12.2.1.4.0
Will there be any CPU patch OBI SPBAT for OBIEE 12.2.1.4. this cycle? The product is in prem support til end of 2026 but it is completely absent from Oracle Analytics - Critical Patch Update (CPU) Program April 2026 Patch Availability Document (PAD) KA1576 & it is still showing JAN patches on the Advisor: Critical Patch…
-
Is it possible to use Parameters to control the Format applied to dates?
There's an interesting blog/video that shows how to use a combination of Parameters and Calculations to create "Dynamic Filters". Such as having a User be able to select that they wish to view the data by Month or by Week and, functionally, it works. My only frustration with the result is the format of the Date applied to…
-
OAS Admin Tool Connection Issue with Postgresql Database
Hi All, In our company we need to connect Cloudberry database via OAS 8.2 Admin tool. I added the postgresql jar file under \lib directory and restart the servers. After on admin tool, create a new datase and add a new connection pool. However in the connection pool page, I can not select JBDC as database type. As you can…
-
Forecast Does Not Work in DV - Other Timeseries Functions Work
Hi. I encounter this error when I drag Forecast into the Data Visauliser Workbook: State: HY000. Code: 22073. [nQSError: 22073] Internal Error: (Generation of physical plan for dimension query failed with (HY000) State: HY000. Code: 42064. [nQSError: 42064] Incorrect dimension specified for TimeDimSeqNum function.…
-
Semantic Model Migration: Hierarchy (logical dimension) based on two logical tables
This is probably going to raise some eyebrows asking this question, but is there a way to turn off this check when importing a model from an RPD to Semantic Modeler? I'm certain that the answer is NO, but thought I'd ask anyway. I understand why it's there, and why it's needed. However, we have some a couple of rat's nests…
-
How to Enable Indexing on CSV Datasets? Getting Error Everytime
Want to enable AI Assitant feature on workbooks, We have all rights, seen all documentations & related videos on official channel, not missing a single step,, Also try in Inspect>Search>Scope> Manual + Recommendation settings but the changes saved, during Run facing the error. We have tried on small CSVs like 05 rows of…
-
Governance plug-in not downloading Dataflow details
I am using the governance plug-in, and I see no dataflow details downloaded. The SYS_DATAFLOWS is empty. The other 2 excels SYS_DATASOURCES, SYS_WORKBOOKS have data. Is anyone else facing this issue? Please advise.
-
Export OAS data visualization charts to excel
-
Roles associated to groups don't work in OAC
Hello Team, We're experiencing issues accessing the Oracle Analytics Cloud instance using a custom application role, for example, R_1 associated with the GRP_1 group. We performed the following steps: - created a group on Oracle Cloud Infrastructure - created an application role in the OAC console - associated the group…
-
How to expand on year to see months on OAS
Hello everyone, I appreciate your time in answering my question in advance. Quick question: I'd like to visualize my sales based on year, but I'd also like to allow users to have something like an arrow to click on and then show the months, and then click on the months and see the days. I have my time dimension all set on…
-
how to change status of agents Enable/ Disable in oracle Analytics cloud (OAC)
We have 200+ agents we need to change the status of agent from Enable to disable . Scheduler is already Suspended. please help me on this how can we achieve this.
-
Step by Step Row Counts in OAS Data Flow?
Is there any straightforward way for a Non-Admin user (therefore no easy access to backend logs) to see how many rows are being manipulated in any given step of a Data Flow that they are working with? This functionality is fairly easily available in similar competing products, and our users are clamoring for it, but we…
-
Does OAC Gantt visualization have ability to add columns of data in chart?
I'm trying to create a Gantt visualization in OAC ODV that looks like the configuration in the snapshot below. All the columns are in the source data except the Days column, which I created using the timestampdiff function. I found something online that mentioned combining a Gantt and Table visualization but couldn't…
-
print bar code
-
Patch Oracle DB Client
I have OBI installation 12.2.1.4 with the 19c installed. How do I patch the DB client of this Installation? Thanks in advance
-
Not being able to generate a "AGO" function on OAS
Hello everyone, I appreciate your time in answering my question in advance. I am currently using the Oracle BI Administration Tool version 12.2.1.4.0 to upload databases to my Oracle Analytics Server. My question is: I am not able to generate an AGO function on my Analytics Server. The problem is probably on the OBIEE…
-
OAS 2025 DV - Data Labels Inside Bars with Bar Chart Visualizations
I am working with a horizontal bar chart in DV with an amount field for my X-Axis and programs for my Y-Axis. I see that I can create and adjust data labels for the amount with no problem and move the data label inside the bar, but again this is only for the amount / field on the X-Axis. I don't see a feature like this…
-
[OAS 2023] BI Administration Tool issue when import metadata from Oracle OLAP 19c
Hi, when try to import metadata from Oracle OLAP 19c in Oracle BI Administration Tool versions 12.4.8.0.0 or 12.5.4.0.0 I got empty data source view list. I find out in bi_server1-diagnostic.log reported error related to attaching AW: [2026-04-24T22:02:49.758+08:00] [bi_server1] [NOTIFICATION] []…
-
OAC built-in ATP conn.with Resource Principal to ATP-S private endpoint via PAC fails with ORA-25704
Hello, We are testing the built-in Oracle Autonomous Transaction Processing connection in Oracle Analytics Cloud, with Connect Using = Resource Principal, through PAC to an ATP-S private endpoint. This is not a generic IAM or PAC setup question. It is specifically about the OAC built-in ATP connection using Resource…
-
Is it possible to index a column on OBIEE ?
Hello everyone, I appreciate your time in answering my question in advance. I am currently using the Oracle BI Administration Tool version 12.2.1.4.0 to upload databases to my Oracle Analytics Server. My question is: I already know that every key is sent with the table to the OBIEE RPD when importing it, but do the indexes…
-
Issues when trying to apply patch 39023318
Hello, With the April CPU delayed, I'm try resolve a critical vulnerability that turns up in security scans, per CVE-2026-21992. This page and the scans say to apply patch 39023318. However, when I try to apply this patch, I get the following message: Skip patch 39023318 from list of patches to apply: This patch is skipped…
-
Problem with map loading from polygons
Hello Team, if I try to create a map using polygon geometry format, I have some problems: when using a direct connection, the loading time is very short; however, when going through the repository (creating a geometry field) it takes significantly longer (also with restrict filters). It could be a problem caused by…
-
Best Practices for OBI Semantic Modeler with Git Integration in a full lifecycle environment
Hello, We've been looking at possible moving from the traditional RPD to the Semantic Modeler for our data modeling practice. Got everything set up with Git and it looks great. What I'm wondering is… are there any best practices or even approaches that anyone has come up with for working with your semantic model across a…
-
Totals for a given Month and Full total from inception
Hi Team - I have a requirement to display the revenue amount for a given month based on the parameters and year totals can be achieved using todate function. The customer also looking for inception totals next to year totals. Appreciate your inputs. Thanks in advance
-
Updating SSL certificates in Java Keystores
Hello, It is that time of year for us to renew our expiring SSL certificates used in Weblogic for our Oracle Analytics Server environment. We have 2 keystores (identity and trust) plus 2 other keystores where certs are added. Each keystore hosts a full chain of certs: base, root, interm1, and interm2. What approach do…
-
Find OBI patches
I have OBI installation 12.2.1.4 with the 19c installed. I need to patch this installation. Which page gives me the patches for my installation. I'm confused. Can someone help where I can find the patches I need.
-
How to change default INNER JOIN to LEFT JOIN in the Physical layer? (Beginner question)
Hello everyone, I am a very beginner in Oracle Analytics and OBIEE. I am trying to join two tables in the Physical layer (under the "Physical" tab). By default, the join is set as INNER JOIN, and I cannot change it. It seems like the option to change it is locked or not available. I would like to change it to a LEFT JOIN.…
-
How can I use lower function in RPD physical layer?
i have situation that has one of column data has mixed case in one table. so that join would skip that data. other table column's all lower case. I want to capture the data if i can lower the data case, but i can't do it on physical layer or I have to do it from database side. I want to keep original data but for the join…
