Here's another version with better look and feel of Redwood theme.

@ALOK SH-Oracle You are correct. In OBIEE, we had the option to access mapviewer. However, this is not the case with OAC. We do not have access to mapviewer or metadata.

Hi Alok, Thanks for the info. I was able to get the resolution to my issue with the help of the development team. We were using Oracle BIEE connection as a source to our BIP data model. Apparently, the BIJDBC connection does not support NVL or NULL values. you need to use CASE WHEN statements to handle the null condition…

Did you add the ingress rule for OAC IP address or the OAC Gateway IP? Check if adding the whole IP range for your OAC region works for you. You can get the whole IP range from here - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/manage-service-access-and-security.html#GUID-2CDD72A9-6445-491B-BDB9-DBE0ACAF87F3

Email configuration from DV and BIP are done separately. You need to setup SMTP configuration from Classic Home -> Administration -> Manage Publisher -> Delivery -> Email

You can use CASE statement or FILTER function to calculate the yield value. For example, 100*(CASE <Accept/Reject column name> WHEN 'Accept' THEN <Count Column Name> ELSE 0 END)/<Count Column Name> OR 100*(FILTER <Count Column Name> USING <Accept/Reject column name> = 'Accept')/<Count Column Name>

Sample output should look like this- Sample - {“access_token”:”...<token shortened>...”,”token_type”:”Bearer”,”expires_in”:100}

Hi Rahul, Can you please share the output of the token generation? Also, please share the script where you have passed the token for authentication.

Hi Rahul, Looks like your token is expired. Default expiry time for the token is 100 seconds. You need to increase the token lifetime. Please check out this thread for step-by-step debug process. https://cloudcustomerconnect.oracle.com/posts/0b267dc94c Feel free to reach out if this doesn't work out. Regards, Neeti

Hi, * If you are looking for a dimension on X-axis and measure on Y-axis, you can use normal line chart and add another dimension in details or color section. * If you are looking to keep dimensions on both axis, you can try a heatmap without measure. Please see attached images for your reference. Regards, Neeti

You can add a new column with CAST function on the original column.

Glad I could help! :) Feel free to connect with me on LinkedIn - https://www.linkedin.com/in/neeti-choksi-081308114

You don't necessarily have to have the exact width and height as that of the canvas. It's just that sometimes the values do block the embedded canvas from being displayed and changing the width and height usually resolves the issue for me. Try with generic height value such as 550px. Also, try removing the position:…

You don't necessarily have to have the exact width and height as that of the canvas. It's just that sometimes the values do block the embedded canvas from being displayed and changing the width and height usually resolves the issue for me. Try with generic height value such as 550px. Also, try removing the position:…

Hi Ankan, Please allow the permissions to your safe domain as displayed in the attached image. If you cannot see the graphs after this, please change the width and height until you see your canvas. I usually keep width: 100%; and height: as per the canvas' height.

Here's an article that talks about changing the timeout using curl command - https://medium.com/@insight2action/oracle-analytics-cloud-embedding-changing-the-idcs-token-timeout-1da9323e1b94 Another way would be directly accessing OAC application from IDCS and increasing the timeout (refer to the screenshot in attached…

Can you please tell me how are you increasing the timeout for the token?

Then it must be the invalid token issue. Can you please share the steps you performed to increase token lifetime and to create the token, and also the output (if possible) of the token creation process?

I see. Have you registered your web server as a safe domain in OAC console with the permission to embed?

Hi Saurabh, As far as I know, the options you are looking for are not available in DV. As a workaround, you can add your canvases to the Dashboard and use Dashboard Prompts as the filters. Regards, Neeti