-
How we can generate/trigger automatic mail when one of the dataset jobs failed in OAC
I am looking for an option to get automatic mail if any of my scheduled dataset jobs got failed in daily run. I know OAC provides built-in notification settings for dataflows, but is there any option to do the automatic notification settings for scheduled datasets.
-
Trouble with transaction amount increase formula
Hello, I am relatively new to creating formulas on OAC and have been struggling to create a formula that will tell me when an individual gets approved for a transaction then eithers get declined or approved for a higher amount afterwards. I would want the time frame for when these transactions occur to be within 2 days.…
-
Questions on OAS Roadmap, AI Assistant, and Auto Insights Refresh
Hi Team, I recently joined Oracle and I’ve been exploring the details around OAS. Whenever I check the roadmap through the following link - https://community.oracle.com/products/oracleanalytics/kb/articles/32-product-roadmaps - I can only see the upcoming and future items planned for OAC. Because of that, it’s difficult to…
-
I Want to make one Food recognition model from scratch.
Can anyone suggest me the best system design for it? Please discuss it
-
How to properly format a scheduled workbook email as a PDF?
I am having trouble with the output size/scaling/orientation of emailed pdfs via the scheduler in Oracle Analytics cloud. There seem to be limited options when selecting the output size and neither seem to work in the way I anticipate. When selecting "US Letter" the canvas visualization appears small and in the top left…
-
How to setup OAuth credential for OAC and OCI DI to avoid updating the Databricks token every 90days
How to set up OAuth credentials for OAC and OCI Data Integration (OCI DI) to avoid updating the Databricks token every 90 days Currently, we are connecting to Databricks from the RPD using a personal access token, which expires every 90 days. In OAC Data Visualization (DV) connections, the Databricks connection type…
-
How to get the ascending dates of activities in a report/analysis (not using Sort Ascending)?
Hi Everyone, How can I get a list of the ascending dates for the activities available for one account using OTBI expression? Is it possible to get all the dates for the account in one row only? Here is what I have so far: CASE WHEN YEAR ("Activity". "Actual Start Date") = YEAR (CURRENT_DATE) THEN (CASE WHEN "Activity…
-
OAC | Filtration - Error
Greetings Community, I'm facing an issue with an error only when I apply a Filter. So I am able to visualize and put Data side by side from 2 Sources: It's only when I select a Location, let's say for example "Cambridge", it throws in following error: Just a FYI, this is how the joining is done: Please let me know how this…
-
Benefits of Oracle Data Visualization vs Classic BI
Hi Team, Do we have any documentation or reference material that highlights why we should use Oracle Data Visualization (DV) instead of the Classic BI reporting tool? We’d like to showcase the key advantages and business benefits to the customer — especially how DV can enhance Enterprise Analytics through better…
-
OAS 2025:"Log Could Not Be Retrieved" Error When Clicking View Log in Administration>Manage Sessions
In OAS 2025, attempting to view the detailed session log in the UI Console (Sessions and Query Logs) by clicking the "View Log" link for a specific session results in the following errors: Error Messages: Log Could Not Be Retrieved Error during query processing (SQLExecDirectW) Error Details: Error Codes:…
-
OAS 7.0: Is there a way to un-check the default setting for Agent > Destinations : User Destination
Hi, we are using OAS 7.0, OBIA794, EBS1221, Oracle19c db on Linux. We are trying to prevent our large user community from creating 'Home Page' alerts for their agents (in addition to attached report delivery in their email). The "Homepage" destination is a default setting within the user interface when creating a new…
-
OBIEE 12c - Agent not delivering content to Dashboard
Hi, I've a Agent running (on OBIEE 12.2.1.2.0) which delivers content to the BI Consumer Role listed as a direct receipient. I have 2 users, user 1 which is a Administrator user (is a member of the BI Consumer role also) and User 2 which is restricted to only viewing reports i.e. a consumer user. The Agent delivers the…
-
Where can i get Fusion Data intelligence?
Where can i get Fusion Data intelligence?
-
Row-Level Filter Setup in OAC Semantic Model
Hi , I’ve developed a report based on a Semantic Model subject area in OAC. We have 10 plants, and I’d like to restrict the data visibility based on the logged-in user. I have a separate table that manages user and plant details. In my dataset, I used this table to filter data, and it’s working as expected. I also used the…
-
Forecast (Workbook and Data flow)
I have sales data with product, date, and quantity sold. I would like to generate a time series forecast for each product and export the results into a CSV file. When I create a forecast in a workbook, I can only generate a line chart, but I’m not able to convert the forecast into a table or export it. When I try using a…
-
Dataflows (How to use RANK function in descending order?)
Is there a way to use the RANK function in descending order in Oracle Analytics? Currently, it ranks the latest date as Rank 1 (and older dates get higher rank numbers). However, I’d like to reverse this order so that the latest date gets the lowest rank instead. I know this can be achieved through aggregation, but I…
-
URL export of "current state" of a DV workbook seems to randomly revert to original state
Checking to see if anyone else has experienced this behavior before opening a SR. Users of a DV workbook will set their desired dashboard prompt values, then click Export > Current State > Copy Link to then send this "pre-filtered" workbook link to other users. However, these links seem to randomly stop populating the…
-
Semantic Modeler and RPD coexistence in OAS
Hello everyone, I would like to ask a few questions about the use of Semantic Modeler in Oracle Analytics Server (OAS): When working in the Semantic Modeler, does the data model use the same file extension (.rpd) as the data model created in the BI (Model) Administration Tool? We already have a data model created in the BI…
-
How To Get Subtotal of Invoice | NetSuite - NSAW - OAC
Greetings Community, I was wondering what's the most efficient manner to show Subtotal from a NetSuite Invoice in NSAW - OAC? For instance, in this case: $705 will be shown by using Tax Line = "F" & "To Be Fulfilled = "T", like this: But I don't believe "To Be Fulfilled" is the most ideal, for example this other Invoice:…
-
Configuring Time Out Behavior when using DV in OAS 2025
Hello, I've noticed with our recent upgrade that OAS is returning to the Oracle Login Screen (Non-SSO) after experiencing a timeout. This does not happen when using OBIEE classic, as it it configured to use specific SSO URL for sign out. I don't recall if the previous version did this or not, but I don't ever remember…
-
Does OAC DV Text box support HTML or CSS code
I have a definition page for my OAC workbook. I need to make it visually appealing but Text box or any functionality cannot support HTML or CSS scripts. is there any way to make it possible. I want to make it like this but the current stage is in just pure text.
-
Audit
I'm opening this thread because, for audit purposes, we're being asked to extract some information from two applications. Much of the requested information appears to be covered. However, the audit appears to be different due to the underlying architecture (PBCS). Therefore, some fields that can be activated to replicate…
-
OAS 2025 July Patch - SSO Timeout Not Redirecting to Custom Logoff URL
Hi Everyone, Good morning. I'm running into an issue with OAS 2025 (July patch) and need to confirm the expected behavior for SSO timeout scenarios. Current Setup: OAS 2025 with July patch applied SSO enabled: OAS > OHS > OID > OAM Custom Logoff URL configured When users manually click Logout, they're correctly redirected…
-
Create a unified date for
So I'm building a dashboard that has three dataflow/sets and each datasets has a corresponding dates: SLT Date,CaseDate and DateCreated. What I want to achieve is create a single monthly date so that I can put it in a table and put each different KPIs for each dataset. Basically one unified date for each KPI metrics on my…
-
Does any one know why a date field keep disappearing from RPD?
Hello, Does any one know why a date field keep disappearing from online RPD? we have added "Promised Date" to the RPD below in green box, after the RPD deployed, it is ok for a few days, but after a few day later, when we check the online RPD, the field disappeared, but then check the offline RPD, it is still there. so we…
-
OAC Workbook Multi-language for headings and titles
Hi Team, We have requirement to translate user defined headings of tables, titles of DV workbook created from dataset(No rpd modeling) based on parameter passed to it. This parameter is passed from URL as this workbook is accessed from VBCS application. from VBCS application language(I-Italian, US-English,F-French) is…
-
Request for Learning Materials on Oracle Analytics Cloud (OAC)
Hi Community, Our team is starting to work with Oracle Analytics Cloud (OAC) and we would like to know if there are official learning resources available such as: Overview and key features Best practices for setup and usage Guides for building dashboards and reports Security and access management Could you please share…
-
Embedding OAS Dashboard in an iFrame on another subdomain
My requirement is to embed OAS dashboard in an iFrame on a web page hosted on a different subdomain. OAS version - 2024. Currently the dashboard is not loading and giving error: -Refused to display 'https://oas.xyz.com/' in a frame because it set 'X-Frame-Options' to 'deny'. Does OAS have any security setting where I can…
-
Refused to frame/Connect because an ancestor violates the Content Security Policy directive
Hi I am trying to display OAS in an iframe within our main application but OAS is not allowing its content to be displayed not even the login page. This issue persists across other applications and even on a simple HTML page. Despite adding safe domains in OAS updating the instancecinfig.xml file multiple times and…
-
Finding Duplicate values
Hi all… Apologies in advance if this question is entered into the wrong forum. If so, please let me know where it would be best to ask this question. I am attempting to write an expression filter. Essentially, what I would like to find are duplicate dollar amounts found in a variety of transactions. For example; A customer…
