-
Unable to Assistant feature
Hi All, I have an use case to test the latest Assistant feature in OAC. I have provisioned an instance in Franfurt region with 2 OCPUS and was able to use the Insight feature, but unable to use Assistant feature. Is there a minimum requirement for OCUPUS to use Assistant feature?
-
I am upgrading from OAS to OAC. How can I set the preferred language of a user at logon time?
We have setup IAM on OCI for authentication, and I have a list of users and their preferred language available. Is it possible to set the user's language based on that list (be it as table in the underlying database) or setting it up in IAM? A (simple) test of giving a user in IAM a certain language did not work. Thanks…
-
Failure to upload Repository file (RPD) onto Oracle Analytics Server
Product : Oracle Analytics Version : 12c I am trying to upload an RPD file into my server for the first time using the below command. ./datamodel.sh uploadrpd -I Flexcube_BI0081.rpd -SI ssi -U weblogic -P weblogic123 while doing so, I am getting below error. [nqserror: 94600] failed to update data store folder during…
-
Rejecting a Sworn Statement
It would be very helpful for our company if there was a function to reject the sworn statement without having to reject the entire pay application. Many of our subs fill out the sworn statement incorrectly and we have to reject their pay app for it to be corrected. This causes integration issues on our end as well. Does…
-
Is there a way to customize where data actions show up on a canvas?
I have a canvas with 6 visualizations that all show similar attributes and metrics, For some visualizations I would like a data action to show and for others another or not to show it at all. is this possible?
-
Extracting Oracle Analytics Cloud metadata using Rest API
Hi there, My organization has collected OBIEE metadata in DB tables and we plan to migrate to OAC. We aim to continue using the same data structure as much as we can in order to fit into the existing DB tables and accepting OAC metadata. For the solution, I've been exploring the OAC Rest API calls based on the Oracle…
-
In RDG installed databricks JDBC driver but when we create conenction in OAC getting below error.
In RDG(remote data gateway) installed databricks JDBC driver but when we create datasource conenction in OAC(dv) getting below error in RDG logs.Please someone advise what to do? Error- 2025-02-08 00:46:19 ERROR datasource:pool-3-thread-1 - java.sql.SQLException [Databricks]JDBCDriver Communication link failure. Failed to…
-
DV parameters and unescaped apostrophes
Hi: Is there a way to individually enclose or otherwise "fix" DV parameter values in a delimited list of strings? I'm finding it difficult to handle invalid strings formed by unescaped apostrophes, like, 'O'TOOLE','O'GRADY','D'ADDARIO' As long as the string values are properly enclosed, I seem to be able to use Logical SQL…
-
A column drag box appeared unexpectedly above the bar chart in embedded DV workbook on BI classic
We are on OAS 7.6. One of our report consumers reported this issue where they see a column drag indicator appeared unexpectedly above the stacked bar chart in an embedded DV workbook on the BI classic dashboard. Has anyone seen this before? Is there a way to turn off the ability for users to move columns? We don't want the…
-
OAS Connection Pool Databricks [nQSError: 16003] Column description failed
Hi, created a connection pool with Databricks and I am able to import physical table (import metadata in physical layer) successfully in RPD. However when trying to update row count/view data for any table, encountered issue with " [nQSError: 16003] Column description failed.". can you please suggest on this what could be…
-
Does Oracle Analytics DV 7.6 Support Pagination for REST API Data Sources?
I am trying to connect Oracle Analytics DV to ServiceNow data using a REST API connection. However, the data volume is too large to retrieve in a single load. Does Oracle Analytics DV support pagination for REST API data sources? If so, how can I configure it to handle paginated responses from the API? Any guidance or…
-
Is it possible to embed OAC Data Visualizations into a third party application (Ex:Salesforce URL)
We have a requirement to embed OAC Data Visualizations into a third party application like Salesforce. Has anyone tried and achieved this?
-
OAS 7.0 - unable to download RPD
Hi, We migrated OAS 6.4 to OAS 7.0 (OAS 6.4 from OCI marketplace, customer-managed server). Since then we can not download RDP on the server with datamodel.sh command. Error is: Error - both Trust Store (TS) and Trust Store Password (TSP) values must be passed if using custom certificates. Any help? Tnx and Regards M.
-
OAS DV embedding - Access to font has been blocked by by CORS policy
We have OAS 2024, and are able to successfully embed OAS content on the web page. We are seeing errors in the Console tab in Dev Tools and these are only for .woff and .ttf files. Other files like .gif, .css, .js do not have issues. We have Custom SSO using SAML SSO Docker approach and webpage is establishing SSO first…
-
Hiding a data set from the dataset list while still maintaining necessary access to the dashboard.
I have a dataset containing sensitive information that I want to use to build a visualization in Oracle Analytics Cloud (OAC) for users to access. I've designed my dashboard to restrict visibility so that each user can only see the data associated with their username in the dataset. However, to enable this functionality, I…
-
OAS OBIEE Data level security
Hi All, On OAS environment I have users table like below I have created this table under BIsample schema, also I have built SA on bisample schema. I created one Init block for Authorization - as I want to apply data filter on a report with columns "CountryName", "revenue from fact". when the users of a specific Role access…
-
Calculation: Tableau to OAC
Hi Team, I need help converting calculation syntax from Tableau to OAC. For example, what would the equivalent of { FIXED DATETRUNC('minute',[Appointment Begin Date]), [FIN]: (IF (COUNTD([FIN]))>=1 THEN 1 ELSE 0 END)} this, which is a Tableau calculation look like in OAC. {Image attached for reference}
-
Is it possible to exclude weekends when calculating the time difference in hours between two dates?
Hi, We have a requirement to calculate the time difference in hours between two dates to exclude weekends, issues arise with corner cases, such as when the start date falls on a weekend and the end date falls on a weekday, or when the start date is on a weekday and the end date is on a weekend. In these scenarios, the…
-
Running Balance | Outside Applied Filter
Greetings Community, I'm trying to build a Calculation Named "Balance", wherein it needs to consider Transaction Amounts outside the applied Date Filter since it is running total. I was wondering what is the possibility using inbuilt functions? Because I need Date Filter to show only filtered transactions but this…
-
Manage Time Cards 'Oracle HCM'
Summary Manage Time Cards 'Oracle HCM' Content Hello, I want to build a query in order to get the data from 'Manage Time Cards' screen. Can you please provide me the table names to get the 'Person Name', 'Time Card period', 'Status', 'Total Hours', Recorded Hours' ..... Thanks a lot.
-
Issue with 'Use as a filter' functionality
Hi, I am using the first table as a filter to display data in the second table. When I click on the "Previous Month Activity Amount" in the first table, I expect the second table to show data for the previous month. The "Previous Month Activity Amount" is calculated using the AGO function as follows:…
-
How to export OBIEE 12214 "manage sessions" page?
-
Erro na Consulta na visualização
Boa tarde! Criei uma regra (coluna de fórmula case) em função de um tempo "char" no dataset para utilizá-lo conforme print: dataset aparece normalmente. Mas na visualização o campo "Tempo Médio Espera Consulta" dá o seguinte erro e o dado não é apresentado: Alguém possui uma solução para que o dado seja apresentado na…
-
Issues with Drill Action Links in Oracle Data Visualizer Using Custom Parameters
I’m encountering issues in Oracle Data Visualizer when applying a data action link with pass-through values and parameter values of different types. To provide some context, I’ve created a custom calculation using a CASE statement to combine several attribute columns into a single field. This serves as a custom parameter,…
-
Restore a Catalog Folder from Snapshot
Hello, Is there a way to restore a specific folder from an OAC Snapshot? While we understand that it's possible to restore the entire catalog, our users are specifically asking if it's possible to restore just a single folder in case something happens to it. Thanks, Subhakara
-
Column selectors built in DV using parameters giving incorrect results for Last(Sum()) aggregation f
Hi Team, We have created a DV Report having Column Selector Using Parameters. The report does not give results as expected when measure having Last(Sum()) aggregation function but it is working as expected for only sum() aggregate function. I have raised a product support ticket(4-0000253120), They have mentioned that this…
-
Oracle Analytics Cloudのサーバーで不具合が発生している場合はユーザーに事前に通知できる仕組みを検討してほしい。
先日、OracleAnalytics Cloudのサーバーで不具合が発生しました。 発見したタイミングが使用ユーザーからの問い合わせから発覚しました。 今後、同様な障害が発生したら事前に自社の情報システム部門に通知頂く機能の実装を希望します。 Oracle様側で事前に監査部門で不具合を事前に検知していたということですので そのタイミングで通知できる仕組みを検討ください。
-
“horizontal 100% stacked bar” chart. Can the axis labels be resized?
Right now the Y axis labels are unreadable because of the area being too small. We would like to resize to meet our needs for visibility In other visualisations for example table, we can resize columns manually. Could we enable that on this “horizontal 100% stacked bar” chart?
-
OAC DV - Filter Step Name not saving
Hello, everyone! We have quite an extensive Dataflow in DV which branches into 3 outputs. After branching, our initial step is to apply a filter to each of the branches and we're coming across an issue where we name these filters to easily identify what the branches are but after saving the Dataflow, coming out of it and…
-
Extract the ] delimiter value using Evaluate function in OBIEE RPD and Analytics
Hi All, I Have below field called amount . Requirement is to extract each amount value in seperate columns like amount1,amount2,amount3…..etc 2686.319]2771.295]2601.976]2805.035]2721.763]2507.761 663.666]663.666]663.666]663.666]663.666]663.666 785.400]785.400]785.400]785.400]785.400]785.400…
