-
Should i always define a Logical level on my fact table's content? Obiee 12c
Hello my friends, thanks for the time reading and hopefully anwsering my question: All the joins are well connected on my physical side, as well as in my business model and mapping. My fact table has all its connections to the respective dimensions and its foreign keys. That being said, on the business layer, should every…
-
Oracle Data Visualizer desktop
Hi, I have been using this tool for several years, but now the tool will not start up - just hanging in the middle of the startup procedure. I have the latest JANUARY 2026 update installed. Hoping the next release will fix the problem since I have a project inside the tool which I did not export for some time. Thereby…
-
Using AI to Generate OAS Analysis XML from RPD (On-Prem 6.4) – Anyone Doing This Successfully?
Hi everyone, I’ve recently been experimenting with using AI to generate OAS Analysis XML directly (specifically for OAS 6.4 on-premise)—essentially trying to short‑circuit the traditional UI flow by going from: RPD metadata → Natural language → Analysis XML In theory, this feels like a great candidate for automation, but…
-
Oracle DV (7.6 & 8.2) export excel
I only get pptx, pdf, png dsv and dva do we have any feature to export to excel format? Thanks for you help!
-
Any way to make call SAPurgeCacheByTable('Table Name'); for regular user?
We have this one table that matters to the user who create through Oracle Apex. we want to make call SAPurgeCacheBytable for the user how can go and refresh, or create small dashboard to refresh it.. Thank you for your help!
-
Oracle APEX free workspace account locked
Hello, My Oracle APEX free workspace account is locked. Workspace: DDD64PAYROLL Username: FARID I already tried: Password reset Waiting for auto unlock But the account is still locked. Can someone help me unlock the account? Thank you.
-
OBIEE 12.2.1.4 on FMW 12.2.1.3 upgrade to FMW 12.2.1.4 RCU?
Hello, I am upgrading OBIEE 12.2.1.4 on FMW 12.2.1.3 to FMW 12.2.1.4, following KB688074 and PNEWS1548 (the old 3004029.1). KB688074 says to create a new domain. These documents don't state what to do about the RCU schemas. Do I need to run RCU to create new schemas or upgrade them? I am not migrating to OAS because we are…
-
Is there an option to set alignment for value on tiles in OAC DV
On the properties, we only have the option to set the alignment for Labels but not for Values. For scenarios where we only want to have values displayed , how do we set the alignment? Please advise.
-
Trying to join in the workbook a defined subject area and a custom data set.
I have created a new workbook and clicked the + sign to select a custom dataset and then added in a defined subject area. I want to join these two however the message I am receiving states "Matching is not allowed as each one has already been matched to a different subject area". I was able to perform these same steps at a…
-
Dynamic column heading based on a variable in Oracle Analytics Server
Hello everyone, Thank you for taking the time to read my question. I have a column in my analysis that I want to display values based on a variable selected by the user. The user can choose between two options: Revenue Revenue plus everything paid in the next year related to prior sales I was able to modify the column's…
-
OAC Sequence failing due to data set not found
Hi Team, We are facing the below issue when the scheduled OAC sequence fails. We are unable to see this particular dataset under Data → Dataset folder. However, when we check the dataset through Content Management in the OAC Console, the dataset is visible there. Could you please help us understand what changes or steps…
-
Grand Total Mismatch Issue in OAS
Hello everyone, I'm having trouble understanding why my grand total is showing the wrong number when I sum the values in my rows. The column named "SIT. PC CALC" shows descriptions based on my sales — specifically, whether they are pending ("PENDENTE" in Portuguese) or not pending. The "QTD. PC" column represents the…
-
How to make a Sequence run sequentially?
I feel this used to work the way I expect, so maybe it's a recent change (bug) - but I want to confirm my own understanding before I report anything. I want to use a Sequence to run a list of data flows. I expect each to run through to completion before the next one begins. To do this I've turn on "ordered" in the design.…
-
OAC DV - Download data button on canvas 1 which exports data as a csv from another canvas
In OAC DV, I am trying to achieve data export from a canvas by clicking on a download button on canvas 1. On clicking, I should be able to download the data as csv from another canvas that has a table visualisation. I have tried multiple approaches, but so far has only been able to achieve the navigation and not the…
-
OAC DV, Do we have any feature to have saved customization in DV as similar to Classic BI dashboards
In OAC DV, Do we have any feature in DV workbooks to have saved customization as similar to Classic BI dashboards?
-
OAC DV, Do we have any feature available to set canvas level access permission to different roles?
In OAC DV, Do we have any feature available to set canvas level access permission to different roles
-
Can I change OAC DV AI Assistant oracle logo on "Ask a Question" dialogue box?
We are using Oracle Analytics Cloud (OAC) Data Visualization AI Assistant / “Ask a Question” feature. We would like to know whether it is possible to replace the default Oracle logo/icon shown in the AI Assistant question input dialog with our company logo. Specifically, we are referring to the highlighted logo/icon shown…
-
Remove recipients from agents via command line?
We are having hundreds of agents which contain e.g. outdated email addresses and/or inactive AD users (due to different reasons). Now want to fully remove the recipients from the list of recipients. Within the xml I noticed two tags, specificRecipients and emailRecipients. Example: unsafe:saw:specificRecipients <saw:user…
-
OAC domain type migration Oracle Identity Cloud Service - Enterprise User - User per month to Oracle
If we upgrade OAC domain type license from Oracle Identity Cloud Service - Enterprise User - User per month to Oracle apps premium .. What are the action items to take before migrate the license and is any impact on existing RLS(Row level security) and SSO configurations ?
-
Can we use more than one dataset when using AI Agents?
Is it possible to use more than one dataset when using AI Agents? It is possible with AI Assistant. Is the feature available with AI Agents? If not, will it be made available in future updates? Thank you!
-
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…
-
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…
-
Export OAS data visualization charts to excel
-
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.…
-
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 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…
-
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…
-
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.
