-
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.
-
Chart Labels mashing with line values
I am building a dashboard using the BIP Online template builder in Fusion. I am using the below line graph and want to have the upper and lower values of the line display. When I enable this, you can see that the upper value of the line (28.62) interferes with the Y-axis value (30). I've tried playing with a variety of…
-
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…
-
OBIEE 12c webservices API safety and security
I am considering using OBIEE as a data connection for AI agents. I think this has some nice benefits, as OBIEE is a nice, already built and maintained abstraction layer. I unfortunately do not have access to newer Oracle technology, which has more of this sort of thing built in. But I want to better understand the security…
-
End of life OAS 7.0 & OAS 7.6
Hi everyone, I working on EOS/EOL of each software that are used in our company, so far I am unable to find when is end of life of OAS 7.0 & OAS 7.6? Could please let me know when or enlighten me where I can get this info from? Thanks & Regards, Rudy
-
OAC DV Constraint While adding Direct Hierarchy Column into Report and Expand Different Levels.
In Classic BI, when we add direct hierarchy column into report and set column heading interaction property to drill levels once we click data expands in new column as a new column. i.e., Region —> Area —> Branch… as columns. Whereas that function doesn't exists in OAC DV, in DV we only can expand hierarchy values as new…
-
OAC March Update
Was there an issue with the March update? I had a notification that my non-prod environment would be updated mid-March (this instance is set to early udpates) then there was a new notification that the update was scheduled for April 1st. The update never happened, but I don't see it rescheduled. Also, my Prod instance…
-
Can we align suppressed values to top in table visualization in OAC DV?
In OAC DV we have a requirement to suppress the repeating attribute values in a table visualization. When we use the property setting for suppress repeat , it is suppressing with center alignment, We wanted to do top alignment.
-
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…
-
OAC Data Actions: Is it possible to link them to Visualisation Titles?
As the Question Subject suggests, we're interested to know if it's possible to link a Data Action to the Title of a Visualisation? Or, maybe more specifically, if it's possible to turn the Title of a Visualisation into a URL that could access another report within the same OAC Environment? For example, assuming there's a…
-
Connection for the repository
Hi, We have done a migration from OBIEE 12.2.1.4 to OAS with a BAR file. The connection pool used in that RPD use Session Variables to connect to the database regarding the "User" connected to "Analytics". So the connection pool in the RPD is using the session variable to connect to the right database with "Data source…
-
Exporting data from REST API OAC to CSV/XML/JSON or similar format
Hi, I'd like to export data from an OAC analysis or workbook via the REST API to CSV, XML,JSON, or another format that's easy to import into a database. If this isn't possible via the OAC REST API, perhaps there's another similar solution.
-
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
-
OAS : Roles and permissions (Console)
Hello, I was using the "Roles and permissions" option in OAC to configure security. Now I'm working with OAS and i don't see the option in the console. Is this behavior normal and so do we have to use the "Enterprise Manager" to manage the application roles ? Regards. Jean-Pierre
-
Chain move - Import Files in R&A
Dear all, we are moving properties from one chain in another chain. Do someone has all the Opera Cloud Import files in R&A? We want to move the data and not enter everything manual BR Raphael
-
What connections can I use in a Data Flow to save data?
I would like to load a table into my database but it doesn't come up as an option in DataFlow. Actually no connections are shown, can anyone help me understand what is happening and where to go to learn how to use this option? Any help woutld be appreciated. Thank you. Screen for "Save Data" options. I click on "Select…
-
How to Track RPD Changes Over Time in OAS/OBIEE?
Hi Community, We are trying to track changes made in the RPD over time — for example: What changes were made yesterday, in the past 30 days, or at any point in history Which objects were added/modified/deleted Details of the changes (logical models, joins, presentation layer, etc.) Ideally who made the changes and when I…
-
Need help - How to show 0 in case null/blank values in row AND how to rename Grand Total column name
I am creating report in DV which were previously created using Oracle Classic BI. When creating the table, there are columns where it is showing blank in cells where there are no data. However, in Classic BI the blank cells are shown as 0. When I checked the column properties in Classic BI, it has added Custom format as…
-
Connection to Databricks from Oracle Analytics Server - Fails to load catalog
Trying to connect to data bricks from OAS using SIMBA Spark ODBC driver. In the DSN setup the connection is successful, but when try to refer it from OBIEE admin tool to import metadata, not able to see any catalog folders. Is there any listed steps to achieve this connectivity ?
-
OAC dashboard performance issue
Hi, We have migrated from OBIEE 12c to OAC. We are seeing a performance issue with one dashboard after migration in OAC. It takes 5 mins to load the report. In OBIEE it returns in seconds. Are there any sepecific settings in OAC to optimize the query/filters? Thanks Padmaja
-
custom layout with shared image background
Hi, we are on Jan 2026 release of OAC DV. Trying to save the custom layout with a custom background of shared image. However, this image is not coming over when trying to select this layout. Any suggestions are welcome to address this.
-
Can a new Oracle Data Visualization 12c 12.2.4.0.0 connect to a onpremise database? or DBCS?(Databas
Summary Can a new Oracle Data Visualization 12c 12.2.4.0.0 connect to a onpremise database? or DBCS?(Database Cloud Service) Content [Urgent] Can a new Oracle Data Visualization 12c 12.2.4.0.0 connect to a on-premise database? or DBCS?(Database Cloud Service)? My customer wants to connect DVCS directly with the existing…
-
Unable to create OAC connection to new ADW but connection from SQLDeveloper works fine
I created a new ADW instance to be the target of an OAC Data Flow. ADW creation was successful, and I can connect to the new ADW using SQLDeveloper from my on-prem machine. When I try to create the ADW connection in OAC using those same connection details/wallet file I get "Failed to save the connection. Invalid connection…
-
Triggers being triggered by Data Flow "Save Data" to Database Table - How many times?
Question about saving data from DV via the Save Data to an existing Database Table with a trigger set on it: Let's say you're writing a data flow dataset that will ultimately write 50 records to a table "TBL_SENT_FILES". That table has an after insert trigger on it to do some sort of task. Will that trigger trigger once,…
-
How can i connect from BI client windows to BI Server on linux
Installed: On Server Linux Red Hat 8.3 LINUX.X64_19c_DB Weblogic : 12.2.1.3.0 OBIEE : 12.2.1.4.0 2. On Client Window Server 2022 bi_client_12.2.1.4.0 Everything installed ok, but on step create ODBC, dns test error. So i cannot login BI Admin Online mode. Pics on attached files included error log. Have you encountered this…
-
Fusion SR Attachments: Missing UCM Content ID (DM_DOCUMENT_ID) for UI-Uploaded Files in BI Publisher
I am working on an Oracle Fusion (Service/CRM) requirement where I need to display Service Request attachments in a BI Publisher report along with their UCM details, specifically the content ID (dm_document_id / dDocName) and version ID (dm_version_number) to construct GET_FILE URLs. I am querying FND_ATTACHED_DOCUMENTS…
-
In OAC DV, Do we have an option to show condition based Grand totals in Pivot table?
Our requirement is to enable dimension attribute value specific grand totals in Pivot table. For example: When we enable grand total on pivot table visualization it shows grand totals for all values of columns. We wanted to enable totals only for specific values. Is there a way to achieve this in DV?
-
How to utilise an unbroken time series in a visualisation?
We have a requirement to produce a Pivot Visualisation that includes an unbroken series of dates, from a filterable period, and the value of whatever measure is relevant. For example, in a period of 16/03/26 - 22/03/26 being able to see the number of activities a Resource has handled, including dates when the value is…
-
How to create subfolders in the semantic layer
Hello, I created a semantic layer in OAS where the presentation layer shows 3 table names with fields inside them. When the user opens a new workbook, he see 3 folders - account + time + credit cards, each folder containing a table with its fields. Is it possible to create subfolders? For example, inside an accounts…
