Hi You can use System Settings in OAS to set EVALUATE SUPPORT LEVEL parameter. Login to OAS >>Console >>System Settings and set EVALUATE SUPPORT LEVEL accordingly. Click Apply button for settings to take effect. Thanks Gayathri

Hi Check the dataset that the workbook is based of to see there are any role based filters defined for the dataset. This will restrict data based on roles and will be applicable to visuals and filters. Overview to Using Role-Based Filters Filter a Dataset Based on Application Role Thanks Gayathri

When you performed the step "create script" could it parse your script fine identifying the input, output parameters, etc.? If you test the script outside of dv does it render output fine? Are you passing any input arguments needed in the data flow for the script? You can try to look at session.log or obis-query log for…

Hi The latest Jul 2023 OAC Release has the Bind Parameter feature : Feature Bind parameters to list filters Description Bind a parameter to a workbook's list filter to pass a selected filter value to the parameter. Binding a parameter to a workbook's list filter enables content authors to dynamically accept, store, and…

As @Gianni Ceresa mentioned, for OAC, SSO support is via IDCS and you would have to configure EBS to use same IDCS SSO for a single sign on solution between EBS and OAC. Passing session context via cookies and populating USER/ROLES variables init blocks are not supported for OAC. Have seen some customers use ALTER session…

Hi You can create a new free trial account : Free Trial Account Or use public demo environment : https://www.oracle.com/business-analytics/data-visualization/demos/ Thanks Gayathri

In "present" mode, for the active canvas properties, there is a filter bar section where you choose to include the filters applied to the visualization. When you check these filters to true and do an export the filter pane will be included in the export : Powerpoint output : Thanks Gayathri

Hi The link for SMTP setup is the same : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/set-email-server-deliver-reports.html#GUID-72A0F365-127F-45DB-902C-45E17376B1EC Please check and let us know if you are able to access this link Thanks Gayathri

Hi Please take a look at the recent KM doc that was published on programmatically clearing cache in OAC. Maybe you could schedule this script to be executed after every ETL refresh so oac cache is purged after ETL run : How To Programmatically Clear Cache in Oracle Analytics Cloud(OAC) using JDBC (Doc ID 2956513.1) Thanks…

Hi If your EBS database is on-premise you would have to setup Private Access Channel OR Remote Data Gateway for OAC to connect to the EBS datasource. Please find documentation here…

This is currently not possible in DV. You have to right click to choose the appropriate data action to drill. You can submit a Idea Lab Request for this feature.

Hi We already have the following Idea Requests on same requirement. Kindly upvote/add comment to these ideas : Custom color palettes should not be limited by workbook System wide Custom Color Palette in OAS Upload Custom Color Palette Thanks Gayathri

You would need to share more specific example of your requirement and also provide details of what you tried and the outcome. Please review Date and Time Functions and Conversion Functions to see the available date and conversion functions that you can play around with.

You can share Workbook content via Email in pdf/excel formats, however currently you cannot schedule these jobs. Only Dashboard/Analyses can be scheduled via agents currently. This is a roadmap feature that will most likely be available in future release of OAC.

On a related topic, please also checkout the new feature available in the latest May 2023 Release of OAC on setting Role-based Filters for Datasets. You can Create filters for datasets based on application roles to ensure that consumers of the datasets in workbooks see only data that's relevant to their roles. See Apply…

Please mark the answer as "accepted answer" if it answered your question. This will allow other forum users to benefit from this thread as it will showcase and highlight the pertinent and valid answer.

Briefing Book updateable does not mean it will update based on latest filter/prompt selection, updateable means that if data in underlying database is changed it will update it (provided the corresponding cache settings allows it to).

You may have to click Inspect on the datasets to note down which connection its based of and then delete the relevant datasets that are mapped to the connection that you wish to delete. Agree its not a easy way to do it and you may want to create a Idea Lab Request for this feature. Exploring to see if there are other…

If you open rpd in Admintool and Navigate to Manage > Variables, you can select the specific session variable and check the parameter "allow any user to set value for this variable" checkbox to True and see if this helps.

Currently the Email functionality in DV only supports delivery of content as attachment. To try an alternate option, I did a test by embedding Workbook in Dashboard page and delivering this dashboard page via Agent, but this did not work (shows blank content for workbook in email body). If you include as attachment you see…