Hi This is a 2 year old thread, appreciate if you can please post your questions in a new thread and make sure to include the flavor of BIP you are using. Thanks Gayathri

Not sure if it was you who submitted SR on this same topic. From the SR screenshot it looked like you were using a custom context root for analytics. We do not support custom context root as documented here : Please share the URL used to connect to catalog manager, you can mask the hostname.

Which product are you using? I know there was an Er in onprem obiee where the the Scope set for the Prompt (in the Dashboard) was not relevant when navigating via an Action link . Old KM doc: Action Link's scope in OBIEE 11g (Doc ID 1539155.1) When i meant navigate to D2, i mean manually selecting dashboard 2.

Hi What happens if you navigate to D2 directly without action link? Does it show the correct value of V1? Seems like you set scope to page for prompt yet you are trying to reference this prompt value in another dashboard, if so why can't you set scope to dashboard? thanks gayathri

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