Hi This seems an incomplete post. Please fix and provide details. Thanks Gayathri

@Benjamin Arnulf-Oracle @Avinash Krishnaram-Oracle Any ETA for the custom color palette roadmap feature? Thanks Gayathri

You should not be using INSERT statements for Init Block SQL. The sql you had for insert was to insert into OAC_LOGIN table and not the INIT_BLOCK_INFO table you have highlighted above, so not sure what exactly you are trying to show above. You should follow best practice for RPD, keep the usage tracking schema definition…

Hi YOu could try to test the report by disabling cache at report level. In Advanced tab add the following to prefix section : SET VARIABLE OBIS_REFRESH_CACHE=1 and see if the performance is better. Thanks Gayathri

Hi We had a similar issue reported by a customer for OAC (not sure if its you) and in this case customer was populating the From field to a specific date because they only wanted data replicated for past 2 months. When we analyzed the logs in OAC backend, we noticed that OAC is sending the extract from date field to fusion…

Hi Can you please share more details of your parameter and filter setup? Is your parameter definition based of logical sql which might result in no data? And when this parameter is used to restrict filter, since there is nothing to filter by it shows all data, seems expected? Maybe i am not getting your use case right.…

I don't think enabling html/css/js for dv workbooks was in the roadmap for march update. You can up-vote/add comment to the following existing Idea Lab Request : Thanks Gayathri

As you have noted, custom tooltip for the viz to display verbose style tooltips relative to the column/measure selected is a work-in-progress item and not available yet. @Avinash Krishnaram-Oracle Please confirm and share any approx ETA if possible. Thanks Gayathri

Here is an existing Idea lab request similar to the requirement you are asking. Please upvote/add comments to this idea : Thanks Gayathri

Hi This forum is specific to Oracle Analytics related issues/questions. It is not clear from your post as to which product you are using . If your question is not specific to Oracle Analytics Cloud or Oracle Analytics Server, please post this question in the appropriate forum for the product you are using. If it is…

Ok Thanks for this update, seems you already have confirmation that this is currently a limitation in the way oac establishes connections. Will see if PMs in this forum have anything more to add to this thread. @Alan Lee - Oracle-Oracle

There may not be an out of the box solution for this requirement, you probably can play around with usage tracking reporting data to see if you can match the logical sql for the saved filter and pull all analyses that have this matching sql. This will only give data for the reports that were executed/run. Other comments…

Hi Analyzing this issue will require looking into your networking setup, oac private access channel setup, etc. Kindly create SR with Oracle Support so we can assist you further. Thank you Gayathri

"but only one day's data is available to the whole workbook and we actually want the termination count for year of 2022." => Not exactly clear what the issue is but if you are looking to only retrieve year part of a date field then you can use YEAR(<yourdatecolumn>). This YEAR function will return just the year and you can…

As Dori mentioned we may have to look to analyze this analysis and sql in more detail. So suggest you to create SR with Oracle Support so we can review and offer further assistance.

You can bind the As of data filter to a parameter and use this parameter in the Expression filter used in the visual. Is this what you are looking for ? Please check Binding Parameters to Filters in Oracle Analytics Thanks Gayathri

In addition to what was mentioned above, for the problematic user login classic home, click on User Profile icon and My Account->Application Roles and verify the Roles assigned. As Gianni mentioned for DV access you can make the customer role or group, a member of a default application role like DVConsumer DVContentAuthor…

Here is an old KM doc from 11g days- 1569615.1 Presentation Catalog Permission Behavior When Same EBS User Logs Into OBIEE Using Different Responsibilities Back And Forth , where suggestion was to disable ACL cache settings in instanceconfig.xml file, not sure if this is still relevant for OAS. Also for OAS I believe the…

Hi Please note the following Idea Lab request for this feature, kindly up-vote this idea and add your comments :https://community.oracle.com/products/oracleanalytics/discussion/9993/display-alerts-in-banner-for-important-user-notifications Thank you Gayathri

Hi Please look into Audit Log capability via OCI Logging : Monitor Usage and Diagnostic Logs Audit logs lets captures the following Log activity in Oracle Analytics Cloud for catalog objects : Catalog objects: Create, update, delete, and permission change operations on all catalog objects, such as classic analyses,…