-
Canvas - on Load - Consececutive Queries instead of all at once .
Hii….Hope you're doing good . We have developed a Canvas on ADW having multiple charts/visualizations . When this canvas is loaded ,all the queries of all the charts are fired at once on the database . This is increasing the load drastically on the database . Is there any way to make sure that queries are fired…
-
Is it possible to put conditional formatting on values rather than the background of a column?
-
Issue with Cross SA where metrics are shown as Null in the report
Hi Experts, I'm facing a scenario where, if I upload and use a single Project RPD, the Cross SA Metrics are displayed fine. Where as, if I upload the whole RPD where multiple Projects will be there, the Cross SA Metrics report is displaying null. Can I please get some inputs on this issue?
-
Suggestion required on modeling in analytics
I have a below tables Customer Product ARR (customer_id, quarter_id, product_id, arr) Dimensions: Customer Region (country, region) Product: (product_id, product_name, line_of_business, business_group) hierarchy parent>child: business_group>line_of_business>product_name Quarter: (quarter_key, FY_Quarter, FY) So far simple.…
-
Export API to convert OAC DV Dashboard into a PDF which should take Filter Values
I want to programmatically export a custom OAC DV Dashboard as a pdf so that I can automatically send it to folks. Is there an endpoint that we can make use of? The API endpoint should take filter values that I will mention for that particular Dashboard. Any help is appreciated!
-
Clean Deliveries User Catalog Folder OBIEE 11G
Hi community, Do you know if there's a way to delete or purge the Deliveries Folder of each user in the OBIEE 11g Catalog? I know that there's a tag on instanceconfig file that can limit the size of each user folder, but do you know if there's a way to delete the Deliveries Folder is under…
-
OAC-DAL-001031: Unable to verify the subscription for your tenancy. Please contact Oracle support.
I am trying to create OAC Instance in OCI Environment but giving me above error message
-
OAC Summary-to-Detail Drilldown using Ragged Level-Based Hierarchy
I'm trying to develop a detail report to go with my summary report. Both reports use the same ragged level-based account hierarchy with over ten levels. Most of the action hovers around the 6-9th level, but in theory, this could apply to any level. What I'd like to do is allow the user to click on any sum in the pivot…
-
Kimaya Kapoor Inquiry: Best Practices for Data Visualization in Oracle Analytics
Hi everyone, my name is Kimaya Kapoor. I'm looking for insights on how to best optimize data visualizations in Oracle Analytics. What are some best practices or tips you can share for creating effective and compelling visual representations of data? Any advice on tools or features within Oracle Analytics that can enhance…
-
Semantic Modeler vs. Model Administration Tool in OAS 2025 Migration
Hello Oracle Community, We are currently planning our migration from OAS 2024 to OAS 2025 and are evaluating the use of Semantic Modeler versus continuing to use the Model Administration Tool for managing our RPD/Semantic layer. Could you please provide some insights on the differences between these two tools and help us…
-
dataset page not scrollable in OAS
Hi, We just noticed when using Google Chrome or MS Edge, when navigating to Data > Datasets and then using grid view we can't scroll the page however when we open the same page with the same view option (grid view) using Mozilla Firefox the page is scrollable. Is this a known issue or we're just missing some settings?
-
can you explain this table fusion.ess_request_history in oracle fusion each column
-
How to add custom pop-up description to attribute in FDI OAC visualization
There are attributes which one can select(to build self service dashboard) on the left tab on OAC Workbook. How to add custom description to the attribute to display pop-up when one hover cursor on the attribute. If this is not available any other way to deliver similar functionality.
-
How to manage user-specific preferences, UI labels, themes, and column visibility in OAC?
I have a few questions on Oracle Analytics Cloud and would really appreciate your help: Saving User Preferences in a Workbook: In OAC, is there a way to save user-specific preferences in a workbook? Use case: A user opens a workbook and selects two values from a filter. The next time the same user logs in and opens the…
-
Measure not aggregating with CASE STATEMENT
I have a measure "Ledger Report View"."Posted Trans Amount" with default aggregate of sum. When place in a column by itself it aggregates as expected. But, I need to have two columns using this same measure with different criteria, so I can't just put it into the criteria. I need one col to filter by March, 2024, and one…
-
Mass change using Runcat replace via CLI
I have run the following command to change a string in all catalog elements in the given path: /u01/oracle/config/domains/bi/bitools/bin/runcat.sh -cmd replace -credentials "/mypathtocredentials/file" -online "https://.../analytics-ws/saw.dll" -folder "/shared/Testing/Chris/mass_change" -old "MyOldString" -new…
-
OBIEE Report Fails or Spins When Filters Are Applied – Works Without Filters
Hi everyone, We’re currently experiencing an issue in Oracle BI (OBIEE/OAS) where reports that were previously working are now either spinning indefinitely or returning an error only when filters are applied. 🔍 Issue Summary: When we run the report without filters, it returns all data and loads successfully. As soon as we…
-
Avoid DV Content Author to have access to Machine learning ?
How can I manage to avoid DV Content Author to have access to Machine learning ? I've seen a permissions author_MLmodel but it seems to be strictly bind to va.author : Maybe is it possible to desactivte it but i did not find how to do it Regards Boris.
-
How to get URL which consist parameters(dashboard prompts) used in the DV workbook
Hi, We need to generate a URL which consist the parameter available in the workbook when we share the URL. Requirement is to get similar URL which we get from BIP Report where parameters are configured. Expectation is to configure these Workbook URL under APEX application so users can only access data as per their access .…
-
Guidelines for Cache
Hello Expert, We have been facing some issues with our Analytics. We have been observing some difference in Numbers while running dashboards after ETL refresh. It is not consistent for same Users running different time. We have got feedback from Technical support team that it is because of Cache. I just went through…
-
OAC to PowerBI Error
What we are trying to do is connect OAC to PowerBI. We have followed the steps from this documentation.https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-premises-data-sources-using-data-gateway.html However, when we are trying to use the Subject Areas, we are receiving an error…
-
Unable to Archive BICC Files in UCM daily
Hi Team, We currently have BICC configured in our application, and daily files are being uploaded to the UCM server. The UCM server retains the last three months of BICC files. I would like to know if there is a way to archive these files daily at a specific time. Any input would be greatly appreciated. Thank you! Regards,…
-
Quick Question - Security Update For Oracle Analytics (Doc ID 3029871.1)
We have Oracle Analytics Cloud configured in our tenancy in OCI Ashburn and through private access channels we access data source Exadata cloud service currently with out using any TLS. Does the security Update For Oracle Analytics (Doc ID 3029871.1) will impact us in anyway? since we are yet utilizing TLS for data sources…
-
OAS changing db schema password, breaking the system
Hi, After changing ADB host, 1. DB-URL & Schema password (after WLST encrypt)are updated in these OAS volume files, Path: $DOMAIN_HOME/config/jdbc bip_datasource-jdbc.xml BIPlatformDatasource-jdbc.xml LocalSvcTblDataSource-jdbc.xml mds-owsm-jdbc.xml opss-audit-jdbc.xml opss-auditview-jdbc.xml opss-datasource-jdbc.xml…
-
Answers prompts not sending to embedded DV workbooks in Present Mode in OAS7.6 for some users
Answers prompts are not sending to embedded DV workbooks when the workbook is in 'Present' mode though it works in the Visualize mode in OAS 7.6 for some users Any workarounds for this issue?
-
Help in calculating variance dynamically in Table/Pivot table.
I have sprint estimates and I want calculate difference between average and each sprint total estimates. I am getting below in OAC. Iteration Estimates Product Average Variance 241002 152 107.0 0.0 241016 162 123.0 0.0 241030 173 135.0 0.0 241113 325 134.0 0.0 241120 395 198.0 0.0 I want like this. Iteration Estimates…
-
Experience with Scheduling & Bursting in OAS 2025 Data Visualizer
We are currently on OAS 2024 and planning to move to OAS 2025 in few months. I would like to know if anyone has leveraged the scheduling and bursting functionality available in Oracle Analytics Server (OAS) 2025? I’d love to hear about your experience—any challenges, best practices, or insights on how well it works.…
-
Does anyone in the community know how to customize a network visualization chart to be more readable
Hello, working with a Network Visualization and would like to make it more "readable". The data values being shown are long, does anyone know if this can be manipulated? Been playing around with everything and I can't seem to either make the font smaller or move them around.
-
Prevent all parameters being copied over, when copying a visualization from another workbook
Hi, Is there a way to prevent all workbook parameters being copied over, when copying a visualization from an external workbook - even parameters not being used in the said visualization? Alternatively, is there a way to delete more than one parameters at once? I don't seem to be able to multi-select them. When re-using…
-
Is there a REST API for Product Category Fiscal Classification Codes?
