-
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…
-
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.
-
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…
-
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…
-
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
-
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…
-
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
-
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
-
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…
-
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
-
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,…
-
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…
-
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…
-
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…
-
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…
-
How to edit Color of a Series in Chart
Hi, Hoping to gain some wisdom from you all. I want to graph Year over Year sales in Netsuite using a Workbook. My initial idea was to have bars for current year and area for last year sales, however, I wasn't able to do that. The best I could do is a Series for Last year and a Series for Current year. I thought that by…
-
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?
-
Unable to find PATCH method in Salesperson Reference Accounts REST Endpoints
Hi , I need to update the Salesperson reference account segments, but I’m unable to find the PATCH method in the Oracle documentation. REST API for Oracle Fusion Cloud Financials - Salesperson Reference Accounts REST Endpoints
-
0Auth2 E-Mail with Oracle Analytics Server 8.2?
Hi Friends! I've managed to get my head around the patch vs upgrade issue. I feel dumb. That said - I have a new issue I'm troubleshooting. I'm trying to get e-mail authentication working with our office365 server. smtp.office365.com:587 using STARTTLS. I've configured & tested the Tenant, Secret & Client ID's using…
-
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 set log level in OAS for semantic modeler?
Hi, I am trying to set the global/session log level within the Semantic Model for my OAS instance. I attempted to use the same method as the Admin Tool Gather and Analyze Query Logs but it doesn't seem to take effect. I found two articles from last year regarding this limitation, but I'm not certain if Oracle has made any…
-
Using LOCATE() with Wildcards
Is it possible to use LOCATE(), or a similar function, with wildcards? For example, if i'm searching in a string for '%N.___.3__%'. Is it possible to use an existing function to find and extract the value using SUBSTRING()?
-
Oracle Analytics 6.4 >> 7.6 >> 8.2 SPB Question
Hello, Long time user - many time poster. Doing phase precheck for 7.6 & 8.2 SPB from OAS 6.4 // 35608828;OAS STACK PATCH BUNDLE 6.4.0.0.230715 (Patch 35607281) [03/20/2026 10:01:28] - [ERROR] - [preReqCheck] : [239]- OBI component e:\Oracle\Middleware\Oracle_Home\inventory\Components\oracle.bi.publisher\12.2.7.6.1 is not…
-
Elasticsearch or Opensearch
Hi, Can I use (connect as datasource or dataflow) Elasticsearch or Opensearch in OAC? Thanks
-
P2T BICC
Hello! I’m currently involved in a project focused on data extraction via BICC from Oracle Fusion ERP. We have a P2T (Production to Test) process planned, where the Production environment will be copied into the Development environment. At the moment, we have extraction jobs configured in the Development environment, but…
-
Agent AI Oracle Analytics
Hello Team, I am trying to create an agent AI on oac using a dataset uploaded in the dv section. I created successfully an agent, but when I try to ask a question, the agent doesn't work. I can't see the dataset fields on the following section: How can I solve this problem? Regards
-
OAC AI Agents - Forecasting and other predictive analytics capabilities
Hi team, I have a quick question regarding the AI Agent created and embedded in Oracle Analytics Cloud (OAC). Does it provide forecasting and/or other predictive analytics capabilities? If yes, could you please share the applicable documentation (link) and guidance on how to work and use those features? Thank you!
-
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.