Hi @DeepaliG-Oracle , Can you share the command that you are using to invoke the API? Which type of dataset are you trying to reload?

Hi @Jean-Pierre Hoedenaeken , In OAC, resource utilization metrics (e.g. OCPU usage) are not available, but there should be a plan to include them in the OCI Console. You can enable Usage Tracking and then use collected data to monitor metrics over time (e.g. number of queries, number of users, avg execution time, etc.),…

Hi @Jean-Pierre Hoedenaeken , Please use the OCI documentation as a reference: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/administer-services.html#GUID-EE3BF439-B706-481A-8E42-8A3F14137822

Hi @Diana Stevens , I would write a Python script do it. Analyses are stored as XML objects in the catalog, so your script should read them and update only the bit related to the logo. As an alternative, you can remove logos from analyses (either manually or using a script), and use the Manage Themes option in the…

Hi @User_XMRBZ , It helps! You can follow the procedure illustrated in my first reply to achieve your goal. You need to build a separate dashboard prompt objects for each different set of columns that you want to present to your end-users, and then use conditions to dynamically show/hide them. You also need to set a…

Hi @User_XMRBZ , I believe that nobody is willing to open a docx file found on a forum. I suggest you to export it as a PDF and then share it again! 😉

Hi @User_XMRBZ , OBIEE 19c does not exist, but I would proceed as follows either in 11g or 12c: Create a dashboard prompt object to select between C1, C2, and C3 values, and set a presentation variable for it, so you can easily reference the selected value in expressions/filters Create a separate dashboard prompt object…

Hi @la_felA , Parameter values are included in the XML result set when the data model is executed. You can print them in your template as any other field in the result set (e.g. <?P_GENDER?>)

Hi @User_DCJG6 , I would use Developer Tools in Chrome (or an equivalent alternative) to select an element which is not behaving as expected (e.g. the dashboard name), and review the actual style rules related to it. As I already wrote, OAS and OBIEE are different. Even if you are applying the same style (Alta), it doesn't…

Hi @User_GCQ4K , That error is quite common, and is usually caused by a missing comma. I would check the code to confirm whether there is a comma after each column in the SELECT statement (with the exception of the last one)

Hi @User_DCJG6 , This is expected. Styles, skins and themes are different in OAS compared to OBIEE, and you may have to update your custom rules. I recommend to follow the approach described in the documentation to apply custom logos and basic dashboard styles:…

Hi @Jaymie , Yes, I would create a single dashboard page and make the deparment to change dynamically based on the user/recipient who is running it. You can achieve this by using something like the following expression as a filter in the analysis, or to initialize the default selection in the dashboard prompt:…

Hi @User_46H0P , Unfortunately, there is no better alternative that will work with your actual dashboard design (one dashboard page for each manager). You have to create a separate agent for each dashboard page. Running the agent as each recipient could be an option only if you can redesign the dashboard to have the same…

Hi @User_XBGA6 , There is nothing to forgive! In OBIEE things could be more complex than they actually look, and I'm paranoid by default :) If you scheduled the dashboard page then the physical queries are expected to be the same (the agent will apply the default selections made in dashboard prompts). If you scheduled the…

Hi @User_XBGA6 , In addition to what has been suggested by @Mallikarjuna Kuppauru-Oracle , I would also check that the physical queries generated by the analysis and the agent are exactly the same. Moreover.. Since OBIEE 11g is really old and no longer supported, I highly recommend to migrate to the latest version of OAS,…

Hi @kusuma l -Oracle , The documentation states that you can have at most 300 visible columns in a pivot table. It does not mention a maximum number of cells, but I suspect that such a limit is in place. How many years are you displaying the in the pivot? Given that there are 12 months in a year and you have 3 measures,…

Hi @Debadrita Ghosh-Oracle , I'm afraid that OCI policies may not be applied to file links in a dashboard page, so this could be the cause of your error.. What about creating a pre-authenticated request for your private bucket? The only issue is that your users could share the links with unauthorized people as well..

Hi @Jean-Pierre Hoedenaeken , I would try replacing the "BETWEEN" expression filter with 2 separate expressions: TIMESTAMPADD(SQL_TSI_DAY, -4, CURRENT_DATE) >= DateColumn DateColumn <= CURRENT_DATE However, that behaviour is really weird and smells like a bug to me. I would raise a SR.

Hi @kusuma l -Oracle , Can you open the table in the analysis editor and share a screenshot of the Layout Editor (bottom section)? This is required to spot any subptimal design in your analysis. In order to avoid the issue, I highly recommend to reduce the number of columns in your analysis, and eventually split it into…

Hi @Debadrita Ghosh-Oracle , You have to define a dynamic group in OCI Console, map your OAC application to the dynamic group, and then grant it access to your private bucket.