-
Why am i getting repeating metrics when i add line number to my report
I have an rpd whose fact table is based on flattened dimensions, in the physical layer the source dimetions together with other tables are joined to fact creating a start schema. Issue is when i create report my metrics are repeated and it seems like whenever i add one specific column my metrics getting repeated in…
-
Possibility to have classic features of Prompts - Hidden variables / Repository var in SQL
Hi What are the chances of bringing options for hidden variables , make it similar classic options in terms of prompt sections with dynamic variables/request variables/ repository / session variables use in the prompts. Thanks, Senthil
-
Access Control Issue: DV Datasets Visible in Classic Analytics
We have observed that, by default, Data Visualization (DV) datasets appear in the “Create Analysis” list under Classic Analytics in OAC, regardless of specific user or role permissions. The background of this issue is that the user currently holds the BI Author role. With this role, users are able to create Classic…
-
Azure AD a Certified Identity Store / LDAP for Oracle Analytics Server (OAS)
Is Azure AD(Entra ID) a Certified Identity Store / LDAP for Oracle Analytics Server (OAS)? Azure AD (Entra ID) → SAML → WebLogic (OAS)
-
How purge OAC Cache programmatically.
OAC version November 2025 OAC is private instance. We followed 2956513.1-BIJDBC_JWTASSERTION-BI-JDBC_Using_JWTAssertion_Steps.pdf BI-JDBC utility is installed on VM within Organization network and not in OCI. bijdbc.properties are updated as per the doc. when "purgeoaccache.sh" is executed it is unable to be connect to…
-
Refreshing repository variables on demand
Does anyone know if there's a way to refresh a Repository variable on demand? There is an option to define the refresh frequency, but I couldn't find a way to refresh it manually.
-
CPU JANUARY-2026 PATCH FOR THE OBIEE 12.2.1.4.0 SOLARIS SPARC SERVER
Kindly suggest the CPU JANUARY-2026 PATCH FOR THE OBIEE 12.2.1.4.0 SOLARIS SPARC SERVER
-
Problem DV in Classic Home Oracle Analytics
Hello Team, I encountered some problems visualizing a DV content in the Classic Home. If I try to view it in the DV section I see the workbook correctly, while if I try to view the workbook in a dashboard page of the classic home, I see "the loading page". I can see this problem also in other projects. Thanks
-
Get path from catalog element, e.g. to be embedded in an agent
Hello Oracle BI experts, We have hundreds of agents where the path of the current location, a full path or a catalog element name is being added, e.g. into the attachment note under delivery content of an agent, example below. Is there a way to use a variable or any other solution to dynamically add the path of the current…
-
Embedding DV Workbook in BI Answers Classic Dashboard - Row Count Safeguard Gap (OAS 2025)
Hello Community, We are currently on Oracle Analytics Server 2025 and using both the Modern DV platform and BI Answers Classic. We have a requirement to embed a DV Workbook inside a Classic BI Dashboard page. Our DV Workbook is built on top of a Subject Area (RPD-based), not a direct database dataset. The Challenge: In BI…
-
Oracle Analytics Instance Access issue
I have registered for Oracle Analytics and AI challenge 2026 and I got provided with access for Oracle Analytics instance. But when I try to access that, it's showing like this.
-
OAC-Derived Date column weekday display on Tooltip
Hello…As shown in below screenshot of a simple bar chart showing Products sold and revenue .We are required to display Weekday(Sunday.Monday,etc) data on the tooltip .However Tooltip section only allows measure data .Kindly advise how to implement this. The requirements are also mentioned below : 1)Displaying Weekday on…
-
Workbook filter - dynamic selection of last 3 / 4 years from the list
OAC version - January 2026 We have workbook(s) with filter (s) and we want make the selections to be dynamic , like latest 3 years from the list OR it could be 4 years . want to make selections dynamic so that when we have cross over next year the selections should be automatic and we don't need to update the selections…
-
BI publisher data connection. ODBC
I am trying to create ODBC on DV data connection. for DSN should I put a entry from TNSNAMES.ora? let me know.
-
When BAR file gets imported from 7.6 to new 8.2
I having issue with some user uploaded data as datasets. most of them are MS.xlsx files. It didn't get imported . Is there anyway, snapshot process captures the dataset files? Or should I download individual file and upload separately? we have about 100 files to deal with it here and user privilege issue as well. Any lead?…
-
"The report runs fine with my user ID, but it takes 22 minutes when the functional user
there is a Employee master data of Physicians report is runs fine with my user ID, but it takes 22 minutes when the functional user please help me this case
-
Report OAC embedding error
We are trying to embed an OAC Report in Saas using sandbox but when we open the application it returns this error: It tried the link outside the page, directly in a web page and it works. So it is a problem just inside the page I created. someone knows how to solve the problem?
-
OAS 2024 BI Model Administration Tool connection fails
Hello community, I hope you are doing well and you can help me with a small issue I am having. I have a recently installed OAS 2024 on RH 8. The Client Tools (also 2024) are installed on a Windows machine, the ODBC DSN is correctly configured, using port 9514, as specified in EM, the firewall rules are in place. All…
-
Automate 'Reload Data' from DV dataset.
How can I configure my Oracle APEX application to automatically refresh the data from an Oracle DB data set after an edit, so that the user sees the change in real-time without needing to click "Reload Data"? It feeds off of the OAS analysis, but the data is sourced from a dataset that is not in the RPD
-
Adding Additional Sources to Logical Table - Can't See Additional Source Data in Subject Area
Hi. I am creating a Semantic Model in OAC & I want to add an additional Source (Table B) to an existing logical table (Logitcal Table A). Table A & Table B are the exact same table structure. However, after I add table B as an additional Source in the Logical Layer to Logical Table A, check for errors & deploy, the subject…
-
Dataflow Failing with “User Exceeded Per File or Overall Quota Limit” Despite Low Storage Usage
Hi, We are facing repeated failures when executing a Dataflow in Oracle Analytics Cloud (OAC). The error message is as follows: [nQSError: 46267] Failed to stream data in chunk through HTTP request - {"prefix":"DSS","code":400301,"message":"User exceeded per file or overall quota limit","subMessage":"User has exceeded…
-
DV Dashboard Filter-List option-display all related items + Selected item and same with dependent.
Hi, DV Dashboard Filter-List option-display all related items + Selected item and same with dependent filter. In 'List' filter. for ex:1 In 'Year' filter display all years and selected year, in 'Month' filter display all months with selected month. Year, Month filters are dependent on each other. Please see image. ex2:…
-
Weblogic version for Analytics
I have received an e-mail today from Oracle that support for Weblogic 12.2.1.4 will end after 2026. Oracle Analytics latest version 8.2 is for Weblogic 12.2.1.4. I was planning to migrate to 8.2 but after above announcement I might postpone it. Is there an upcoming version of Oracle Analytics that will support newer…
-
OAS RCU Error
org.flywaydb.core.api.FlywayException: Validate failed: Detected resolved migration not applied to database: 20160201 at org.flywaydb.core.Flyway.doValidate(Flyway.java:1024) at org.flywaydb.core.Flyway.access$100(Flyway.java:72) at org.flywaydb.core.Flyway$2.execute(Flyway.java:997) at…
-
OAC DV My/Shared Folder structure question
Hi everyone, We've just noticed that when creating new datasets and Dataflows in DV, we're being prompted to select a save location between My Folders and Shared folders (which we're very happy about), whilst up until very recently these used to be saved solely in DV under the Data folder structure. We're wondering if this…
-
OAS Mobile Question
Does anyone know where I can find technical documentation to debug OAS Mobile? I have followed the technical document KB146033 Oracle Analytics Mobile Application for Oracle Analytics Server Configured with Single Sign-On using IAM App Gateway which is essentially the blog Oracle Analytics Mobile Application for Oracle…
-
Conditionally hide a column
Is it possible to hide a Column on a table/pivot based on a (filter based) parameter value?
-
Reference architecture and Analytics Strategy for Logistics Company
Dear community members, Our customer recently gone live with Fusion (ERP, SCM and HCM), OTM, EPM and PaaS extension(ATP). Also FDI ERP and SCM with custom analytics data coming from OTM and PaaS extension. We are looking for any reference architecture, customer reference or any collateral stating about what would be best…
-
OAS Roadmap - Release Date for OAS 2026 features
Hi Product Team & @Alexandria Toothman-Oracle I need your guidance for OAS roadmap.. is there any upgrade coming for OAS in 2026, as compared to OAS 2025. Talking to a customer on upgrade path for OBIEE, as they are leaning towards PowerBI as compared to OAS.
-
How to restrict Custom dashboard based on role access. Should not show dashboard to any other users
Dear Team, Could you please advice How to restrict Custom dashboard based on role access. Should not show dashboard to any other users login with having dashboard access. Regards, Tapas
