Hello, in OAC I am trying to pass parameter values to a workbook via URL. I've seen this is possible and followed some blogs and videos such as this one:
https://medium.com/oracledevs/a-guide-to-embedding-oracle-analytics-into-oracle-application-express-apex-1799f6ba4626
The feature to pass parameters using an URL has been announced in the September 2023 release. However, this solution works only if such parameters are used as filters in reports (the case you can see in this video: https://www.youtube.com/watch?v=PQQewy9SB2c&t=1s) .
When passing parameter values to a workbook where such parameters are used in MyCalculations, the workbook doesn't render any analysis. Here is a sample URL that I am using:
https://afccerinfoboard01oac-ax3ortlezcnf-li.analytics.ocp.oraclecloud.com/ui/dv/ui/project.jsp?pageid=visualAnalyzer&reportpath=%2F%40Catalog%2Fshared%2FSmartBI%2FDV%2FTest%20Massimo%20DV%20Target&p1n=pYear&p1v=2023
Image1: URL working correctly when parameter is used in a filter
Image2: URL not working when parameter is used in MyCalculation
Nothing is rendered:
Has someone achieved this? The problem is probably just about passing the string value ‘2023’ correctly? Can anyone provide the right URL format'
Thanks!